[B! sql] stefafafanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

stefafafan id:stefafafan

sqlã«é–¢ã™ã‚‹stefafafanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (21)

${{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}}

Getting started with otelsql, the OpenTelemetry instrumentation for Go SQL
Getting started with otelsql, the OpenTelemetry instrumentation for Go SQL otelsql is an instrumentation library for the database/sql library of the Go programming language. It generates traces and metrics from the application when interacting with databases. By doing that, the library allows you to identify errors or slowdowns in your SQL queries that potentially impact the performance of your ap
stefafafan 2024/12/08
opentelemetry

sql

observability
ãƒªãƒ³ã‚¯
sq
sq is a free/libre open-source data wrangling swiss-army knife to inspect, query, join, import, and export data. You could think of sq as jq for databases and documents, facilitating one-liners like:
stefafafan 2024/10/07
database

sql

jq
ãƒªãƒ³ã‚¯
Announcing TypedSQL: Make your raw SQL queries type-safe with Prisma ORM
Generate query functions by using the --sql flag on prisma generate: Import the query function from @prisma/client/sql â€¦ â€¦ and call it inside the new $queryRawTyped function to get fully typed results ðŸ˜Ž If your SQL query has arguments, they are provided to the query function passed to $queryRawTyped The Prisma Client API together with TypedSQL provides the best experience for both CRUD operations
stefafafan 2024/08/28
typescript

sql

orm

prisma
ãƒªãƒ³ã‚¯
SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL
Philosophy We strive to create an environment conducive to many different types of research across many different time scales and levels of risk. Learn more about our Philosophy Learn more
stefafafan 2024/08/25
sql
ãƒªãƒ³ã‚¯
sqlcã¨dockertestã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ãŸãƒ†ã‚¹ãƒˆã‚’æ›¸ã“ã† | gihyo.jp
Goã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã¨ãƒ†ã‚¹ãƒˆ Goã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹éš›ã«ã¯ã€æ¨™æº–ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã‚ã‚‹database/sqlã€GORMã€entãªã©ã®æ§˜ã€…ãªé¸æŠžè‚¢ãŒå˜åœ¨ã—ã¾ã™ã€‚å¤šãã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã¯Goã®ã‚³ãƒ¼ãƒ‰ã‚’å®šç¾©ã—ã¦SQLã‚’ç”Ÿæˆã—ã¾ã™ãŒã€sqlcã¯SQLã‚’ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¦Goã®ã‚³ãƒ¼ãƒ‰ã‚’ç”Ÿæˆã™ã‚‹ã®ãŒç‰¹å¾´ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ ã“ã®ã‚¢ãƒ—ãƒãƒ¼ãƒã«ã¯ã€æœ€çµ‚çš„ã«å®Ÿè¡Œã•ã‚Œã‚‹SQLãŒæ˜Žã‚‰ã‹ã§ã‚ã‚‹ã“ã¨ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã‚„ã‚Šã¨ã‚Šã™ã‚‹ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’è‡ªåˆ†ã§å®šç¾©ã™ã‚‹å¿…è¦ãŒãªã„ã“ã¨ã¨ã„ã£ãŸãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ™‚ã«SQLã‚’è§£æžã—åž‹ã‚„å¼•æ•°åã®é–“é•ã„ã‚’æ¤œå‡ºã§ãã¾ã™ã€‚ãã—ã¦ãªã«ã‚ˆã‚Šã€éžå¸¸ã«ã‚·ãƒ³ãƒ—ãƒ«ã§ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€sqlcã®ä¸€æ©é€²ã‚“ã ä½¿ã„æ–¹ã¨ã—ã¦dockertestã¨çµ„ã¿åˆã‚ã›ãŸãƒ†ã‚¹ãƒˆã®æ›¸ãæ–¹ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚dockertestã¨ã¯ã€Dockerã‚³ãƒ³ãƒ†ãƒŠã‚’ç«‹ã¡ä¸Šã’ã¦ãƒ†ã‚¹ãƒˆã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã®ä½¿ã„ã‚„ã™ã„ã‚³ãƒžãƒ³ãƒ‰ã‚’æä¾›
stefafafan 2023/12/19
golang

sql

test
ãƒªãƒ³ã‚¯
GitHub - xo/xo: Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
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
stefafafan 2023/10/13
golang

