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

uokada id:uokada

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

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

WITHå¥ã¦ã‚“ã“ã‚‚ã‚Šã®SQLã‚’ãƒ‡ãƒãƒƒã‚°ã™ã‚‹ - ã‚¨ãƒ ã‚¹ãƒªãƒ¼ãƒ†ãƒƒã‚¯ãƒ–ãƒã‚°
å·¨å¤§ãªSQLã®å‡ºåŠ›ãŒæ„å›³ã¨é•ã£ã¦ã„ãŸã‚Šé•ã£ã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã¨ãã€ã©ã“ã‹ã‚‰ç¢ºèªã—ã‚ˆã†ã‹é ã‚’æŠ±ãˆã¦ã—ã¾ã†ã“ã¨ã£ã¦ã‚ã‚Šã¾ã™ã‚ˆãã€‚ã›ã‚ã¦å¤šæ®µéšŽã§ä½œã‚‰ã‚Œã¦ã„ã‚‹ãŸãã•ã‚“ã®CTE ï¼ˆWITHå¥ï¼‰ã€ã“ã‚Œã‚‰ãŒä¸€ã¤ãšã¤ã©ã‚“ãªè¡¨ã‚’å‡ºåŠ›ã—ã¦ã„ã‚‹ã®ã‹ç°¡å˜ã«ã®ãžã‘ãŸã‚‰æ‰‹ãŒã‹ã‚Šã‚‚ã‚ã‚‹ã®ã ã‘ã‚Œã©â‹¯ ä»Šå›žã¯ãã‚Œã‚’ã‚ã‚Šã¨ç¾å®Ÿçš„ãªæ‰‹é–“ã§ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹å°æŠ€ã§ã™ã€‚ã‚¨ãƒ ã‚¹ãƒªãƒ¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒ«ãƒ¼ãƒ—Unit1ï¼ˆè£½è–¬ãƒ—ãƒãƒ¢ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ï¼Unit9ï¼ˆæ²»é¨“è‡¨åºŠç ”ç©¶æ”¯æ´ï¼‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ä¸‰æµ¦[è¨˜äº‹ä¸€è¦§ ï€‰]ã§ã™ã€‚ é”æ³•ã®ä¸€è¡Œ ãƒ‡ãƒãƒƒã‚°ã‚’å®Ÿç¾ã™ã‚‹ä¸€è¡Œ We are hiring é”æ³•ã®ä¸€è¡Œ SQLã®æœ€å¾Œã« -- */ ã¨ã„ã†ç„¡æ„å‘³ãªã‚³ãƒ¡ãƒ³ãƒˆè¡Œã‚’ä»˜ã‘ã¦ãŠã„ã¦ãã ã•ã„ã€‚ã²ã¨ç›®è¦‹ã¦åˆ†ã‹ã‚‹é€šã‚Šã€ã¾ã£ãŸãç„¡æ„å‘³ã§ã™ã€‚ã¨ã“ã‚ãŒã“ã‚ŒãŒã‚ã‚‹ã ã‘ã§ã€ãƒ‡ãƒãƒƒã‚°ã®ã¨ãã«ã“ã‚“ãªã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™â€•â€• ãƒ‡ãƒãƒƒã‚°ã‚’å®Ÿç¾ã™ã‚‹ä¸€è¡Œ æ¬¡ã®ã‚ˆã†ãªCTEã®å¤§è¡Œåˆ—ãŒã‚ã‚‹ã¨ã—ã¾ã™
uokada 2025/06/18
ã‚ã¨ã§èªã‚€

sql

