[B! db] az1zaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

az1za id:az1za

dbã«é–¢ã™ã‚‹az1zaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

Cloudflare D1 ãŒãƒ¤ãƒã„
ã¾ã æ¤œè¨¼è¶³ã‚Šãªã„ã‘ã©ã€ãƒžã‚¸ã§æƒ³åƒé€šã‚Šã®ãƒ–ãƒ„ãªã‚‰é‚éœ‡ãˆã‚‹ã‹ã‚‚ã—ã‚Œã‚“â€¦ã€‚ Announcing D1: our first SQL database Cloudflare D1 = Edge SQLite Cloudflare D1 ã¯ Cloudflare Worker ã§ã€ã¤ã¾ã‚Š CDN Network ä¸Šã§ sqlite ãŒå‹•ãã¾ã™ã€‚ã“ã‚Œã ã‘ãªã‚‰æ™®é€šã® sqlite ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ãªã‚“ã§ã™ãŒã€ã‚‚ã¡ã‚ã‚“ Cloudflare ãŒå‡ºã™ã‹ã‚‰ã«ã¯ãã‚Œã ã‘ã§ã¯ãªãã€CDN Edge ä¸Šã« Read Replica ãŒãƒãƒ©æ’’ã‹ã‚ŒãŸ sqlite ã«ãªã‚Šã¾ã™ã€‚ãƒ¤ãƒããªã„ã§ã™ã‹ï¼Ÿ åƒ•ã¯ãƒ¤ãƒã„ã¨æ€ã„ã¾ã—ãŸã€‚ ã“ã®ãƒ¤ãƒã•ã‚’çŸ¥ã‚‹ãŸã‚ã«ã€Cloudflare ãŒé–‹ç™ºã—ãŸåŸºç›¤ã«ã¤ã„ã¦ã„ãã¤ã‹æŠ‘ãˆã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ Durable Objects ã¯ CDN ä¸Šã® Actor ãƒ¢ãƒ‡ãƒ«ã‚’æ§‹ç¯‰ã§ãã¾ã™ã€‚ã“ã® Acto
az1za 2022/05/12
db

cloudflare

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é…ãã™ã‚‹ãŸã‚ã®ï¼˜ã¤ã®æ–¹æ³•
ã¯ã˜ã‚ã« Twitterã®ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã‚’è¦‹ã¦ã„ãŸã‚‰ãƒãƒƒãƒç³»ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã§é€æ¬¡ã‚³ãƒŸãƒƒãƒˆã‚’ã‚„ã‚ã¦ä¸€æ‹¬ã‚³ãƒŸãƒƒãƒˆã«ã—ãŸã‚‰çˆ†é€Ÿã«ãªã£ãŸã¨ã„ã†ã®ã‚’è¦‹ã¾ã—ãŸã€‚å½“ãŸã‚Šå‰ã§ã—ã‚‡ã€ã¨æ€ã£ãŸã‘ã©ç¢ºã‹ã«çŸ¥ã‚‰ãªã‘ã‚Œã°åˆ†ã‹ã‚‰ãªã„ã‚ˆãã€ã¨æ€ã£ã¦ä¸»ã«åˆå¿ƒè€…å‘ã‘ã«RDBã‚’æ‰±ã†ã¨ãã®æ³¨æ„ç‚¹ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯çš„ãªã¨ã“ã‚ã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆãã‚‰ã„ã®ç¯„ç–‡ã§DBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‹ã¯å…¥ã£ã¦ãªã„ã§ã™ã€‚ è‡ªåˆ†ã®çµŒé¨“çš„ã«Oracleã‚’ãƒ™ãƒ¼ã‚¹ã«æ›¸ã„ã¦ã„ã¾ã™ãŒã€ä»–ã®RDBã§ã‚‚ç‰¹ã«å¤‰ã‚ã‚‰ãªã„ãƒ¬ãƒ™ãƒ«ã®ç²’åº¦ã ã¨æ€ã„ã¾ã™ã€‚ å¤§é‡ã®é€æ¬¡ã‚³ãƒŸãƒƒãƒˆã‚’ã™ã‚‹ ãƒãƒƒãƒã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§DBã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã™ã‚‹ã¨è¨€ã†ã®ã¯ã‹ãªã‚Šä¸€èˆ¬çš„ãªå‡¦ç†ã§ã™ã€‚ã—ã‹ã—ãƒ‡ãƒ¼ã‚¿é‡ãŒå°‘ãªã„æ™‚ã¯ã¨ã‚‚ã‹ãå¤§é‡ã®ã‚¤ãƒ³ã‚µãƒ¼ãƒˆã‚’é€æ¬¡ã‚³ãƒŸãƒƒãƒˆã§å‡¦ç†ã™ã‚‹ã¨ã‚ã¡ã‚ƒãã¡ã‚ƒé…ããªã‚Šã¾ã™ã€‚æ•°å€ã‹ã‚‰åæ•°å€é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã®ã§ã€10åˆ†ç¨‹åº¦ã®ãƒãƒƒãƒãŒï¼‘æ™‚é–“è¶Šãˆã«åŒ–ã‘ã‚‹ã“ã¨ã‚‚ã‚¶ãƒ©ã«ã‚ã‚‹ã®ã§åŽŸ
az1za 2020/11/15
ã‚ã¨ã§èªã‚€

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

db