sql
ãƒªãƒ³ã‚¯
goquã‚’é§†ä½¿ã—ã¦goã§SQLæ§‹ç¯‰ã‚‚æ§‹é€ ä½“ãƒžãƒƒãƒ”ãƒ³ã‚°ã‚‚RDBãƒ†ã‚¹ãƒˆã‚‚ã‚„ã‚‹ - ã‚¨ãƒ ã‚¹ãƒªãƒ¼ãƒ†ãƒƒã‚¯ãƒ–ãƒã‚°
ã€Unit4 ãƒ–ãƒã‚°ãƒªãƒ¬ãƒ¼6æ—¥ç›®ã€‘ ã“ã‚“ã«ã¡ã¯ã€ã‚¨ãƒ ã‚¹ãƒªãƒ¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã‚°ãƒ«ãƒ¼ãƒ—ã®ç¦æž— (@fukubaya) ã§ã™ã€‚ æœ€è¿‘ã¾ã§é–‹ç™ºã—ã¦ã„ãŸm3ãƒ©ã‚¦ãƒ³ã‚¸ã§ã¯ã€goã‹ã‚‰RDBã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã—ãŸã€‚ m3ãƒ©ã‚¦ãƒ³ã‚¸ã§ã¯ã€SQLã®çµ„ã¿ã‚„ã™ã•ã‚„ãƒ†ã‚¹ãƒˆã®ã—ã‚„ã™ã•ã®è¦³ç‚¹ã§æ¤œè¨Žã—ãŸçµæžœã€goquã‚’æŽ¡ç”¨ã—ã¾ã—ãŸã®ã§ã€ ãã“ã§å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã¨ãã®å®Ÿè£…ä¾‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã“ã‚Œã‹ã‚‰è©¦ã—ã¦ã¿ã‚‹æ–¹(ã¨å°†æ¥m3ãƒ©ã‚¦ãƒ³ã‚¸ã®é–‹ç™ºã«æ–°ãŸã«å…¥ã‚‹ã“ã¨ã«ãªã£ãŸãƒ¡ãƒ³ãƒãƒ¼)ã®å‚è€ƒã«ãªã‚‹ã‚ˆã†ã«ã€ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã‚‚èª¬æ˜Žã‚‚å¤šããªã£ã¦ã—ã¾ã„ã‹ãªã‚Šé•·ã„ã§ã™ã€‚ ãŠæ™‚é–“ã‚ã‚‹æ™‚ã«ãŠèªã¿ã„ãŸã ã‘ã‚Œã°ã€‚ åå¤å±‹åŸŽã¯ã€æ—¥æœ¬ã®åŸŽã®ã²ã¨ã¤ã€‚å°¾å¼µå›½æ„›çŸ¥éƒ¡åå¤å±‹ï¼ˆç¾åœ¨ã®æ„›çŸ¥çœŒåå¤å±‹å¸‚ä¸åŒºæœ¬ä¸¸ãƒ»åŒ—åŒºååŸŽï¼‰ã«ã‚ã‚‹ã€‚æœ¬æ–‡ã«ã¯ç‰¹ã«é–¢ä¿‚ã‚ã‚Šã¾ã›ã‚“ã€‚ m3ãƒ©ã‚¦ãƒ³ã‚¸ goqu å®Ÿä¾‹ modelã®æ§‹é€ ä½“ mapper mapperã®å®Ÿè£… goquã®SQLã®çµæžœã‹ã‚‰æ§‹é€ ä½“ã¸ã®ãƒžãƒƒãƒ”ãƒ³ã‚°
stefafafan 2023/08/30
golang

sql
ãƒªãƒ³ã‚¯
Bun: SQL client for Golang
SQL-firstBun's goal is to help you write SQL, not to hide it behind awkward constructs.
stefafafan 2023/08/29
golang

