[B! database] jumpersonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

jumperson id:jumperson

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿ã‚’è§£é™¤

databaseã«é–¢ã™ã‚‹jumpersonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

Rails ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ŒRDBMS ã‚’å˜ãªã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¨ã—ã¦æ‰±ã†ã€ / Rails Anti-pattern RDBMS is not more than datastore
RDBMS ã¯ä¾¿åˆ©ã ã‹ã‚‰ã‚‚ã£ã¨ä½¿ã£ã¦ã„ãã¾ã—ã‚‡ã†ã¨ã„ã†ãŠè©±ã€‚ è¡¨å‚é“.rb #25 Rails ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ã§è©±ã—ã¾ã—ãŸã€‚ https://omotesandorb.connpass.com/event/62936/
jumperson 2017/08/19
RDMã®æ™®é€šã®è©±ã€‚Railsã¨ã‹ã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ä½¿ã£ã¦ã‚‹ã¨å¿˜ã‚ŒãŒã¡ãªã®ã‹ã‚‚ãã€‚

database

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

database

sql

MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
æ›¸ç±ç™ºè¡Œã®ãŠçŸ¥ã‚‰ã›ï¼šè©³è§£MySQL 5.7 ã€œé€²åŒ–ã—ãŸMySQLã‚’ã‚ˆãçŸ¥ã‚‹ãŸã‚ã®ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ã‚¬ã‚¤ãƒ‰ã€œ
æ—¢ã«æ˜¨æ—¥ã®db tech showcaseã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã”å˜ã˜ã®æ–¹ã‚‚å¤šã„ã ã‚ã†ãŒã€ã“ã®åº¦MySQL 5.7ã®æ–°æ©Ÿèƒ½ã‚’è§£èª¬ã™ã‚‹ãŸã‚ã®æ›¸ç±ã‚’ç™ºè¡Œã•ã›ã¦ã„ãŸã ãã“ã¨ã¨ãªã£ãŸã€‚8æœˆ23æ—¥ç™ºå£²äºˆå®šã§ã‚ã‚‹ã€‚ MySQL 5.7ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ã¯ã€ã“ã‚Œã¾ã§ãƒ–ãƒã‚°ã§ã¯ç´¹ä»‹ã—ã¦ã“ãªã‹ã£ãŸã€‚ã¨ã„ã†ã®ã‚‚ã€ã‚ã¾ã‚Šã«ã‚‚ãƒœãƒªãƒ¥ãƒ¼ãƒ ãŒå¤šã™ãŽã¦ã€ãƒ–ãƒã‚°ã¨ã„ã†åª’ä½“ã§ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ç´¹ä»‹ã™ã‚‹ã«ã¯å‘ã„ã¦ã„ãªã„ã¨æ€ã£ãŸã‹ã‚‰ã ã€‚ã¨ã¯ã„ãˆã€MySQL 5.7ã‚’çš†ã•ã‚“ã«ä½¿ã£ã¦ã„ãŸã ãã«ã¯ã€èª°ã‹ãŒæ–°æ©Ÿèƒ½ã‚’ã—ã£ã‹ã‚Šã¨è§£èª¬ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ã©ã†ã™ã‚‹ã¹ãã‹è€ƒãˆãŸçµæžœã€æ›¸ç±ã¨ã—ã¦ã¾ã¨ã‚ã¦å‡ºã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã£ãŸã€‚ æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦çœŸé¢ç›®ã«è§£èª¬ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€æ–°ã—ã„ãƒã‚¤ãƒ³ãƒˆãŒã©ã“ãªã®ã‹ã¨ã„ã†ã“ã¨ã‚’è¨€åŠã™ã‚‹ãŸã‚ã«ã€çµå±€ã®ã¨ã“ã‚å…ƒã€…ã®æ©Ÿèƒ½ã«ã¤ã„ã¦ã‚‚ã‚ã‚‹ç¨‹åº¦è§£èª¬ãŒå¿…è¦ã«ãªã£ã¦ã—ã¾ã†ã€‚ãã†ã„ã†ã‚ã‘ã§ã€ã“ã®æ›¸ç±ã§ã¯ã€MySQLãŒæŒã¤æ©Ÿèƒ½ã®åŸºæœ¬çš„ãªã‚³ãƒ³ã‚»ãƒ—ãƒˆã‚„
jumperson 2016/08/17
MySQL

book

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

MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®å‘½åè¦ç´„ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
jumperson 2016/01/09
database

naming
ãƒªãƒ³ã‚¯
1