database

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
DBãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®å®‰å…¨æ€§ã‚’é«˜ã‚ã‚‹ã‚¬ãƒ¼ãƒ‰ãƒ¬ãƒ¼ãƒ«ã®å®Ÿè·µ - LayerX ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ï¼ãƒã‚¯ãƒ©ã‚¯äº‹æ¥éƒ¨ Platform Engineering éƒ¨ SRE ãƒãƒ¼ãƒ ã® id:sadayoshi_tadaã§ã™ã€‚è¶£å‘³ã§ç‹ãƒˆãƒ¬ã‚’ã‚„ã£ã¦ã„ã¦ã“ã‚Œã¾ã§ã»ã¼1äººã§ã‚„ã£ã¦ã„ãŸã®ã§ã™ãŒã€æœ€è¿‘ç¤¾å†…ã®äººé”ã¨ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã“ã¨ãŒå¢—ãˆã¦æ¥½ã—ã„ä»Šæ—¥ã“ã®ã”ã‚ã§ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯SREãƒãƒ¼ãƒ ã§è¡Œã£ã¦ã„ã‚‹ã€DBãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹ã‚¬ãƒ¼ãƒ‰ãƒ¬ãƒ¼ãƒ«ã®å–ã‚Šçµ„ã¿ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ DBãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¾ã¤ã‚ã‚‹èª²é¡Œã«ã¤ã„ã¦ SREãƒãƒ¼ãƒ ã«ã‚ˆã‚‹DBãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³æ™‚ã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ ALTER TABLEå®Ÿè¡Œæ™‚ã«ALGORITHMã‚’æ˜Žç¤ºã™ã‚‹CIã‚’è¿½åŠ ä»Šå¾Œã®èª²é¡Œ ã¾ã¨ã‚ æœ€å¾Œã« DBãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¾ã¤ã‚ã‚‹èª²é¡Œã«ã¤ã„ã¦ æœ¬é¡Œã«å…¥ã‚‹å‰ã«ã€ãƒã‚¯ãƒ©ã‚¯ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚ãƒ¼ãƒžãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³(ä»¥é™ã€DBãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã¨å‘¼ç§°ã—ã¾ã™)ã§èµ·ã“ã£ã¦ã„ãŸèª²é¡Œã«ã¤ã„ã¦ç°¡å˜ã«è§¦ã‚Œã¾ã™ã€‚ ãƒã‚¯ãƒ©ã‚¯ã§ã¯ãƒªãƒªãƒ¼ã‚¹ã«ãŠã„ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼
uokada 2025/02/24
db

sql
ãƒªãƒ³ã‚¯
BigQueryã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³èªè˜ãƒ„ãƒ¼ãƒ«ã§ç‹¬è‡ªã®SQLãƒªãƒ³ã‚¿ãƒ¼ã‚’é–‹ç™ºã—ã¾ã—ãŸ - ZOZO TECH BLOG
ã“ã‚“ã«ã¡ã¯ã€æ ªå¼ä¼šç¤¾ZOZOã§25å’ã®å†…å®šè€…ã‚¢ãƒ«ãƒã‚¤ãƒˆã‚’ã—ã¦ã„ã‚‹æ‘äº•ã§ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯æ¥å‹™ã§å–ã‚Šçµ„ã‚“ã§ã„ã‚‹ã€BigQueryã§ä½¿ã†SQLã®ãƒªãƒ³ã‚¿ãƒ¼ã®ä½œæˆæ–¹æ³•ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ç›®æ¬¡ ç›®æ¬¡ èª²é¡Œã¨è§£æ±ºç– èª²é¡Œ è§£æ±ºç– BigQueryã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³èªè˜ãƒ„ãƒ¼ãƒ« ãƒŸãƒ‹ãƒžãƒ ãªä½¿ã„æ–¹ æ—¥æœ¬èªžãŒSQLå†…ã«å«ã¾ã‚Œã¦ã„ã‚‹éš›ã®å•é¡Œ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’å®šç¾©ã™ã‚‹ ãƒªãƒ³ã‚¿ãƒ¼ã¨ã—ã¦BigQueryã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³èªè˜ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã™ã‚‹éš›ã«ç”Ÿã˜ã‚‹èª²é¡Œã¨è§£æ±ºç– æ§‹æˆ APIã‚µãƒ¼ãƒåŒ– Chromeæ‹¡å¼µ å‹•ä½œä¾‹ ã¾ã¨ã‚ èª²é¡Œã¨è§£æ±ºç– èª²é¡Œ ç¤¾å†…ã§ã¯æ§˜ã€…ãªãƒãƒ¼ãƒ ãŒSQLã‚’æ›¸ã„ã¦ãŠã‚Šã€å‹•ä½œã¯ã™ã‚‹ã‚‚ã®ã®è‰¯ããªã„æ›¸ãæ–¹ã‚’ã—ã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ãã†ã„ã£ãŸæ§‹æ–‡ã‚’æ¤œçŸ¥ã—ã¦ã€å‰ã‚‚ã£ã¦ä¿®æ£ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ è§£æ±ºç– BigQueryã®ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã§å…¥åŠ›ã•ã‚ŒãŸSQLã®ä¸æ£æ§‹æ–‡ã‚’æ¤œçŸ¥ã€ä¿®æ£æ¡ˆã‚’æç¤ºã§ãã‚‹ã‚ˆã†ã«ã—ã¾ã—ãŸã€‚ BigQueryã®ã‚¢ãƒ³
uokada 2025/01/31
ã‚ã¨ã§èªã‚€