sql
ãƒªãƒ³ã‚¯
entã‚’ä½¿ã£ãŸçœã‚¨ãƒãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰é–‹ç™º | ãƒ¡ãƒ«ã‚«ãƒªã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ãƒ¡ãƒ«ã‚«ãƒªã§Software Engineerã‚’ã‚„ã£ã¦ã„ã‚‹akkie30ã§ã™ã€‚ ã“ã®è¨˜äº‹ã¯ã€Mercari Advent Calendar 2021 ã®5æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ç§ã®ãƒãƒ¼ãƒ ã§ã¯åŠå¹´ã»ã©å‰ã‹ã‚‰Goã®ORMãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦entã‚’æŽ¡ç”¨ã—ã¦ã„ã¾ã™ã€‚æœ¬è¨˜äº‹ã§ã¯entã«é–¢ã™ã‚‹çŸ¥è¦‹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ entã¨ã¯ æ–°ã—ã„Microserviceã‚’å®Ÿè£…ã™ã‚‹éš›ã«å¿…ãšè°è«–ã«ãªã‚‹ã®ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã€ãã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®èªã¿æ›¸ãã‚’è¡Œã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®é¸å®šã§ã™ã€‚ãƒ¡ãƒ«ã‚«ãƒªã®Microservicesã§ã¯ä¸»ã«GCPã‚’æŽ¡ç”¨ã—ã¦ã„ã‚‹ãŸã‚ã€Spanner, CloudSQL, BigTable, Datastoreãªã©ã‚’ç”¨ã„ã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ ç§ã®ãƒãƒ¼ãƒ ã§ã¯ç¾åœ¨æ–°è¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™ºã—ã¦ãŠã‚Šã€ã‚µãƒ¼ãƒè²»ç”¨ã‚’ä½ŽãæŠ‘ãˆã¤ã¤æ©Ÿèƒ½æ€§ã‚‚æ±‚ã‚ãŸçµæžœCloudSQLã‚’æŽ¡ç”¨ã—ã¦ã„ã¾ã™ã€‚Souzohã®æŠ€è¡“é¸å®šã«ã‚‚å½±éŸ¿ã‚’å—ã‘ã€ç§
stefafafan 2023/08/26
golang

sql
ãƒªãƒ³ã‚¯
Go ã® sql.DB ãŒã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚’ç®¡ç†ã™ã‚‹ä»•çµ„ã¿
Go ã® database/sql ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ ã® DB æ§‹é€ ä½“ ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚’ç®¡ç†ã—ã€ã‹ã¤ã‚¹ãƒ¬ãƒƒãƒ‰ã‚»ãƒ¼ãƒ• (goroutine ã‚»ãƒ¼ãƒ•ã¨è¨€ã£ãŸã»ã†ãŒè‰¯ã„ã®ã ã‚ã†ã‹â€¦?) ã«ãã‚Œã‚‰ã®æŽ¥ç¶šã‚’ä½¿ç”¨ã§ãã‚‹ã“ã¨ã‚’ä¿è¨¼ã—ã¦ã„ã‚‹ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ã«ã‚‚æ¬¡ã®ã‚ˆã†ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ã€‚ DB is a database handle representing a pool of zero or more underlying connections. Itâ€™s safe for concurrent use by multiple goroutines. ã“ã¡ã‚‰ã®åŸºæœ¬çš„ãªå®Ÿè£…å†…å®¹ã¨ã€å‹•ä½œã‚’åˆ¶å¾¡ã™ã‚‹ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ãŸã€‚ åŸºç¤ŽçŸ¥è˜ã®ãŠã•ã‚‰ã„ database/sql ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¯ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®å®Ÿè£…ã«ã‚ˆã‚‰ãªã„ä¸€èˆ¬çš„ãª SQL ã®ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ã€‚å…·ä½“çš„ãªãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¸ã®æŽ¥
stefafafan 2023/06/10
database

golang