SQL
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
JPOUG> SET EVENTS 20140907 | Japan Oracle User Group (JPOUG)ã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚IIJã•ã¾ã®ã‚»ãƒŸãƒŠãƒ«ãƒ¼ãƒ ã¯çª“ã‹ã‚‰ã®çœºã‚ãŒã™ã°ã‚‰ã—ã„ã§ã™ãã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸIIJã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ŒMySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ã€ã¨é¡Œã—ã¦ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ãªã©ã®èª¬æ˜Žã‚’ã—ã¾ã—ãŸã€‚ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã¨ã€èª¿æŸ»ã®ãŸã‚ã«ä½œæˆã—ãŸãƒ„ãƒ¼ãƒ«ã‚’å…¬é–‹ã—ã¾ã™ã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ (PDF) Lock Inspector 1.0 ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã‹ã‚‰ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä¸€è¦§ã§ã™ã€‚ MySQL Lists: mysql: Re: InnoDB's inner workings + checkpoints éŽåŽ»è¨˜äº‹ã®è¨‚æ£ @kami
az1za 2014/09/14
mysql

ã‚ã¨ã§èªã‚€

db

lock
ãƒªãƒ³ã‚¯
golangè£½ã®DBãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«gooseã‚’MySQLã§ä½¿ã£ã¦ã¿ã‚‹ | é–‹ç™ºãƒ¡ãƒ¢ã‚‹ã‚¢ãƒ«
golangè£½ï¼ˆGoè¨€èªžï¼‰ã®DBãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«ã€gooseã‚’ä½¿ã£ã¦MySQLã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚„ã£ã¦ã¿ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« https://bitbucket.org/liamstask/goose ã“ã¡ã‚‰ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹é€šã‚Šã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ï¼ˆã‚‚ã¡ã‚ã‚“Goã¯äº‹å‰ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãŠãï¼‰ $ go get bitbucket.org/liamstask/goose/cmd/goose helpã‚’è¦‹ã¦ã¿ã‚‹ã€‚ $ goose --help goose is a database migration management system for Go projects. Usage: goose [options] <subcommand> [subcommand options] Options: -env="development": which DB environment to use
az1za 2014/09/09
DB

mysql

golang
ãƒªãƒ³ã‚¯
ä¸»ã‚ãƒ¼ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ã¯ãªã„ - è¨è¨ˆè€…ã®ç™ºè¨€
ä»•äº‹æŸ„ã€å¥‡å¦™ãªDBæ§‹é€ ã‚’ç›®ã«ã™ã‚‹ã“ã¨ãŒå¤šã„ã€‚ã©ã†ã„ã†ç™ºæƒ³ã‹ã‚‰ãã‚“ãªè¨è¨ˆãŒã•ã‚Œã‚‹ã®ã‹ã‚’ç†è§£ã—ãŸã„ã¨æ€ã£ã¦ã„ãŸã®ã ãŒã€ãƒ¢ãƒ‡ãƒ©ãƒ¼ä»²é–“ã®ç§‹é‡Œã•ã‚“ãŒå…ˆæ—¥ã†ã¾ã„æŒ‡æ‘˜ã‚’ã—ãŸã€‚ã€Œä¸»ã‚ãƒ¼ã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¿ãŸã„ãªã‚‚ã®ã¨å‹˜é•ã„ã—ã¦ã„ã‚‹ã‹ã‚‰ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆã‚ãƒ¼ï¼‰ã¨ã„ã†ã®ã¯ã€ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ä¸¦ã³é †ã‚’è¦å®šã™ã‚‹ã‚ãƒ¼ã®ã“ã¨ã ã€‚ ãŸã—ã‹ã«æ€ã„å½“ãŸã‚‹ç¯€ãŒã‚ã‚‹ã€‚ã€Œã“ã‚“ãªé †ã«ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒä¸¦ã‚“ã§ã„ã‚Œã°å‡¦ç†ä¸Šéƒ½åˆãŒã‚ˆã•ãã†ã ã€ã¨ã„ã†è€ƒãˆã§ä¸»ã‚ãƒ¼ãŒè¨å®šã•ã‚Œã‚‹ã€‚ã•ã‚‰ã«ä¸»ã‚ãƒ¼ã¯ãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ã§ã‚‚ã‚ã‚‹ã®ã§ã€é‡è¤‡ãŒèµ·ã“ã‚‰ãªã„ã‚ˆã†ã«ã€Œå¤šã‚ã€ã«é …ç›®ã‚’çªã£è¾¼ã‚“ã§ãŠãã€‚ã¤ã¾ã‚Šã€Œãƒ¦ãƒ‹ãƒ¼ã‚¯åˆ¶ç´„ã‚’ã¨ã‚‚ãªã†ä»£è¡¨çš„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ç¨‹åº¦ã«ä¸»ã‚ãƒ¼ãŒç†è§£ã•ã‚ŒãŸçµæžœã¨ã—ã¦ã€ã‚°ãƒ€ã‚°ãƒ€ãªDBæ§‹é€ ãŒå‡ºæ¥ä¸ŠãŒã‚‹ã®ã§ã¯ãªã„ã‹ã€‚ ã˜ã£ã•ã„ã€æ˜”ã“ã‚“ãªã“ã¨ãŒã‚ã£ãŸã€‚{a,b,c,d}ã®è¤‡åˆä¸»ã‚ãƒ¼ã‚’ã‚‚ã¤ãƒ†ãƒ¼ãƒ–ãƒ«ï¼¸ãŒã‚ã‚‹ã€‚ã¨ã“ã‚ãŒã€åˆ¥ã®ãƒ†ãƒ¼ãƒ–ãƒ«ï¼¹ã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«ï¼¸ã®ç‰¹å®šãƒ¬ã‚³ãƒ¼ãƒ‰ã«ã‚¢ã‚¯ã‚»
az1za 2014/08/27
DB

è¨è¨ˆ
ãƒªãƒ³ã‚¯
1