BigQuery

sql

tool
ãƒªãƒ³ã‚¯
Practical Text-to-SQL for Data Analytics
Co-authors: Co-authored byAlbert Chen, Co-authored byManas Bundele, Co-authored byGaurav Ahlawat, Co-authored byPatrick Stetz, Co-authored byZhitao (James) W., Co-authored byQiang Fei, Co-authored byDon Jung, Co-authored byAudrey Chu, Co-authored byBharadwaj Jayaraman, Co-authored byAyushi Panth, Co-authored byYatin Arora, Co-authored bySourav Jain, Co-authored byRenjith Varma, Co-authored byAlex
uokada 2025/01/12
sql

AI
ãƒªãƒ³ã‚¯
DuckDB as the New jq
Recently, Iâ€™ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats. I work extensively with JSON day to day, and I often reach for jq when exploring document
uokada 2024/11/22
duckdb

jq

sql

db
ãƒªãƒ³ã‚¯
GitHub - xo/usql: Universal command-line interface for SQL databases
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
uokada 2024/11/20
sql

golang
ãƒªãƒ³ã‚¯
Querydsl - Unified Queries for Java
JPA The popular choice for SQL persistence with a focus on CRUD and simple queries for object loading. more... SQL The alternative SQL abstraction with a focus on SQL operations and the full expressivity of the SQL standard. more...
uokada 2024/08/30
java

sql

