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

yooks id:yooks

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

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

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

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

Coding Style

db

è³‡æ–™

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
ãã‚ŒPostgreSQLã§ã§ãã‚‹ã‚ˆ @ Rails Developer Meetup 2018 Day 1
ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ https://github.com/fujimura/railsdm_2018_postgresql
yooks 2018/03/24
postgresql

db

windowé–¢æ•°
ãƒªãƒ³ã‚¯
DBeaver - å¤šå½©ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾å¿œã—ãŸç®¡ç†UI
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ãŸé–‹ç™ºã‚„é‹ç”¨æ™‚ã«ãŠã„ã¦GUIã®ç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ãŒæ¬²ã—ã„ã¨æ€ã†ã“ã¨ã¯å¤šã€…ã‚ã‚Šã¾ã™ã€‚ç‰¹ã«ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã‚ˆã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç¨®é¡žãŒé•ã£ãŸã‚Šã€æŽ¥ç¶šå…ˆãŒã‚ã¡ã“ã¡ã«å˜åœ¨ã™ã‚‹ã¨ãã†æ„Ÿã˜ã‚‹ã¯ãšã§ã™ã€‚ ãã“ã§ä½¿ã£ã¦ã¿ãŸã„ã®ãŒDBeaverã§ã™ã€‚å¤šå½©ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾å¿œã—ãŸç®¡ç†UIã§ã™ã€‚ DBeaverã®ä½¿ã„æ–¹ æŽ¥ç¶šå…ˆã®é¸æŠžç”»é¢ã§ã™ã€‚PostgreSQL/MySQL/MariaDB/DB2/Oracle/SQL Serverãªã©ã®åŸºæœ¬ã«åŠ ãˆã¦MS Accessã€infomixã€Mongo DBã€Firebirdãªã©ã‚‚é¸æŠžã§ãã¾ã™ã€‚ SSHãƒˆãƒ³ãƒãƒ«ã«å¯¾å¿œã—ã¦ã„ã‚‹ã®ã§æœ¬ç•ªç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ç¢ºèªã§ãã‚‹ã§ã—ã‚‡ã†ã€‚ æŽ¥ç¶šã—ã¾ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚‚ç¢ºèªã§ãã¾ã™ã€‚ ãƒ€ã‚¤ã‚¢ã‚°ãƒ©ãƒ ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã®é–¢ä¿‚ãŒåˆ†ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ DBeaverã‚’å…¥ã‚Œã¦ãŠã‘ã°ã€å¤§æŠµã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯æŽ¥ç¶šã§
yooks 2017/05/06
å‰ã«ä¸€åº¦è©¦ã—ã¦è¦‹ãŸã‘ã©ã€ã¡ã‚ƒã‚“ã¨ä½¿ã£ã¦ã¿ã‚ˆã†ã‹ãª

postgresql

DB
ãƒªãƒ³ã‚¯
Uberã®Postgresqlã‹ã‚‰NoSQL on MySQLã¸ã®ç§»è¡Œã‚’èªã‚“ã§ã–ã£ãã‚Šã¾ã¨ã‚ãŸ
Uber-migrated-pg-to-mysql.md Why Uber Engineering Switched from Postgres to MySQL - Uber Engineering Blog ã®ã¾ã¨ã‚ Posgresqlã ã¨ pgã¯è¿½è¨˜åž‹ãªã®ã§å°‘ã—ã®æ›´æ–°ã§ã‚‚å¤šãã®diskã¸ã®writeãŒãŠãã‚‹ ã‚«ãƒ©ãƒ ã‚’ä¸€ã¤æ›´æ–°ã—ãŸã ã‘ã§å¤šãã®indexã®æ›¸ãæ›ãˆãŒèµ·ã“ã‚‹ ã‚ˆã£ã¦ã€replicationã¯WALã‚’é€ã‚‹ã®ã§æ›´æ–°ãŒå¤šã„ã¨WALãŒå¤§é‡ã«é€ã‚‰ã‚Œã‚‹ repcliationã§ã¯ç‰©ç†çš„ãªdiskã®å¤‰æ›´ã‚’é€ã‚‹ DCé–“ã§ãƒ¬ãƒ—ãƒªã™ã‚‹ã¨ãã¤ã„ bugãŒã‚ã£ã¦replicaé–“ã§MVCCã®ä¸æ•´åˆãŒèµ·ãã‚‹ masterã¨replicaåŒã˜diskä¸Šã®ãƒ‡ãƒ¼ã‚¿æ§‹æˆã‚’å…±æœ‰ã™ã‚‹ã®ã§upgradeãŒã¤ã‚‰ã„ cache readã¯syscallã¨osã®page cacheçµŒç”±ãªã®ã§é‡ã„ 1ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³1ãƒ—ãƒã‚»ã‚¹
yooks 2016/07/28
postgresql

ã‚ã¨ã§èªã‚€

mysql

DB
ãƒªãƒ³ã‚¯
1