[B! dbms] shoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sho id:sho

dbmsã«é–¢ã™ã‚‹shoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

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

PlanetScaleã¨ã„ã†ã‚µãƒ¼ãƒãƒ¬ã‚¹DBãŒå‡„ãå‹¢ã„ã®ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‚‰ã—ã„ã®ã§Quick Startã‚„ã£ã¦ã¿ãŸ - Qiita
PlanetScaleã¨ã„ã†ã‚µãƒ¼ãƒãƒ¬ã‚¹DBãŒå‡„ãå‹¢ã„ã®ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã¨èžã„ã¦ã€å…¬å¼ã«ã‚¯ã‚¤ãƒƒã‚¯ã‚¹ã‚¿ãƒ¼ãƒˆãŒã‚ã£ãŸã®ã§ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ ç’°å¢ƒ PC: MacBook Pro (Intel Core 2016) OS: macOS Montery12.2.1 ã§ã¯æ¦‚è¦ã‹ã‚‰ç¢ºèªã—ã¦ã„ãã¾ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ãƒ¬ã‚¹DBã¨ã¯ ã‚µãƒ¼ãƒãŒãªã„ã€ã®ã§ã¯ãªãã€ã‚µãƒ¼ãƒç®¡ç†ã‚„æ¤œè¨ŽãŒä¸è¦ AWS Lambda(NoSQL)ãªã© PlanetScaleã¨ã¯ PlanetScaleå¹´è¡¨ 2010å¹´é ƒ YouTubeãŒæ€¥æ¿€ã«æˆé•·ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒçˆ†ç™ºã—ãã†ã«ãªã£ã¦ã„ãŸã®ã§ã€Suguæ°ã¨ã‚‚ã†ä¸€äººã®YouTubeã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã€ŒVitess.ioã€ï¼ˆãƒ´ã‚£ãƒ†ã‚¹ï¼‰ã‚’ç«‹ã¡ä¸Šã’ã‚‹ 2016å¹´é ƒ MySQLã§ãƒã‚¤ãƒŠãƒªãƒ—ãƒãƒˆã‚³ãƒ«ã‚’æ‰±ãˆã‚‹ã‚ˆã†ã«ã—ãŸã“ã¨ã§ã€Vitessã¯YouTubeä»¥å¤–ã®ä¼æ¥ã«ã¨ã£ã¦ã‚‚é…åŠ›çš„ãªã‚·ã‚¹ãƒ†ãƒ ã«ãªã‚Š
sho 2022/03/16
dbms

planetscale
ãƒªãƒ³ã‚¯
rdb antipattern refactoring
Builderscon 2017ã®ç™»å£‡è³‡æ–™ã§ã™ https://builderscon.io/tokyo/2017/session/c8f36693-32aa-4bf1-816a-4966f3859926
sho 2020/08/13
dbms

refactoring
ãƒªãƒ³ã‚¯
2020å¹´ç¾åœ¨ã®NewSQLã«ã¤ã„ã¦ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? Disclaimer å½“è¨˜äº‹ã¯NewSQLé–‹ç™ºãƒ™ãƒ³ãƒ€ã®æŠ€è¡“ãƒ–ãƒã‚°ã‚„å„ç¨®è«–æ–‡ã€ãã®ä»–ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚µã‚¤ãƒˆç‰ã®å†…å®¹ã‚’å€‹äººçš„ã«ã¾ã¨ã‚ãŸã‚‚ã®ã§ã™ã€‚ ãã®ãŸã‚ã€ç†è§£ä¸è¶³ç‰ã«èµ·å› ã™ã‚‹èª¤è§£ãƒ»èª¤èªã‚’å«ã‚€å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚æ›´ãªã‚‹ç†è§£ãŒå¿…è¦ãªæ–¹ã¯ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«æŒ™ã’ãŸå„ç¨®æ–‡çŒ®ã‚’ç›´æŽ¥å‚ç…§ä¸‹ã•ã„ã€‚æŠ€è¡“çš„ãªæŒ‡æ‘˜ã¯å¯èƒ½ã§ã‚ã‚Œã°å–ã‚Šè¾¼ã¿ä¿®æ£ã—ã¾ã™ãŒã€è¿…é€Ÿãªå¯¾å¿œã¯ãŠç´„æŸã§ãã¾ã›ã‚“ã€‚ NewSQLã®è§£èª¬ã¯äºŒéƒ¨æ§‹æˆ å½“è¨˜äº‹ã¯å‰ç·¨ã§NewSQLã®æ¦‚è¦ç·¨ã¨ãªã‚‹ã€‚ å…¨ä½“ã®ç›®æ¬¡ã¯ä¸‹è¨˜ã§ã‚ã‚‹ã€‚ NewSQLã¨ã¯ä½•ã‹ NewSQLã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ NewSQLã¨ã“ã‚Œã¾ã§ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¯”è¼ƒ
sho 2020/02/28
dbms