jpa
ãƒªãƒ³ã‚¯
DuckDBã§ãŠæ‰‹è»½ï¼ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚§ãƒ‡ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ - Techtouch Developers Blog
tl;dr ã¯ã˜ã‚ã« DuckDB ã¨ã¯ DuckDB ã§ã¯ä½•ãŒèªã‚ã‚‹ã®ã‹ ä½¿ã£ã¦ã¿ã‚‹ S3 ä¸Šã®JSON ã‚’èªã‚“ã§ã¿ã‚‹ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ä»–ãƒ„ãƒ¼ãƒ«ã§ã¯ãªã DuckDB ã‚’ä½¿ã†ãƒ¡ãƒªãƒƒãƒˆ ã—ãã˜ã‚Šãƒã‚¤ãƒ³ãƒˆ ï¼ˆç‰¹ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã°ã‹ã‚Šã®ï¼‰ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã¯æ°—ã‚’ã¤ã‘ã‚‹ S3 ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæ•°ãŒå¤šã„å ´åˆä¸éƒ½åˆãŒã‚ã‚ŠãŒã¡ ã‚¹ãƒ¬ãƒƒãƒ‰ã®èª¿æ•´ãŒå¿…è¦ãªå ´åˆã‚‚ Redshift ã«ã¯æœªå¯¾å¿œ çµ‚ã‚ã‚Šã« ä»˜éŒ² MySQL ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚€ä¾‹ã® MySQL å´ã®æº–å‚™ tl;dr DuckDB ä¾¿åˆ©ã ã‚ˆã€‚åˆ†æžä»¥å¤–ã§ã‚‚ä½¿ãˆã‚‹ã‚ˆ è‰²ã€…ãªå ´æ‰€ã®ãƒ‡ãƒ¼ã‚¿ã‚’é–²è¦§ãƒ»çµåˆã§ãã‚‹ã‚ˆã€‚æ¨™æº–SQLã‚‚ä½¿ãˆã‚‹ã‚ˆ ãŸã ã—ã€ç´°ã‹ã„è½ã¨ã—ç©´ã¯è‰²ã€…ã‚ã‚‹ã®ã§æ°—ã‚’ã¤ã‘ã¦ã ã¯ã˜ã‚ã«2023å¹´4æœˆã«ãƒ‡ãƒ¼ã‚¿ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦å…¥ç¤¾ã—ãŸminï¼ˆ@not_rogueï¼‰ã§ã™ã€‚æš–ã‹ããªã‚‹ã«ã¤ã‚Œã€YouTube ã§è¦‹ãŸå—ä¼Šè±†ãƒãƒ³ã‚°ãƒˆãƒ¬ã‚¤ãƒ« | æ¾å´Žç”ºã«è¡Œãæ©Ÿé‹ãŒ
uokada 2024/05/20
ã‚ã¨ã§èªã‚€

duckdb

sql

db
ãƒªãƒ³ã‚¯
Everything Is a Funnel, But SQL Doesnâ€™t Get It
uokada 2024/03/15
sql
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
åºæ–‡ ç§ã®ä»•äº‹ã¯ã€DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã™ã€‚ã¨ã„ã£ã¦ã‚‚åˆ¥ã«æœ›ã‚“ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã¸ããŸã‚ã‘ã§ã¯ãªãã€å½“åˆã€ç§ã¯ã“ã®åˆ†é‡ŽãŒé¢ç™½ãã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ã€ŒWebç³»ã¯èŠ±å½¢ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯æ—¥é™°ã€ã¨ã„ã†è¨€è‘‰ã‚‚å›ã‹ã‚Œã¦ã„ã¾ã—ãŸã€‚ä»Šã§ã‚‚å›ã‹ã‚Œã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã§ã™ãŒã€ã—ã°ã‚‰ããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è§¦ã£ã¦ã„ã‚‹ã†ã¡ã«ã€ç§ã¯ã“ã®ä¸–ç•Œã«ã¨ã¦ã‚‚èˆˆå‘³æ·±ã„ãƒ†ãƒ¼ãƒžãŒå¤šãã‚ã‚‹ã“ã¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ãªãœã‚‚ã£ã¨æ—©ãæ°—ã¥ã‹ãªã‹ã£ãŸã®ã‹ã€å¾Œæ‚”ã™ã‚‹ã“ã¨ã—ãã‚Šã§ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã€è‡ªåˆ†ã®ä¸æ˜ŽãŒæœ€å¤§ã®åŽŸå› ã§ã™ãŒã€ã“ã®ä¸–ç•Œã«è¶³ã‚’è¸ã¿å…¥ã‚ŒãŸå½“æ™‚ã€å…ˆç”Ÿã‚‚ã€å°Žãã®æ›¸ã¨ãªã‚‹å…¥é–€æ›¸ã‚‚ãªã‹ã£ãŸã“ã¨ã‚‚äº‹å®Ÿã§ã™ã€‚ ä»Šã§ã“ããƒã‚¤ãƒ–ãƒ«ã¨ä»°ãã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬2ç‰ˆã€ã‚‚æ–°å…¥ç¤¾å“¡ã«ã¯æ•·å±…ãŒé«˜ã™ãŽã¾ã—ãŸ (2015å¹´2æœˆè¿½è¨˜ï¼šãã®å¾Œã€è‡ªåˆ†ã§ç¬¬4ç‰ˆã‚’è¨³å‡ºã§ããŸã®ã ã‹ã‚‰ã€ äººç”Ÿã¯ä½•ãŒã‚ã‚‹ã‹åˆ†ã‹ã‚‰ãªã„ã‚‚ã®ã§ã™)ã€‚ ãã“ã§ã€ã§ã™ã€‚ã“ã®ã‚µã‚¤ãƒˆã®ç›®çš„ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã«è¶³ã‚’è¸ã¿
uokada 2024/02/29
ã‚ã¨ã§èªã‚€