sql
ãƒªãƒ³ã‚¯
Software Designã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é€Ÿæ”»å…¥é–€ã€ã«ã€ŒSQL50æœ¬ãƒŽãƒƒã‚¯ã€ãŒæŽ²è¼‰ã•ã‚Œã¾ã—ãŸ - LIVESENSE ENGINEER BLOG
ãƒªãƒ–ã‚»ãƒ³ã‚¹ã§ãƒ‡ãƒ¼ã‚¿ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ã—ã¦ã„ã‚‹å¯Œå£«è°·ã§ã™ã€‚ Software Designã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢é€£ã™ã‚‹ç‰¹é›†è¨˜äº‹ã‚’å†æ§‹æˆã—ãŸã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é€Ÿæ”»å…¥é–€ ï½žãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã‹ã‚‰SQLã®æ›¸ãæ–¹ã¾ã§ã€ãŒã€2023å¹´3æœˆã«ç™ºå£²ã•ã‚Œã¾ã—ãŸã€‚ gihyo.jp ãƒªãƒ–ã‚»ãƒ³ã‚¹ãŒSoftware Design 2017å¹´11æœˆå·ã«å¯„ç¨¿ã—ãŸã€Œãƒ‡ãƒ¼ã‚¿åˆ†æžã«åŠ¹ãSQL50æœ¬ãƒŽãƒƒã‚¯ã€ãŒã€å†…å®¹ã‚’æ›´æ–°ã—ã¦å†æŽ²è¼‰ã•ã‚Œã¾ã—ãŸã€‚ ä»Šå›žã€å†æŽ²è¼‰ã«ã‚ãŸã£ã¦ã€ã€ŒSQL50æœ¬ãƒŽãƒƒã‚¯ã€ã®å†…å®¹ã®æ›´æ–°ã‚’ç§ãŒæ‹…å½“ã—ã¾ã—ãŸã®ã§ã€ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ SQL50æœ¬ãƒŽãƒƒã‚¯ ã€ŒSQL50æœ¬ãƒŽãƒƒã‚¯ã€ã¯ã€SQLã€ç‰¹ã«SELECTæ–‡ã®æ¼”ç¿’å•é¡Œé›†ã§ã™ã€‚ PostgreSQLã‚’Dockerã§ç«‹ã¡ä¸Šã’ã¦ã€ã‚‚ã£ã¨ã‚‚ã‚·ãƒ³ãƒ—ãƒ«ãªä¾‹ã‹ã‚‰å®Ÿè¡Œã—ã€WHEREå¥ã€LIMITå¥ãªã©ã‚’ä¸€ã¤ä¸€ã¤ä½“é¨“ã—ã€æœ€å¾Œã«ã¯ã€ç§»å‹•å¹³å‡ã¨ã„ã£ãŸé«˜åº¦ãªæ–‡æ³•ã‚’ç¿’å¾—ã™ã‚‹äº‹ãŒã§ãã¾ã™ã€‚ ã“ã‚Œã‚’èªã‚ã°ã€SQLã‚’ä½¿ã£
stefafafan 2023/03/08
sql

book
ãƒªãƒ³ã‚¯
Genericsã‚’ä½¿ã„ãƒŸã‚¹ã‚’é˜²ãSQL Builderã€ŒGenORMã€
Go 1.18ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸãã€‚ Go 1.18ã®æ–°æ©Ÿèƒ½ã®ä¸ã§æœ€ã‚‚æ³¨ç›®ã‚’é›†ã‚ã¦ã„ã‚‹æ©Ÿèƒ½ã¯ã‚„ã¯ã‚Šã‚¸ã‚§ãƒãƒªã‚¯ã‚¹ã ã¨æ€ã„ã¾ã™ã€‚ ãã®ã‚¸ã‚§ãƒãƒªã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã¦SQLã«é–¢ã™ã‚‹ãƒŸã‚¹ã‚’ã§ãã‚‹é™ã‚Šã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã®æ®µéšŽã§é˜²ãã“ã¨ã‚’ç›®æŒ‡ã™SQL Builderã€ŒGenORMã€ã‚’ä½œã£ãŸã®ã§ã€ã“ã®è¨˜äº‹ã§ã¯ãã®ç´¹ä»‹ã‚’ã—ã¦ã„ãã¾ã™ã€‚ ãƒªãƒã‚¸ãƒˆãƒª: https://github.com/mazrean/genorm ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ: https://mazrean.github.io/genorm-docs/ja/ ã‚³ãƒ¼ãƒ‰ä¾‹ ä»•çµ„ã¿ã®èª¬æ˜Žã®å‰ã«ã€GenORMã®ã‚³ãƒ¼ãƒ‰ä¾‹ã‚’è¦‹ã¦ã„ãŸã ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ CREATE TABLE `users` ( `id` char(36) NOT NULL, `name` varchar(64) NOT NULL, `password` char(
stefafafan 2023/01/22
golang

