[B! postgresql] zomyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

zomy id:zomy

postgresqlã«é–¢ã™ã‚‹zomyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼ŸÂ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã‚ˆãæ¯”è¼ƒã•ã‚Œã‚‹PostgreSQLã¨MySQLã€‚ã©ã‚“ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ï¼ŸÂ ãã‚Œãžã‚Œã®å°‚é–€å®¶ã«ã‚ˆã‚‹å¯¾è«‡ã§æ˜Žã‚‰ã‹ã«ã—ã¾ã™ã€‚ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒã„ã¦ã„ã‚‹ã¨å¿…ãšç›´é¢ã™ã‚‹æ‚©ã¿ã€‚ãã‚Œã¯ã€ã€Œã©ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€RDBï¼‰ã‚’é¸ã¶ã®ãŒæœ€å–„ãªã®ã‹ï¼Ÿã€ã§ã™ã€‚ RDBã”ã¨ã«é•·æ‰€ã¨çŸæ‰€ã¯ç•°ãªã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚è‡ªç¤¾ã‚µãƒ¼ãƒ“ã‚¹ã«ãƒžãƒƒãƒã—ãªã„RDBã‚’é¸ã‚“ã§ã—ã¾ã†ã¨ã€ãã‚ŒãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚Šé–‹ç™ºãƒ»é‹ç”¨ã«ãƒˆãƒ©ãƒ–ãƒ«ãŒç”Ÿã˜ã‚‹ã‚±ãƒ¼ã‚¹ã¯å°‘ãªãã‚ã‚Šã¾ã›ã‚“ã€‚ ãªã‹ã§ã‚‚ã‚ˆãæ¯”è¼ƒæ¤œè¨Žã•ã‚Œã‚‹ã®ãŒã€PostgreSQLã¨MySQLã€‚ã¨ã‚‚ã«ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹RDBã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã§ã‚ã‚Šã€é«˜ã„æ€§èƒ½ã¨æ•°å¤šãã®æ©Ÿèƒ½ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ã§ã¯ã€ä¸¡è€…ã¯å…·ä½“çš„ã«ã©ã®ã‚ˆã†ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ã
zomy 2017/09/05
postgresql

MySQL

RDB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

æ¯”è¼ƒ
ãƒªãƒ³ã‚¯
GitLab.comãŒæ“ä½œãƒŸã‚¹ã§æœ¬ç•ªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å–ªå¤±ã€‚5ã¤ã‚ã£ãŸã¯ãšã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹æ®µã¯å½¹ç«‹ãŸãšã€é ¼ã¿ã®ç¶±ã¯6æ™‚é–“å‰ã«å¶ç„¶å–ã£ãŸã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ ï¼ Publickey
æžœãŸã—ã¦GitLab.comã§ä½•ãŒèµ·ããŸã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã“ã‚Œã¾ã§ã®çµŒç·¯ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ ã‚¹ãƒ‘ãƒ ã«ã‚ˆã‚‹ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã®ã‚¹ãƒ‘ã‚¤ã‚¯ã‹ã‚‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸èª¿ã¸ GitLab.comã¯ä»Šå›žã®ã‚¤ãƒ³ã‚·ãƒ‡ãƒ³ãƒˆã«ã¤ã„ã¦ã®è©³ç´°ãªçµŒéŽã‚’ã€ŒGitLab.com Database Incident - 2017/01/31ã€ã§å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ã¾ãŸã€ã‚‚ã†å°‘ã—æ•´ç†ã•ã‚ŒãŸæƒ…å ±ãŒãƒ–ãƒã‚°ã€ŒGitLab.com Database Incident | GitLabã€ã«ã‚‚æŽ²è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã‚Œã‚‰ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’è»¸ã«ã€ä¸»ãªã§ãã”ã¨ã‚’æ™‚ç³»åˆ—ã«è¦‹ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ 1æœˆ31æ—¥16æ™‚ï¼ˆä¸–ç•Œå”å®šæ™‚ã€‚æ—¥æœ¬æ™‚é–“2æœˆ1æ—¥åˆå‰8æ™‚ï¼‰ã€YPæ°ï¼ˆYorick Peterseæ°ã¨æ€ã‚ã‚Œã‚‹ï¼‰ã¯PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¨å®šã™ã‚‹ãŸã‚ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®è«–ç†ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’ä½œæˆã€‚ã“ã‚ŒãŒã‚ã¨ã§å¤±ã‚ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’æ•‘ã†å¹¸é‹ã«ã¤ãªãŒã‚Šã¾ã™ã€‚ 1æœˆ31æ—¥21æ™‚
zomy 2017/02/02
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã—ãªã•ã™ãŽã¦å¼•ãã¤ã£ãŸç¬‘ã„ã—ã‹å‡ºãªã„ã€‚èƒƒãŒç—›ã„ã€‚

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

postgresql

database

gitlab

éšœå®³
ãƒªãƒ³ã‚¯
PHPerã«çŸ¥ã£ã¦ã»ã—ã„RDBã®äº‹ ãã®3
PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹é–¢è¥¿ 2016ã®è³‡æ–™ã§ã™ã€‚ http://conference.kphpug.jp/2016/
zomy 2016/08/14
RDB

slide

MySQL

postgresql
ãƒªãƒ³ã‚¯
ã“ã®RDBã«ã¤ã„ã¦ç§ã¯é©šãã¸ã‚™ãé—‡ã‚’è¦‹ã¤ã‘ãŸã‹ã‚™ãã“ã‚’ç™ºè¡¨ã™ã‚‹ã«ã¯ãƒãƒƒãƒˆã¯æ€–ã™ãã‚™ã‚‹
YAP(achimon)C::Asia Hachioji 2016midã®è³‡æ–™ã§ã™ã€‚
zomy 2016/07/04
MySQL

PostgreSQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

RDB

ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³

slide
ãƒªãƒ³ã‚¯
PostgreSQLã§ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’ç¢ºèªã™ã‚‹ã«ã¯ | hiro345
PostgreSQLã§ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’ç¢ºèªã™ã‚‹ã«ã¯ã„ãã¤ã‹æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚pg_dumpã§ã‚¹ã‚ãƒ¼ãƒžå®šç¾©ã‚’å–ã‚Šå‡ºã—ãŸæ–¹ãŒã¯ã‚„ã„ã‚ˆã†ãªæ°—ã‚‚ã—ã¾ã™ãŒã€ã¡ã‚‡ã£ã¨ã—ãŸç¢ºèªã‚’ã—ãŸã„ã¨ãã«ã¯ã‚„ã¯ã‚ŠSQLã§ã‚„ã‚ŠãŸã„ã¨ã“ã‚ã§ã™ã‚ˆãã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸€è¦§ã‚’è¡¨ç¤ºã™ã‚‹ã«ã¯ä¸‹è¨˜ã€‚ dbname=> \d ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸€è¦§ ã‚¹ã‚ãƒ¼ãƒž | åå‰ | åž‹ | æ‰€æœ‰è€… ----------+--------------+----------+--------- public | tablename | ãƒ†ãƒ¼ãƒ–ãƒ« | user001 (1 è¡Œ) SQLã§ã¯ä¸‹è¨˜ã€‚ select relname as TABLE_NAME from pg_stat_user_tables; ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã‚’è¦‹ãŸã„ã¨ãã¯ä¸‹è¨˜ã€‚ select * from information_schema.columns where table_catalog
zomy 2015/10/06
SQL

postgresql
ãƒªãƒ³ã‚¯
1