sql

database

db
ãƒªãƒ³ã‚¯
https://twitter.com/ai_database/status/1726025818621804992
uokada 2024/02/08
sql
ãƒªãƒ³ã‚¯
Streaming SQL in Data Mesh
An example of a Data Mesh pipeline which moves and transf orms data using Union, GraphQL Enrichment, and Column Rename Processor before writing to an Iceberg table. By keeping the logic of individual Processors simple, it allowed them to be reusa ble so we could centrally manage and operate them at scale. It also allowed them to be composable, so users could combine the different Processors to expre
uokada 2024/02/01
Netflix

sql
ãƒªãƒ³ã‚¯
T5QL: Taming language models for SQL generation
uokada 2023/12/12
sql

db
ãƒªãƒ³ã‚¯
ArcaDB: A Container-based Disaggregated Query Engine for Heterogenous Computational Environments
uokada 2023/12/12
sql

db
ãƒªãƒ³ã‚¯
Python: Just write SQL
I have been writing a lot more Go this past year. For those not familiar, Go favours a non-ORM, non-query-builder approach to interacting with databases. This comes naturally due to the sql package: A common interface to be used alongside database drivers. Itâ€™s very common to see actual SQL in Go, even in large projects. On the other hand, Python does not have anything in the standard library that
uokada 2023/10/22
python

orm

sql

database
ãƒªãƒ³ã‚¯
GitHub - Dataherald/dataherald: Interact with your SQL database, Natural Language to SQL using LLMs
Query your relational data in natural language. | | Docs | Homepage Dataherald is a natural language-to-SQL engine built for enterprise-level question answering over relational data. It allows you to set up an API from your database that can answer questions in plain English. You can use Dataherald to: Allow business users to get insights from the data warehouse without going through a data analys
uokada 2023/10/06
LLM