sql
ãƒªãƒ³ã‚¯
SQLã‚’é€Ÿãã™ã‚‹ãžâ€•ãŠæ‰‹è»½ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ã“ã®ã‚µã‚¤ãƒˆã§ã¯ã€SQL ã‚’é«˜é€ŸåŒ–ã™ã‚‹ãŸã‚ã®ã¡ã‚‡ã£ã¨ã—ãŸãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®æŠ€è¡“ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ã¨è¨€ã£ã¦ã‚‚ã€ã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQLã€€ç¬¬2ç‰ˆã€ã®å—ã‘å£²ã‚ŠãŒã»ã¨ã‚“ã©ãªã®ã§ã€ã“ã®æœ¬ã‚’èªã‚“ã§ã„ãŸã ã‘ã‚Œã°ã€æœ¬ç¨¿ã‚’èªã‚€å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ æœ€åˆã«ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹å…¨ä½“ã®æ–¹é‡ã‚’è¿°ã¹ã¦ãŠãã¨ã€ãã‚Œã¯ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ï¼ˆä¸€ç•ªé…ã„ã¨ã“ã‚ï¼‰ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã§ã™ã€‚å½“ãŸã‚Šå‰ã§ã™ãŒã€æ—¢ã«ååˆ†é€Ÿã„å‡¦ç†ã‚’ã‚‚ã£ã¨é€Ÿãã—ãŸã¨ã“ã‚ã§ã€ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¯å½±éŸ¿ã—ã¾ã›ã‚“ã€‚å¾“ã£ã¦ã€Œå‡¦ç†ãŒé…ã„ã€ã¨æ„Ÿã˜ãŸã‚‰ã€æœ€åˆã«ã™ã‚‹ã“ã¨ã¯ã€SQL ã‚„ã‚¢ãƒ—ãƒªã®æ”¹ä¿®ã§ã¯ãªãã€ã€Œã©ã“ãŒé…ã„ã®ã‹ã€ã‚’èª¿æŸ»ã™ã‚‹ã“ã¨ã§ã™ã€‚ã„ããªã‚Šã‚ã¦ãšã£ã½ã†ã§æ”¹å–„ã‚’ã¯ã˜ã‚ã¦ã‚‚åŠ¹æžœã¯å‡ºã¾ã›ã‚“ã€‚åŒ»è€…ãŒæ‚£è€…ã‚’è¨ºã‚‹ã¨ãæœ€åˆã«ã™ã‚‹ã“ã¨ãŒæ¤œæŸ»ã§ã‚ã‚‹ã®ã¨åŒã˜ã§ã™ã€‚ç—…å› ãŒä½•ã§ã‚ã‚‹ã‹ã‚’çªãæ¢ã‚ã¦ã‹ã‚‰ã§ãªã„ã¨ã€æ£ã—ã„å‡¦æ–¹ã¯ã§ããªã„ã®ã§ã™ã€‚ ãã®åŸºæœ¬ã‚’æ‰¿çŸ¥ã—ã¦ã„ãŸã ã„ãŸ
stefafafan 2023/01/13
sql
ãƒªãƒ³ã‚¯
æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã§sqlcã‚’å°Žå…¥ã—ã¦è‰¯ã‹ã£ãŸç‚¹ã¨ãƒãƒžã£ãŸç‚¹ | ãƒ•ãƒ¥ãƒ¼ãƒãƒ£ãƒ¼æŠ€è¡“ãƒ–ãƒã‚°
ã¯ã˜ã‚ã«Techno goly Innovation Group è¾»ã§ã™ã€‚Go ã«ã¯ Gorm ã‚„ SQLBoiler ã‚’ã¯ã˜ã‚ã¨ã—ã¦æ§˜ã€…ãª O/Rãƒžãƒƒãƒ‘ ãŒã‚ã‚Šã¾ã™ã€‚2021 å¹´ã«ã¯å½“ç¤¾ã®ãƒ–ãƒã‚°ã§ OR ãƒžãƒƒãƒ‘ãƒ¼ã®é€£è¼‰ã‚’è¡Œã£ãŸã“ã¨ã‚‚ã‚ã‚Šã¾ã—ãŸã€‚çµ¶å¯¾çš„ãª O/Rãƒžãƒƒãƒ‘ ãŒã‚ã‚‹ã‚ã‘ã§ã¯ãªãã€æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã®ç‰¹æ€§ã‚„ãƒãƒ¼ãƒ æ§‹æˆãªã©ã«åˆã‚ã›ã¦ O/Rãƒžãƒƒãƒ‘ ã‚’é¸æŠžã™ã‚‹ã“ã¨ã«ãªã‚‹ã§ã—ã‚‡ã†ã€‚ ä»Šå›žã€ç§ãŸã¡ã®ãƒãƒ¼ãƒ ã§ã¯ã€ãƒãƒƒãƒå‡¦ç†ãŒä¸å¿ƒçš„ãªæ¥å‹™ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«ãŠã„ã¦ Go ã® O/Rãƒžãƒƒãƒ‘ ã« sqlc ã‚’æŽ¡ç”¨ã—ã¾ã—ãŸã€‚ç´ ã® SQL ã‚’æ›¸ã„ã¦ã„ããƒãƒ¼ãƒ ã®é–‹ç™ºæ–¹é‡1ã¨ãƒžãƒƒãƒã—ã€é–‹ç™ºä½“é¨“ã¯éžå¸¸ã«è‰¯ã‹ã£ãŸã§ã™ã€‚ä¸€æ–¹ã€æž¯ã‚Œãã£ã¦ã¯ã„ãªã„ O/Rãƒžãƒƒãƒ‘ ã§ã¯ã‚ã‚Šã¾ã™ã€‚ã„ãã¤ã‹æƒ³å®šå¤–ã®æŒ™å‹•ãŒç™ºç”Ÿã— GitHub ã® Issue ã‚’è¦‹ãªãŒã‚‰å•é¡Œã‚’åˆ‡ã‚Šåˆ†ã‘ã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã—ãŸã€‚ ã“ã‚Œã‹ã‚‰ sqlc ã‚’å°Žå…¥ã—ã¦ã¿ã‚ˆã†ã‹ãªã€ã¨è€ƒãˆ
stefafafan 2023/01/05
golang

