[B! SQL] dotredã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

dotred id:dotred

SQLã«é–¢ã™ã‚‹dotredã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (18)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã€golangã€‘sqlcã‚³ãƒžãƒ³ãƒ‰ã§ã€ŒSQLã‚¯ã‚¨ãƒªã‹ã‚‰åž‹å®‰å…¨ãªGoã‚³ãƒ¼ãƒ‰ã‚’ç”Ÿæˆã€ã—ã€ç”Ÿç”£æ€§ã‚’ä¸Šã’ãŸã„
ã€golangã€‘sqlcã‚³ãƒžãƒ³ãƒ‰ã§ã€ŒSQLã‚¯ã‚¨ãƒªã‹ã‚‰åž‹å®‰å…¨ãªGoã‚³ãƒ¼ãƒ‰ã‚’ç”Ÿæˆã€ã—ã€ç”Ÿç”£æ€§ã‚’ä¸Šã’ãŸã„ by nao Â· 2022å¹´6æœˆ25æ—¥ å‰æ›¸ãï¼šsqlcã¨ã¯ æœ¬è¨˜äº‹ã¯ã€kyleconroy/sqlcã®åŸºæœ¬çš„ãªæƒ…å ±ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ sqlcã¯ã€DBã‚¹ã‚ãƒ¼ãƒžï¼ˆDBãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ï¼‰ã€SQLã‚¯ã‚¨ãƒªå®šç¾©ã€è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã®3ç‚¹ã‚’ã‚¤ãƒ³ãƒ—ãƒƒãƒˆã¨ã—ã¦ã€åž‹å®‰å…¨ãªCRUDã‚³ãƒ¼ãƒ‰ + DBãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾å¿œã—ãŸãƒ¢ãƒ‡ãƒ«ï¼ˆæ§‹é€ ä½“ï¼‰ã‚’è‡ªå‹•ç”Ÿæˆã—ã¾ã™ã€‚ã“ã“ã§ã®ãƒ¢ãƒ‡ãƒ«ã®è‡ªå‹•ç”Ÿæˆã«ã¯ã€è¤‡æ•°ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’JOINã—ãŸã‚¯ã‚¨ãƒªç”¨ã®æ§‹é€ ä½“ã‚‚å«ã¾ã‚Œã¾ã™ã€‚ å€‹äººçš„ãªè¦–ç‚¹ã§ã¯ã€sqlcã¯ã€ŒSQLã‚¯ã‚¨ãƒªã‚’æ¤œè¨¼ã—ã¦ã‹ã‚‰ã€ãã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹Golangã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã€ã‚¯ã‚¨ãƒªçµæžœã‚’å—ã‘å–ã‚‹ãŸã‚ã®æ§‹é€ ä½“ã‚’æ›¸ãã®ãŒå¤§å¤‰ã€ã¨ã„ã†èª²é¡Œã‚’è§£æ±ºã™ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ç‹¬è‡ªã®DSLï¼ˆDomain Specific Languageï¼‰ã¯æ®†ã©ç™»å ´ã—ãªã„ã®ã§ã€SQLã‚’ã‚´ãƒªã‚´ãƒªæ›¸ã‘ã‚‹
dotred 2022/11/21
golang

SQL