sql
ãƒªãƒ³ã‚¯
SQL language
The page describes the SQL dialect recognized by Calciteâ€™s default SQL parser. Grammar SQL grammar in BNF-like form. statement: setStatement | resetStatement | explain | describe | insert | update | merge | delete | query statementList: statement [ ';' statement ]* [ ';' ] setStatement: [ ALTER { SYSTEM | SESSION } ] SET identifier '=' expression resetStatement: [ ALTER { SYSTEM | SESSION } ] RESE
uokada 2023/07/12
sql
ãƒªãƒ³ã‚¯
vscode-dbt-power-userã§dbtã®é–‹ç™ºã‚„ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’åŠ¹çŽ‡åŒ–ã™ã‚‹ - yasuhisa's blog
èƒŒæ™¯ vscode-dbt-power-userãŒã‚ˆã‹ã£ãŸã¨ã“ã‚ å®šç¾©ã«ã•ã£ã¨è¡Œã‘ã‚‹ / æˆ»ã‚Œã‚‹(Go to definitionãŒä½¿ãˆã‚‹) VSCodeå†…ã§ãƒ¢ãƒ‡ãƒ«é–“ã®ãƒªãƒãƒ¼ã‚¸ãŒè¦‹ã‚Œã‚‹ VSCodeå†…ã‹ã‚‰dbtã®ãƒ¢ãƒ‡ãƒ«ã‚’ã•ã£ã¨å®Ÿè¡Œã§ãã‚‹ ãƒ¢ãƒ‡ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®å˜ç‹¬ã®å®Ÿè¡Œã‚‚ç°¡å˜ ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ¸ˆã¿ã®SQLãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã•ã£ã¨ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§ãã‚‹ ã¾ã¨ã‚ è£œè¶³: vscode-dbt-power-userã®å°Žå…¥æ–¹æ³• èƒŒæ™¯ dbtã¯å‰è·æ™‚ä»£ã‹ã‚‰å«ã‚ã‚‹ã¨äºŒå¹´ä»¥ä¸Šä½¿ã£ã¦ã„ã¦ã€SQLã§DWHã‚„ãƒ‡ãƒ¼ã‚¿ãƒžãƒ¼ãƒˆã®é–‹ç™ºã‚’ã—ã‚ˆã†ã¨æ€ã†ã¨ã‚‚ã¯ã‚„ã“ã‚Œãªã—ã§ã¯ç”Ÿãã‚‰ã‚Œãªã„ãã‚‰ã„ã«ã¯ä¾¿åˆ©ã«ãªã£ã¦ã„ã‚‹ã€‚dbtãŒã‚ã£ã¦ã‚‚å¤§å¤‰ãªã‚¯ã‚¨ãƒªã¯å¤§å¤‰ã§ã¯ã‚ã‚‹ãŒã€å¤§å¤‰ã•ã¯å¤§åˆ†ç·©å’Œã—ã¦ãã‚Œã‚‹ã€‚dbtãŒãªãã¦ã€1ã¤ã®SQLãŒ1000è¡Œä»¥ä¸Šã‚ã‚Šã€ä¸é–“ã‚¯ã‚¨ãƒªãŒãƒ†ã‚¹ãƒˆã‚‚ã•ã‚Œã¦ã„ãªã„ã€ã¨ã„ã†çŠ¶æ³ã¯ã‚‚ã†æˆ»ã‚ŠãŸããªã„...ã€‚ dbtã«é™ã‚‰ãšã§ã‚ã‚‹ãŒã€ã‚³ãƒ¼ãƒ‰ã¯æ›¸ã„ã¦ã„ã‚‹ã¨
uokada 2023/07/10
sql

dbt
ãƒªãƒ³ã‚¯
Prisma: Node.js & TypeScriptå‘ã‘ã®å®Œç’§ãªORM
æœ¬è¨˜äº‹ã¯ã€@nikolasburkæ°ã«ã‚ˆã‚‹ã€ŒThe Complete ORM for Node.js & TypeScriptã€ï¼ˆ2021å¹´4æœˆ21æ—¥å…¬é–‹ï¼‰ã®æ—¥æœ¬èªžç¿»è¨³ã‚’ã€è‘—è€…ã®è¨±å¯ã‚’å¾—ã¦æŽ²è¼‰ã—ã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚ä»Šå¾ŒPrismaã®å…¬å¼ãƒ–ãƒã‚°ã®æ—¥æœ¬èªžç¿»è¨³ã®è¨±å¯ã‚’ã„ãŸã ã„ãŸã®ã§ã€ã“ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã§ç¶™ç¶šã—ã¦ç¿»è¨³ã—ã¦ã„ãã¾ã™ã€‚â€»ç”»åƒã‚„ãƒªãƒ³ã‚¯ã¯å…¬å¼ã®Blogã‹ã‚‰ãŠå€Ÿã‚Šã—ã¦ã„ã¾ã™ã€‚ Prismaã¯ã€Node.jsã¨TypeScriptã®ãŸã‚ã®æ¬¡ä¸–ä»£ORMã§ã™ã€‚2å¹´ä»¥ä¸Šã®é–‹ç™ºæœŸé–“ã‚’çµŒã¦ã€ã™ã¹ã¦ã®Prismaãƒ„ãƒ¼ãƒ«ãŒè£½å“åŒ–ã®æº–å‚™ãŒæ•´ã£ãŸã“ã¨ã‚’ãŠä¼ãˆã§ãã‚‹ã“ã¨ã«èˆˆå¥®ã—ã¦ã„ã¾ã™! ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ-ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒžãƒƒãƒ”ãƒ³ã‚°ã®æ–°ã—ã„ãƒ‘ãƒ©ãƒ€ã‚¤ãƒ ã‚ã‚‰ã‚†ã‚‹ã‚¹ã‚¿ãƒƒã‚¯ã«å¯¾å¿œã™ã‚‹Prisma ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã®é‹ç”¨ã«å¯¾å¿œ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’è¶…ãˆã¦ ãŠæ‰‹ä¼ã„ã§ãã‚‹ã“ã¨ã¯ï¼Ÿ Prismaã‚’å§‹ã‚ã‚ˆã†
uokada 2023/04/20
prisma