sql
ãƒªãƒ³ã‚¯
30æ™‚é–“åˆ¶ã« SQL ã§ç«‹ã¡å‘ã‹ã† - TVer Tech Blog
ã„ã‚ˆã„ã‚ˆå¹´æœ«ã§ã™ãã€‚åˆ†æžæ‹…å½“ã®æ£®è—¤ã§ã™ã€‚ ã“ã®è¨˜äº‹ã¯ TVer ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ 24æ—¥ç›®ã®è¨˜äº‹ã§ã™ (é…ããªã‚Šã¾ã—ãŸ) ã¿ãªã•ã¾ã¯ã¯ã¦ãªæ™‚é–“ã¨ã„ã†ã‚‚ã®ã‚’èžã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ã§ã—ã‚‡ã†ã‹ï¼Ÿ q.hatena.ne.jp ã¾ãŸã€ãƒ¬ãƒãƒ¼ãƒˆãªã©ã®ç· ã‚åˆ‡ã‚Šã‚’ç¢ºèªã™ã‚‹ã¨ãã«ã€Œä»Šæ—¥ã¾ã§ã®ç· ã‚åˆ‡ã‚Šã£ã¦â—¯â—¯ã•ã‚“ãŒæ¥å‹™ã‚’é–‹å§‹ã™ã‚‹æ˜Žæ—¥ã®8æ™‚ã¾ã§ã§ã™ã‚ˆãï¼Ÿã€ã¨ã„ã†ç¢ºèªã‚’ã—ãŸã“ã¨ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã“ã®ã‚ˆã†ãªã€Œæ—¥ã¯å¤‰ã‚ã£ã¦ã—ã¾ã£ãŸãŒã€å‰æ—¥ã¨ã—ã¦æ‰±ã†ã“ã¨ãŒä¾¿åˆ©ãªå ´åˆã€ã«24æ™‚ã‚’é£›ã³è¶Šãˆã€26æ™‚ã‚„28æ™‚ã€ã¨è¡¨ç¾ã™ã‚‹ã“ã¨ãŒæœ‰ã‚Šã¾ã™ã€‚ ã“ã®è¡¨ç¾ã®ã“ã¨ã‚’ã€Œ30æ™‚é–“åˆ¶ã€ã¨è¨€ã†ã‚‰ã—ã„ã§ã™ã€‚ ja.wikipedia.org ç‰¹ã«æ”¾é€æ¥ç•Œã§ã¯24æ™‚ã‚’è¶Šãˆã¦ã‹ã‚‰ã®æ·±å¤œç•ªçµ„ã®è¡¨ç¾ã‚’å½“æ—¥ã¨ã—ã¦æ‰±ã†ã»ã†ãŒéƒ½åˆãŒã„ã„ãŸã‚é »ç¹ã«ã€Œ25æ™‚23åˆ†ã‹ã‚‰ã€ã¨ã„ã†å½¢ã§è¨˜è¿°ã•ã‚Œã€ãã—ã¦ã€ã“ã®æƒ…å ±ãŒãã®ã¾ã¾ç§é” TVer ã«ã¯æ¸¡ã£ã¦ãã¾ã™ã€‚ UTC ã«
stefafafan 2022/12/30
ã“ã‚Œã‚’SQLä¸€ç™ºã§å¯¾å¿œã—ã¦ã‚‹ã®ãŒã‚“ã°ã‚ŠãŒã‚ã‚‹