newsql
ãƒªãƒ³ã‚¯
è»Šã®ãƒŠãƒ³ãƒãƒ¼ãƒ—ãƒ¬ãƒ¼ãƒˆã«ã€ŒNULLã€ã‚’ç™»éŒ²ã—ãŸç”·æ€§ãŒé§è»Šé•åã§è†¨å¤§ãªé¡ã®ç½°é‡‘ã‚’è«‹æ±‚ã•ã‚Œã¦ã—ã¾ã†
by Charleston's TheDigitel è»Šã®ãƒŠãƒ³ãƒãƒ¼ãƒ—ãƒ¬ãƒ¼ãƒˆã«ã¯ä¸€èˆ¬çš„ã«æ–‡å—ã‚„æ•°å—ã®çµ„ã¿ã‚ã‚ã›ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ãŒã€ã‚¢ãƒ¡ãƒªã‚«ã§ã¯è¿½åŠ æ–™é‡‘ã‚’æ”¯æ‰•ã†ã“ã¨ã§ã€ä»–äººã¨ã‹ã¶ã‚‰ãªã„å¥½ããªæ–‡å—åˆ—ã‚’ãƒŠãƒ³ãƒãƒ¼ãƒ—ãƒ¬ãƒ¼ãƒˆã«ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã€‚ã“ã®ä»•çµ„ã¿ã‚’åˆ©ç”¨ã—ã¦ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžãªã©ã§ä½•ã‚‚ç¤ºã•ãªã„ã“ã¨ã‚’æ„å‘³ã™ã‚‹ã€ŒNULLã€ã¨ã„ã†æ–‡å—åˆ—ã§ãƒŠãƒ³ãƒãƒ¼ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’ç™»éŒ²ã—ãŸç”·æ€§ãŒã€å¤§é‡ã®é§è»Šé•åã«ã‚ˆã‚‹ç½°é‡‘ã‚’è«‹æ±‚ã•ã‚Œã¦ã—ã¾ã£ãŸãã†ã§ã™ã€‚ He tried to prank the DMV. Then his vanity license plate backfired big time. https://mashable.com/article/dmv-vanity-license-plate-def-con-backfire/ ã‚¢ãƒ¡ãƒªã‚«ã§ã¯è»Šã®ãƒŠãƒ³ãƒãƒ¼ãƒ—ãƒ¬ãƒ¼ãƒˆã«è‡ªç”±ãªæ–‡å—åˆ—ã‚’ä½¿ã†äººãŒå¤šãã€æ—¥æœ¬ã§ã¯è€ƒãˆã‚‰ã‚Œãªã„
sho 2019/08/14
security