é–‹ç™º
ãƒªãƒ³ã‚¯
Home | DBML
Introâ€‹ DBML (Database Markup Language) is an open-source DSL language designed to define and document database schemas and structures. It is designed to be simple, consistent and highly-readable. It also comes with command-line tool and open-source module to help you convert between DBML and SQL. Table users { id integer username varchar role varchar created_at timestamp } Table posts { id integer
dotred 2020/03/24
database

language

convert

SQL
ãƒªãƒ³ã‚¯
SQLã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ Â· SQL style guide by Simon Holywell
æ¦‚è¦ å…¨èˆ¬ æŽ¨å¥¨ éžæŽ¨å¥¨ å‘½åè¦å‰‡ é€šå‰‡ è¡¨ åˆ— åˆ¥åã€ç›¸é–¢å ã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ çµ±ä¸€çš„æŽ¥å°¾è¾ž å•åˆã›æ–‡ äºˆç´„èªž ç©ºç™½é¡ž ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆ æœ›ã¾ã—ã„å½¢å¼ Createæ–‡ ãƒ‡ãƒ¼ã‚¿åž‹ã®é¸æŠž ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®æŒ‡å®š åˆ¶ç´„ã¨ã‚ãƒ¼ éžæŽ¨å¥¨è¨è¨ˆ ä»˜éŒ² äºˆç´„èªžãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ SQLã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ï¼ˆæ—¥æœ¬èªžè¨³ï¼‰ æ—¥æœ¬èªžè¨³ã«ã¤ã„ã¦ æ—¥æœ¬èªžè¨³ã¯èª¤è¨³ã‚„åŽŸæ–‡ã®æœ€æ–°ç‰ˆã«è¿½éšã—ã¦ã„ãªã„æã‚ŒãŒã‚ã‚Šã¾ã™ã€‚èª¤è¨³ã‚„æ”¹å–„ç‚¹ãŒã‚ã‚Œã°ã€GitHubã®issueã¾ãŸã¯pull requestã‚’ä½¿ç”¨ã™ã‚‹ã‹ã€Twitterã§ãŠçŸ¥ã‚‰ã›ãã ã•ã„ã€‚ ç¿»è¨³: ä¹…åˆ©å²ä¹‹ @nkuritw æ¦‚è¦ ã“ã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã¯åˆ©ç”¨ã®ä»–ã€forkã—ãŸã‚Šã€è‡ªåˆ†è‡ªèº«ã®ã‚‚ã®ã«æ”¹å¤‰ã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§å¤§äº‹ãªã®ã¯ã‚¹ã‚¿ã‚¤ãƒ«ã‚’é¸æŠžã—ãã‚Œã‚’è¸è¥²ã™ã‚‹ã“ã¨ã§ã™ã€‚å¤‰æ›´ã®ææ¡ˆã‚„ãƒã‚°ã®ä¿®æ£ã«ã¯GitHubã®issueã¾ãŸã¯pull requestã‚’ä½¿ç”¨ã—ã¦ãã ã•ã„ã€‚ ã“ã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³
dotred 2018/09/25
style

Coding Style

SQL
ãƒªãƒ³ã‚¯
Go ã® DB ã‚¢ã‚¯ã‚»ã‚¹ç”¨ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ä½œã£ãŸ - Qiita
Go ã® DB ã‚¢ã‚¯ã‚»ã‚¹ç”¨ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ä½œã£ãŸ ç¾åœ¨ã§ã¯ã€æ¬¡ã®3ã¤ã®ã‚µãƒ–ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§æ§‹æˆã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLæ–‡ã‚’çµ„ã¿ç«‹ã¦ã‚‹ãŸã‚ã®ã‚µãƒ–ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸(cue Query Builder) SQLæ–‡ã‚’å®Ÿè¡Œã—ã¦ map ã‚„ struct ã«ãƒžãƒƒãƒ”ãƒ³ã‚°ã™ã‚‹ãŸã‚ã®ã‚µãƒ–ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸(ef Execution Facade) ä¸Šã®2ã¤ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚„ sql.DB, Tx ã®ãƒ©ãƒƒãƒ‘ãƒ¼(dw Database Wrapper) é€šå¸¸ã¯ã€æœ€åˆã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ cue ã¨ã€æœ€å¾Œã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ dw ã‚’ä½¿ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ã“ã®2ã¤ã§ã€ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã¨ ORM ç›¸å½“ã®æ©Ÿèƒ½ã‚’ä½¿ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ 2ç•ªç›®ã® ef ã¯ã€æ—¢ã«ç”Ÿã® SQL æ–‡ãŒã‚ã‚Šã€database/sql ã§é–‹ç™ºã—ã¦ã‚‹(ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã‚‚ä½™è¨ˆãªãƒ©ãƒƒãƒ‘ãƒ¼ã‚‚è¦ã‚‰ãªã„)çŠ¶æ³ã§ã€ORM ç›¸å½“ã ã‘ãŒã»ã—ã„å ´åˆã«ä½¿ã„ã¾ã™ã€‚ å®Ÿéš›ã«ã¯ã€åŒæ§˜ã®æ©Ÿèƒ½ã‚’æœ€å¾Œã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ dw ãŒãƒ©ãƒƒãƒ”ãƒ³
dotred 2016/02/09
SQL

golang
ãƒªãƒ³ã‚¯
GitHub - dataegret/pg-utils: Useful PostgreSQL utilities
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
dotred 2016/01/02
postgresql

SQL
ãƒªãƒ³ã‚¯
GitHub - drone/sqlgen: Go tool for generating sql scanners, sql statements and other helper functions
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
dotred 2015/09/14
SQL

golang
ãƒªãƒ³ã‚¯
Go ã®ã‚·ãƒ³ãƒ—ãƒ«ã‹ã¤æ˜Žå¿«ãª SQL ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ go-sqlf - è©©ã¨å‰µä½œãƒ»æ€ç´¢ã®ã²ã‚ã°
Go ã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ›¸ã„ã¦ã„ã‚‹ã¨ãã€å‹•çš„ã« SQL ã‚’çµ„ã¿ç«‹ã¦ãŸã„å ´åˆã«ã¯ã€ã„ãã¤ã‹ã®æ–¹æ³•ãŒè€ƒãˆã‚‰ã‚Œã¾ã™: ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã‚’ä½¿ã†ã€‚ä¸–ã®ä¸ã«ã™ã§ã«ã„ã‚ã„ã‚å˜åœ¨ã—ã¾ã™ã€‚ï¼ˆãã®ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãªã®ã§ï¼‰å‹•çš„ã«ç”Ÿæˆã™ã‚‹ã«ã¯ã‚‚ã£ã¦ã“ã„ã§ã™ãŒã€ã“ã®å ´åˆã€ãã‚Œãžã‚Œã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«åˆã‚ã›ãŸæ›¸ãæ–¹ã‚’ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã®ã§èªã¿æ‰‹ã«ã‚‚ã‚ã‚‹ç¨‹åº¦è² è·ãŒã‚ã‚‹ç‚¹ã€ã¾ãŸã€Go ã¯è¨€èªžã¨ã—ã¦å†—é•·ã«æ›¸ãã“ã¨ã‚’ã‚ˆã—ã¨ã™ã‚‹æ€æƒ³ã‚’æŒã£ã¦ã„ã‚‹ãŸã‚ã€DSL çš„ãª API ã¨ã®ç›¸æ€§ãŒæ‚ªã„ã¨ã„ã†æ¬ ç‚¹ãŒã‚ã‚Šã¾ã™ï¼ˆmap ã®çµ„ã¿ç«‹ã¦ãŒå†—é•·ã€æ¡ä»¶åˆ†å²ã™ã‚‹å¼ãŒæ›¸ã‘ãªã„ãªã©ï¼‰ã€‚ã¾ãŸã€ä¸€èˆ¬ã«ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ã‹ã‚‰ç”Ÿæˆã•ã‚Œã‚‹ SQL ãŒã‚³ãƒ¼ãƒ‰ã‹ã‚‰æƒ³åƒã—ã¥ã‚‰ããªã‚‹å•é¡Œã‚‚ã‚ã‚Šã¾ã™ã€‚ æ–‡å—åˆ—é€£çµã‚„ fmt.Sprintf ã‚’ä½¿ã†ã€‚ç™ºè¡Œã•ã‚Œã‚‹ SQL ã¯æ¯”è¼ƒçš„åˆ†ã‹ã‚Šã‚„ã™ããªã‚Šã¾ã™ãŒã€å‹•çš„ã«çµ„ã¿ç«‹ã¦ã‚‹ã¨ SQL ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã¨ãƒã‚¤
dotred 2015/09/10
golang

SQL
ãƒªãƒ³ã‚¯
é–‹ç™ºè€…ã®ãŸã‚ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å…¨ã¦
å‰æ›¸ã - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã¯ãªãœé–‹ç™ºè€…ã®ã‚¿ã‚¹ã‚¯ãªã®ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã® å†…éƒ¨æ§‹é€ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä½•ã«ä¼¼ã¦ã„ã‚‹ã‹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰ - äºŒé‡é€£çµãƒªã‚¹ãƒˆ æ¤œç´¢ ãƒ„ãƒªãƒ¼(Bãƒ„ãƒªãƒ¼) - ãƒãƒ©ãƒ³ã‚¹æœ¨ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆI - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é…ãã™ã‚‹2ã¤ã®åŽŸå› where å¥ - æ¤œç´¢ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ãŸã‚ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆ ç‰ä¾¡ æ¼”ç®—å - ä¸€è‡´ã™ã‚‹ã‚ãƒ¼ã®æ¤œç´¢ ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ - ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã„æ–¹ã‚’ç¢ºèª è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - è¤‡æ•°åˆ—ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é…ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ‘ãƒ¼ãƒˆII - å‰ã®å•é¡Œç‚¹ãŒå†ã³ é–¢æ•° - whereå¥ã® ä¸ã§ã®é–¢æ•° å¤§æ–‡å—ãƒ»å°æ–‡å—ã‚’åŒºåˆ¥ã™ã‚‹ æ¤œç´¢ - UPPERã¨ LOWER ãƒ¦ãƒ¼ã‚¶å®šç¾© é–¢æ•° - é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åˆ¶é™ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚ŠéŽãŽ - å†—é•·æ€§ã®æŽ’é™¤æ³• ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿åŒ– ã‚¯ã‚¨ãƒª - ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ãŸã‚ã« ç¯„å›² æ¤œ
dotred 2014/10/20
database

SQL
ãƒªãƒ³ã‚¯
Charming Python: Functional programming in Python, Part 3
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
dotred 2012/06/02
MapReduce

SQL

ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯
ãƒªãƒ³ã‚¯
SQLè„³ã«å„ªã—ã„MongoDBã‚¯ã‚¨ãƒªãƒ¼å…¥é–€ - taka512's blog
mongoã‚³ãƒžãƒ³ãƒ‰ã‹ã‚‰æŽ¥ç¶šã—ãŸéš›ã«ã‚ªãƒ¼ãƒ«ãƒ‰ã‚¿ã‚¤ãƒ—(SQLè„³)ãŸã‚‹æˆ‘ã€…äººé¡žã«ã‚‚ èª¿ã¹ã‚„ã™ã„å½¢ã§insertã€selectã€updateã‚’è¡Œã†æ–¹æ³•ã‚’èª¿ã¹ã¾ã—ãŸã€‚ å®šç¾©å‚ç…§ // use [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å] use [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å] // show databases show dbs // show tables show collectionså‚ç…§ç³» // select * from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å].find() // select * from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] where x=4 db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å].find({x:4}) // select j from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] where x=4 db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å].find({x:4}, {j:1}) // select * from [ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³å] limit 1 db.[ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³
dotred 2012/02/10
MongoDB

SQL
ãƒªãƒ³ã‚¯
å…¨ã¦ã¯æ™‚ã®ä¸ã«â€¦ : ã€Linuxã€‘Linuxã§SQL Serverã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹
2009/3/120:15 ã€Linuxã€‘Linuxã§SQL Serverã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ Linuxã‹ã‚‰SQL Server 2005ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ Linuxã‹ã‚‰SQL Serverã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã«ã¯ã€ODBCæŽ¥ç¶šã‚’åˆ©ç”¨ã—ã¾ã™ã€‚ ODBCæŽ¥ç¶šã‚’åˆ©ç”¨ã™ã‚‹ã«ã¯ã€ä»¥ä¸‹ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ 1.unixODBC 2.FreeTDS ä¸Šè¨˜ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€é©åˆ‡ãªè¨å®šã‚’è¡Œã†ã“ã¨ã§ã€SQL Serverã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã€è¨å®šæ‰‹é †ã§ã™ã€‚ 1.ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ 1)unixodbc a.ä¸Šè¨˜ã®ã‚µã‚¤ãƒˆã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€‚ b.ç”»é¢å·¦å´ã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰[Download]ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã€‚ c.ç”»é¢å³å´ã«ã‚ã‚‹[Download]ã‚’ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã€‚ 2)FreeTDS a.ä¸Šè¨˜ã®ã‚µã‚¤ãƒˆã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€‚ b.ç”»é¢å³å´ã«ã‚ã‚‹[Quick L
dotred 2011/03/09
SQL

server

Linux

database

microsoft
ãƒªãƒ³ã‚¯
djangosnippets: SQL Log Middleware - with multiple databases
Author: guglielmocelata Posted: February 3, 2011 Language: Python Version: Not specified Score: 1 (after 1 ratings) Download Raw This is an improvement of joshua's SQL Log Middleware. If you have more than one database connection, then all queries are logged, grouped by connection. If a connection has no queries, then it's not shown. from django.db import connections from django.template import Te
dotred 2011/02/05
django

template

SQL
ãƒªãƒ³ã‚¯
Djangoã§syncdbã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ã¨ãã«è‡ªä½œã®SQLã‚’å®Ÿè¡Œã—ãŸã„å ´åˆ - ãƒ‰ãƒ©ã‚ã‚Šï¼*ãƒ‰ãƒ©ã‚´ãƒ³ã«æŒ‘ã‚€ã‚¢ãƒªã®ç‰©èªž ** Pythonä½¿ã„ã®æ—¥ã€…
Djangoã‚’ä½¿ã£ã¦ã„ã‚‹ã¨ãã«ã€ç‹¬è‡ªã®SQLã‚’æµã—è¾¼ã¿ãŸã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãã®ã‚ˆã†ãªã¨ãã¯python manage.py syncdbã®ã¨ãã« æ¬¡ã®ã‚ˆã†ãªãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«é…ç½®ã—ãŸSQLã‚’å®Ÿè¡Œã—ã¦ãã‚Œã¾ã™ã€‚ ã¯ä½œæˆä¸ã®ã‚¢ãƒ—ãƒªåã§ã™ã€‚models.pyç‰ãŒé…ç½®ã•ã‚Œã¦ã„ã‚‹ã¨ã—ã¾ã™ã€‚ ãã®é…ä¸‹ã«sqlã¨ã„ã†ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ä½œæˆã—ã¦ã€modelnameï¼ˆmodels.pyã§å®šç¾©ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«åï¼‰ã‚’ ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã‘ã¦ã€sqlã¨ã„ã†æ‹¡å¼µåã§ä¿å˜ã—ã¦ãŠãã¾ã™ã€‚ <appname>/sql/<modelname>.sql Djangoã¯syncdbã§ãƒ¢ãƒ‡ãƒ«ã‚’ä½œæˆã™ã‚‹ã¨ãã«ã“ã“ã‚‚å®Ÿè¡Œã—ã¦ãã‚Œã¾ã™ã€‚ ãƒã‚¤ãƒ³ãƒˆã¯å®Ÿéš›ã®ãƒ¢ãƒ‡ãƒ«åãŒå¤§æ–‡å—ã‚’å«ã‚“ã§ã„ãŸã¨ã—ã¦ã‚‚ã€é…ç½®ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«åã€ãƒ‘ã‚¹ã¯å°æ–‡å—ã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã™ã€‚ ã“ã‚Œã§åˆæœŸãƒ‡ãƒ¼ã‚¿ã‚’å¤§é‡ã«æŠ•å…¥ã—ãŸã„ã¨ãã‚„ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’å¤‰æ›´ã™ã‚‹å ´åˆç‰ã‚‚å¯¾å¿œã§ãã¾ã™ã€‚
dotred 2011/01/24
django

SQL
ãƒªãƒ³ã‚¯
http://sqllite.webdesktop.jp/
dotred 2010/08/30
sql

SQL

programming

tool
ãƒªãƒ³ã‚¯
ã‚¹ãƒˆã‚¢ãƒ‰ã‚’ä½¿ã£ã¦ã€Webã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã‚’ã—ã‚ˆã†ï¼ - moriyoshiã®æ—¥è¨˜
ã“ã‚“ã«ã¡ã¯ã€SQLã‚’æ„›ã—ã¦ã‚„ã¾ãªã„moriyoshiã§ã™ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯ã€ä¸€é€£ã®SQLæ–‡ã‚’ã‚µãƒ–ãƒ«ãƒ¼ãƒãƒ³ã®ã‚ˆã†ã«DBã‚µãƒ¼ãƒã«è¨˜éŒ²ã—ã¦ãŠãã€å¾Œã‹ã‚‰ãã‚Œã‚’å‘¼ã³å‡ºã™ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ä»•çµ„ã¿ã§ã™ã€‚è¿‘ä»£çš„ãªRDBMSã«ã¯æ¨™æº–çš„ã«å‚™ã‚ã£ã¦ã„ã‚‹æ©Ÿèƒ½ã¨ã„ãˆã¾ã™ã€‚ åˆ¶å¾¡æ§‹é€ ãªã©ã‚‚SQLæ–‡ã§è¨˜è¿°ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ã€çµæžœçš„ã«ã€ã‚ã‚‰ã‚†ã‚‹ãƒã‚¸ãƒƒã‚¯ã‚’SQLã®ã¿ã§è¨˜è¿°ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚æ‰‹ç¶šãåž‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«ã©ã£ã·ã‚Šæµ¸ã‹ã£ãŸç¾å ´ã®æ–¹ã‹ã‚‰æ„›ç”¨ã•ã‚Œã¦ã„ã‚‹ã¨è¨€ã‚ã‚Œã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®å¿œç”¨ã¨ã—ã¦ã€Webã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã‚’è¡Œãªã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚Webã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã¨ã¯ã€ç‰¹å®šã®Webã‚µã‚¤ãƒˆã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã€ãã®ãƒšãƒ¼ã‚¸ã®å†…å®¹ (HTML) ã‚’å–å¾—ã€è§£æžã—ã€å¿…è¦ãªæƒ…å ±ã‚’å–ã‚Šå‡ºã™ã¨ã„ã†ä¸€é€£ã®æ“ä½œã‚’è‡ªå‹•åŒ–ã™ã‚‹ã“ã¨ã§ã™ã€‚Webã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°ã‚’åŠ¹æžœçš„ã«æ´»ç”¨ã™ã‚‹ã¨ã€äººé–“ãŒãƒ–ãƒ©ã‚¦ã‚¶ã«å‘ã‹ã£ã¦å˜ç´”ä½œæ¥ã‚’ç¹°ã‚Šè¿”ã™å¿…è¦ãŒãª
dotred 2010/07/16
web

SQL

mysql

ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°

ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£

ãƒã‚¿
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° | Let's POSTGRES
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ ç¬ åŽŸ è¾°ä» ã“ã®è¨˜äº‹ã¯ã€gihyo.jp & Let's Postgres é€£å‹•ä¼ç”»ã€Œä»Šã“ãï¼PostgreSQLã€ã®ç¬¬6å›žè¨˜äº‹ã§ã™ã€‚ç¬¬6å›žç›®ã¯ã€PostgreSQLã®ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚„å†…éƒ¨æƒ…å ±ã‚’è¦‹ã¦ã€ç™ºç”Ÿã—ã¦ã„ã‚‹å•é¡Œã®ç‰¹å®šã¨ãã®å¯¾ç–ã¨ãªã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ãªãŠã€ãƒˆãƒ©ãƒ–ãƒ«ã®ç™ºç”Ÿãƒ»äºˆå…†ã‚’é©åˆ‡ã«æ•æ‰ã™ã‚‹ãŸã‚ã«ã‚‚ã€ãƒã‚°ã®è¨å®šã‚„ç¨¼å‹•çµ±è¨ˆæƒ…å ±ã®ç›£è¦–ã‚’ã—ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã«ã¤ã„ã¦ ãƒˆãƒ©ãƒ–ãƒ«ã¨å¯¾ç–ã®å‰ã«ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®ãƒ¬ãƒ™ãƒ«ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ãŠãã¾ã™ã€‚PostgreSQLã¯è¤‡æ•°ã®ã‚¨ãƒ©ãƒ¼ãƒ¬ãƒ™ãƒ«ã‚’å½±éŸ¿ç¯„å›²ã‚„æ·±åˆ»åº¦ã«ã‚ˆã£ã¦ä½¿ã„åˆ†ã‘ã¦ã„ã¾ã™ã€‚ã‚¨ãƒ©ãƒ¼ãƒ¬ãƒ™ãƒ«ãã‚Œãžã‚Œã®è§£é‡ˆã®ä»•æ–¹ã‚’ä¸‹è¨˜ã®è¡¨ã«ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ã¯ã€æ·±åˆ»ãªçŠ¶æ³ã§ã‚ã‚‹ PANIC ã¨ã€æ€§èƒ½æƒ…å ±ã‚’å«ã‚€ LOG ãƒ¬ãƒ™ãƒ«ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã«æ³¨æ„ã—ã¾ã—ã‚‡ã†ã€‚ä¸€æ–¹ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºè€…
dotred 2009/12/10
postgres

SQL
ãƒªãƒ³ã‚¯
Sudoku solving with one SQL statement using Recursive Subquery Factoring - AMIS Technology Blog | Oracle - Microsoft Azure
dotred 2009/11/02
SQL

ãƒã‚¿

æ•°ç‹¬
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
dotred 2009/07/02
ç™¾å¼ç®¡ç†äººã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°

javascript

jquery

SQL
ãƒªãƒ³ã‚¯
1