tver

mysql

sql
ãƒªãƒ³ã‚¯
TOPSIC SQL CONTEST
SQLã‚¹ã‚ãƒ«ã‚’ç«¶ã†ã‚³ãƒ³ãƒ†ã‚¹ãƒˆã‚µã‚¤ãƒˆã§ã™ã€‚ã‚³ãƒ³ãƒ†ã‚¹ãƒˆæ™‚é–“å†…ã«å‡ºé¡Œã•ã‚ŒãŸå•é¡Œã«å¯¾ã™ã‚‹è§£ç”ï¼ˆSQLæ–‡ï¼‰ã‚’ä½œæˆã—ã€æå‡ºã—ã¦ã„ãå½¢å¼ã«ãªã‚Šã¾ã™ã€‚èª°ã§ã‚‚ãŠæ°—è»½ã«ã”å‚åŠ ã„ãŸã ã‘ã¾ã™ã€‚
stefafafan 2022/07/03
sql

contest
ãƒªãƒ³ã‚¯
ã€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ã‚’ã‚´ãƒªã‚´ãƒªæ›¸ã‘ã‚‹
stefafafan 2022/06/29
golang

sql
ãƒªãƒ³ã‚¯
MySQL ã§è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹éš›ã«ã¯å¿…ãš Explain ã® key_len ã‚’ç¢ºèªã™ã¹ãã¨ã„ã†è©±
ã€ŒRails Developers Meetup 2018 ã§ã€ŒMySQL/InnoDB ã®è£å´ã€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€ã§ã¡ã‚ƒã‚“ã¨è§¦ã‚Œã‚‰ã‚Œã¦ãªã„ã®ã§ä»Šæ›´ãªãŒã‚‰ key_len ã«ã¤ã„ã¦è£œè¶³ã—ã¾ã™ã€‚ç™ºè¡¨ã§è§¦ã‚ŒãŸå†…å®¹ã«ã¤ã„ã¦ã¯è¨€åŠã—ãªã„ã®ã§ã€storage engine ã‚„ B+ tree ã¨ã„ã£ãŸç”¨èªžãŒã‚ˆãã‚ã‹ã‚‰ãªã„æ–¹ã¯ç™ºè¡¨å†…å®¹ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ãªãŠã€MySQL ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 5.7.38 ã§ã™ã€‚ mysql> SELECT @@version; +-----------+ | @@version | +-----------+ | 5.7.38 | +-----------+ 1 row in set (0.00 sec) äº‹å‰æº–å‚™ sample-data-railsdm-2018 ã® orders ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å°‘ã—ã„ã˜ã£ã¦ã€ã‚ãƒ£ãƒ³ã‚»ãƒ«æ™‚åˆ»ï¼ˆcanceled_atï¼‰ã€é…é€äºˆå®šæ™‚åˆ»ï¼ˆdeliv
stefafafan 2022/06/03
sql

mysql