dbms
ãƒªãƒ³ã‚¯
Webã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£æ¦‚è«– - ã‚†ã†ã†ããƒ–ãƒã‚°
å…ˆæœˆæŠ•ç¨¿ã—ãŸ2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å¦ã¶é“ã®ã‚Šã¨ä»£è¡¨çš„ãªå®Ÿè£…ãƒ¢ãƒ‡ãƒ«ã®æ¦‚è¦ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ã€å‰å›žåŒæ§˜ã€ä¸»ã«æ–°å’Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒé–“ã®æŽ¥ç¶šç®¡ç†ãƒ¢ãƒ‡ãƒ«ã¨é‹ç”¨äº‹æƒ…ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã‚„ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ä½•ãªã®ã‹ã€ãªãœå¿…è¦ãªã®ã‹ã¨ã„ã£ãŸã“ã¨ãŒä¸»ãªè©±é¡Œã§ã™ã€‚ èƒŒæ™¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã¨ã¯ãªã«ã‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®ã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–æ‰‹æ³• ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ãªã«ã‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ‰ãƒ©ã‚¤ãƒåž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ—ãƒã‚ã‚·åž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°å…¨ä½“ã«ã¤ã„ã¦ PostgreSQLã¨MySQL å‚è€ƒè³‡æ–™ ã¾ã¨ã‚ èƒŒæ™¯ 2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®è©±ã¨Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§
sho 2015/06/30
dbms
ãƒªãƒ³ã‚¯
NTTãƒ‡ãƒ¼ã‚¿ã¨PostgreSQLãŒæŒ‘ã‚“ã ç·åŠ›æˆ¦ã€‚PostgreSQLã‚’æ¥µé™ã¾ã§ä½¿ã„åˆ‡ã£ãŸãã®å…ˆã«è¦‹ãŸã‚‚ã®ã¨ã¯ï¼Ÿï¼ˆå‰ç·¨ï¼‰ NTTãƒ‡ãƒ¼ã‚¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DAY2015 ï¼ Publickey
NTTãƒ‡ãƒ¼ã‚¿ã¨PostgreSQLãŒæŒ‘ã‚“ã ç·åŠ›æˆ¦ã€‚PostgreSQLã‚’æ¥µé™ã¾ã§ä½¿ã„åˆ‡ã£ãŸãã®å…ˆã«è¦‹ãŸã‚‚ã®ã¨ã¯ï¼Ÿï¼ˆå‰ç·¨ï¼‰ NTTãƒ‡ãƒ¼ã‚¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DAY2015 ç¾åœ¨ã®ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã§ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ä½¿ã†ã“ã¨ã¯å½“ãŸã‚Šå‰ã«ãªã£ã¦ãã¦ã„ã¾ã™ã€‚PostgreSQLã¯ãã†ã—ãŸä¸ã§ä¸»ã«ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ç€å®Ÿã«äº‹ä¾‹ã‚’å¢—ã‚„ã—ã¦ãã¦ã„ã¾ã™ã€‚ ãã®ä¸ã§ã€PostgreSQLã‚’å¤§è¦æ¨¡ãªãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªã‚·ã‚¹ãƒ†ãƒ ã®ä¸ã§ä½¿ã†ã«ã¯ã€ã©ã®ã‚ˆã†ãªãƒŽã‚¦ãƒã‚¦ãŒæ±‚ã‚ã‚‰ã‚Œã‚‹ã®ã‹ã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®åˆ©ç”¨ã«ç©æ¥µçš„ãªNTTãƒ‡ãƒ¼ã‚¿ãŒãã®äº‹ä¾‹ã‚’ã€1æœˆ26æ—¥ã«é–‹å‚¬ã•ã‚ŒãŸã‚¤ãƒ™ãƒ³ãƒˆã€ŒNTTãƒ‡ãƒ¼ã‚¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹DAY 2015ã€ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒNTTãƒ‡ãƒ¼ã‚¿ã¨PostgreSQLãŒæŒ‘ã‚“ã ç·åŠ›æˆ¦ã€‚PostgreSQLã‚’æ¥µé™ã¾ã§ä½¿ã„åˆ‡ã£ãŸãã®å…ˆã«è¦‹ãŸã‚‚ã®ã¨ã¯ï¼Ÿã€ã§ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚è¬›æ¼”å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã«ã—ã¾ã—
sho 2015/02/09
å†…å®¹ã¯ã™ã”ãã†ãªã‚“ã ã‘ã©ã€SIerã®ãƒ—ãƒ¬ã‚¼ãƒ³è³‡æ–™ãŒ15å¹´ãã‚‰ã„é€²æ©ã—ã¦ãªã„ã®ãŒæ°—ã«ãªã£ã¦é ã«å…¥ã‚‰ãªã„w