orm

sql
ãƒªãƒ³ã‚¯
ZOZOTOWNã®åŸºå¹¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ã—ãŸè©± - ZOZO TECH BLOG
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€æŠ€è¡“æœ¬éƒ¨SREéƒ¨ZOZOSREãƒãƒ¼ãƒ ã®å €å£ã§ã™ã€‚æ™®æ®µã¯ZOZOTOWNã®ã‚ªãƒ³ãƒ—ãƒ¬ãƒŸã‚¹ã¨ã‚¯ãƒ©ã‚¦ãƒ‰ã®æ§‹ç¯‰ãƒ»é‹ç”¨ã«æºã‚ã£ã¦ã„ã¾ã™ã€‚ã¾ãŸDBREã¨ã—ã¦ZOZOTOWNã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¨èˆ¬ã®é‹ç”¨ãƒ»ä¿å®ˆã‚‚å…¼å‹™ã—ã¦ãŠã‚Šã¾ã™ã€‚ ZOZOTOWNã§ã¯SQL Serverã‚’ä¸å¿ƒã¨ã—ãŸå„ç¨®DBMSãŒç¨¼åƒã—ã¦ã„ã¾ã™ã€‚ãã®ä¸ã§ZOZOTOWNã‚µãƒ¼ãƒ“ã‚¹ã®æ ¹å¹¹ã¨ãªã‚‹ã„ã‚ã‚†ã‚‹åŸºå¹¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€åŸºå¹¹DBã¨å‘¼ã¶ï¼‰ã‚’5å¹´ã¶ã‚Šã«ãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ åŸºå¹¹DBç¾¤ã¯ã€å•†å“æƒ…å ±ã€åœ¨åº«æƒ…å ±ã€æ³¨æ–‡æƒ…å ±ã€ä¼šå“¡æ§˜æƒ…å ±ã€ãƒ–ãƒ©ãƒ³ãƒ‰æ§˜æƒ…å ±ã€é…é€ç®¡ç†ã€ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³æƒ…å ±ã€åˆ†æžç³»æƒ…å ±ãªã©ZOZOTOWNã‚µãƒ¼ãƒ“ã‚¹ã«ãŠã‘ã‚‹ã»ã¼å…¨ã¦ã®æƒ…å ±ã‚’ç®¡ç†ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ãªã‚Šã¾ã™ã€‚ ãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ã®ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã¯5å¹´ã®ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€HWã¨å‘¼ã¶ï¼‰ä¿å®ˆæœŸé™çµ‚äº†ãŠã‚ˆã³SQL Serverã®End Of Lifeï¼ˆä»¥ä¸‹ã€EOLã¨å‘¼ã¶ï¼‰ã‚’è¿Žãˆã‚‹ãŸã‚ã€HW
uokada 2023/04/03
sql

database

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