database
ãƒªãƒ³ã‚¯
1æ–‡å—ã§SQLã‚’200å€é…ãã™ã‚‹æ–¹æ³•
ã“ã‚“ã«ã¡ã¯ã€19ã®SysAdçã®ç¿ (sappi_red)ã§ã™ã€‚æ™®æ®µã¯traQã®ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®ä¿å®ˆã‚’è¡Œã£ãŸã‚Šã—ã¦ã„ã¾ã™ã€‚ ã“ã‚“ã°ã‚“ã¯ã€19ã®SysAdçã®temmaã§ã™ã€‚æ™®æ®µã¯æ™®æ®µã©ãŠã‚Šã®ã“ã¨ã‚’ã—ã¦ã„ã¾ã™ã€‚ã“ã®è¨˜äº‹ã®é¢ç™½ã„éƒ¨åˆ†ã¯ã™ã¹ã¦åƒ•ãŒæ›¸ã„ã¦ã„ã¾ã™ã€‚é¢ç™½ããªã„ã¨ã“ã‚ã¯ç¿ å›ãŒæ›¸ã„ã¦ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€æ—¥ã€…ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é ã‚’æ‚©ã¾ã›ã‚‹é–‹ç™ºè€…ã®æ–¹ã®ãŸã‚ã«ã€ãƒ¯ãƒ³ã‚¿ãƒƒãƒã§åŠ‡é…SQLã‚’200å€é«˜é€Ÿã§ã‚ãƒ¥ãƒ¼ãƒˆãªSQLã«åŠ‡çš„ãƒ“ãƒ•ã‚©ãƒ¼ã‚¢ãƒ•ã‚¿ãƒ¼ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã€ŒãŠã„ãŠã„ãŠã„ã€é…ãã—ãŸãã¦è¨˜äº‹ã‚’èªã¿å§‹ã‚ãŸã®ã«è©±ãŒé•ã†ã˜ã‚ƒãªã„ã‹ðŸ’¢ã€ã¨æ€ã£ã¦ã‚‹ãã“ã®ã‚ãªãŸðŸ‘ˆ æ—©ãã§ãã‚‹ã¨ã„ã†ã“ã¨ã¯é…ãã‚‚ã§ãã‚‹ã‚“ã§ã™ãã€‚ TL;DR ã“ã“ã«ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚Šã¾ã™ã€‚ CREATE TABLE messages ( id CHAR(36) NOT NULLã€€PRIMARY KEY, text TEXT COLLATE ut
stefafafan 2022/05/17
sql
ãƒªãƒ³ã‚¯
Node.jsã®MySQLãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«ãŠã‘ã‚‹ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å‡¦ç†ã ã‘ã§ã¯é˜²ã’ãªã„ã€Œéš ã‚ŒãŸã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ - Flatt Security Blog
â€»æœ¬è¨˜äº‹ã¯ç†è€…styprãŒè‹±èªžã§åŸ·ç†ã—ãŸè¨˜äº‹ã‚’æ ªå¼ä¼šç¤¾Flatt Securityç¤¾å†…ã§æ—¥æœ¬èªžã«ç¿»è¨³ã—ãŸã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ TL;DR Node.jsã®ã‚¨ã‚³ã‚·ã‚¹ãƒ†ãƒ ã§æœ€ã‚‚äººæ°—ã®ã‚ã‚‹MySQLãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ä¸€ã¤ã§ã‚ã‚‹ mysqljs/mysql (https://github.com/mysqljs/mysql)ã«ãŠã„ã¦ã€ã‚¯ã‚¨ãƒªã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—é–¢æ•°ã®äºˆæœŸã›ã¬å‹•ä½œãŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’å¼•ãèµ·ã“ã™å¯èƒ½æ€§ãŒã‚ã‚‹ã“ã¨ãŒåˆ¤æ˜Žã—ã¾ã—ãŸã€‚ é€šå¸¸ã€ã‚¯ã‚¨ãƒªã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—é–¢æ•°ã‚„ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã¯SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’é˜²ãã“ã¨ãŒçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€mysqljs/mysql ã¯ã€å€¤ã®ç¨®é¡žã«ã‚ˆã£ã¦ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ–¹æ³•ãŒç•°ãªã‚‹ã“ã¨ãŒçŸ¥ã‚‰ã‚Œã¦ãŠã‚Šã€æ”»æ’ƒè€…ãŒç•°ãªã‚‹å€¤ã®ç¨®é¡žã§ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’æ¸¡ã™ã¨ã€æœ€çµ‚çš„ã«äºˆæœŸã›ã¬å‹•ä½œã‚’å¼•ãèµ·ã“ã™å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚äºˆæœŸã›ã¬å‹•ä½œã¨ã¯ã€ãƒã‚°ã®ã‚ˆã†ãªå‹•ä½œã‚„SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ãªã©ã§ã™ã€‚ ã»ã¼ã™ã¹ã¦ã®ã‚ªãƒ³ãƒ©
stefafafan 2022/02/21
security

sql
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