postgresql

dbms
ãƒªãƒ³ã‚¯
ãªãœBTreeãŒIndexã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ã®ã‹ - maru source
â€»ã“ã®å†…å®¹ã¯å€‹äººçš„ãªè€ƒå¯Ÿãªã®ã§ã€é–“é•ã£ã¦ã„ã‚‹ç®‡æ‰€ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã†ã„ã†éƒ¨åˆ†ã‚’è¦‹ã¤ã‘ãŸéš›ã¯ãœã²æ•™ãˆã¦ä¸‹ã•ã„ã€‚ RDBMSã®æ¤œç´¢ã‚’æ—©ãã™ã‚‹ãŸã‚ã«Indexã£ã¦ä½¿ã„ã¾ã™ã‚ˆãã€‚ä¾‹ãˆã°ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE user ( id INT UNSIGNED NOT NULL, name VARCHAR(255) NOT NULL, UNIQUE INDEX (id) ); idã‚«ãƒ©ãƒ ã«Indexã‚’å¼µã£ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯idã§ã®æ¤œç´¢ã‚’é«˜é€Ÿã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ã“ã“ã§idã‚«ãƒ©ãƒ ã«IndexãŒè²¼ã£ã¦ã„ãªã„å ´åˆã¨æ¯”ã¹ã‚‹ã¨æ¤œç´¢æ™‚é–“ãŒå¤§å¹…ã«å¤‰ã‚ã£ã¦ãã¦ã—ã¾ã„ã¾ã™ï¼ˆç‰¹ã«ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå¤šããªã£ãŸæ™‚) ã§ã¯ãªãœIndexã‚’è²¼ã‚‹ã¨æ¤œç´¢ãŒæ—©ããªã‚‹ã‚“ã§ã—ã‚‡ã†ï¼Ÿï¼Ÿ Indexã¨ã¯ãã®åã®é€šã‚Šç´¢å¼•ã‚’æ„å‘³ã—ã¾ã™ã€‚ç‰¹å®šã®ã‚«ãƒ©ãƒ ã®ç´¢å¼•ã‚’ä½œæˆã—ã¦ãŠãã“ã¨ã§æ¤œç´¢ã‚’é«˜é€ŸåŒ–ã—ã¾ã™ã€‚ (æœ¬ã®æœ€å¾Œã«ã‚ˆã¿ãŒãªé †ã§å˜èªžãŒä¸¦ã¹ã‚‰ã‚ŒãŸã‚Šã—ã¦ã„ã¾ã™
sho 2014/03/28
algorithm

btree

dbms
ãƒªãƒ³ã‚¯
SQLä¸Šç´šè€…ã“ãçŸ¥ã£ã¦æ¬²ã—ã„ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ï¼Ÿ
(PgDay2012ç™ºè¡¨è³‡æ–™) SQLã«ã¨ã£ã¦ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ã‚’èª¬æ˜Žã—ãŸè³‡æ–™ã§ã™ã€‚Read less
sho 2012/12/07
ãƒ–ã‚³ãƒ¡ãŒè³›å¦ä¸¡è«–ãªã®ãŒé¢ç™½ã„ã

ormapper

dbms
ãƒªãƒ³ã‚¯
1