[B! rdb] yukungã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yukung id:yukung

rdbã«é–¢ã™ã‚‹yukungã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{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ã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã§ã‚ã‚Šã€é«˜ã„æ€§èƒ½ã¨æ•°å¤šãã®æ©Ÿèƒ½ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ã§ã¯ã€ä¸¡è€…ã¯å…·ä½“çš„ã«ã©ã®ã‚ˆã†ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ã
yukung 2017/09/05
database

mysql

postgresql

rdb
ãƒªãƒ³ã‚¯
ã‚³ãƒ³ãƒ•ãƒªã‚¯ãƒˆã—ãŸschema.rbã‚’ãã‚Œã„ã«ãƒžãƒ¼ã‚¸ã™ã‚‹æ‰‹é † - Qiita
ã¯ã˜ã‚ã« è¤‡æ•°ã®ãƒ¡ãƒ³ãƒãƒ¼ã§åŒã˜Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã—ã¦ã„ã‚‹ã¨ã‚³ãƒ¼ãƒ‰ã®ã‚³ãƒ³ãƒ•ãƒªã‚¯ãƒˆãŒã¨ãã©ãç™ºç”Ÿã—ã¾ã™ã€‚ æ™®é€šã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯äººé–“ãŒç›®ã§è¦‹ã¦ã©ã†ãƒžãƒ¼ã‚¸ã™ã¹ãã‹åˆ¤æ–ã™ã‚Œã°ã„ã„ã§ã™ãŒã€schema.rbã®ã‚ˆã†ã«Railsã«ã‚ˆã£ã¦è‡ªå‹•æ›´æ–°ã•ã‚Œã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¯æ‰‹ã§ä¿®æ£ã—ãªã„æ–¹ãŒè‰¯ã„ã§ã™ã€‚ ã˜ã‚ƒã‚schema.rbãŒã‚³ãƒ³ãƒ•ãƒªã‚¯ãƒˆã—ãŸã‚‰ã©ã†ã—ãŸã‚‰ã„ã„ã®ï¼ï¼Ÿã¨ã„ã†äººã®ãŸã‚ã«ãƒžãƒ¼ã‚¸ã™ã‚‹æ‰‹é †ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ å¯¾è±¡ã¨ãªã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ æœ¬è¨˜äº‹ã¯ä»¥ä¸‹ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’å¯¾è±¡ã¨ã—ã¦ã„ã¾ã™ã€‚ Rails 5.0.2 Git 2.12.2 ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ ã“ã®æ‰‹é †ã§ä½¿ã£ãŸRailsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆãƒžãƒ¼ã‚¸ãŒã™ã¹ã¦çµ‚ã‚ã£ãŸçŠ¶æ…‹ï¼‰ã¯GitHubã«ã‚¢ãƒƒãƒ—ã—ã¦ã‚ã‚Šã¾ã™ã€‚ æƒ³å®šã™ã‚‹ã‚·ãƒŠãƒªã‚ª ã“ã“ã§ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ã‚¢ãƒªã‚¹ã¨ãƒœãƒ–ãŒåŒã˜ãƒ†ãƒ¼ãƒ–ãƒ«ï¼ˆåŒã˜ãƒ¢ãƒ‡ãƒ«ï¼‰ã«å¯¾ã—ã¦ç•°ãªã‚‹ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã—ã‚ˆã†ã¨ã™ã‚‹çŠ¶æ³ã‚’æƒ³å®šã—ã¾ã™ã€‚ ã‚¢ãƒªã‚¹ = Blogãƒ¢ãƒ‡ãƒ«ã«a
yukung 2017/06/30
programming

ruby

rails

tips

rdb

migration
ãƒªãƒ³ã‚¯
ä¼¼ã¦ã„ã‚‹ã‚ˆã†ã§å…¨ç„¶é•ã†!?Activerecordã«ãŠã‘ã‚‹includesã¨joinsã®æŒ¯ã‚‹èˆžã„ã¾ã¨ã‚ - Qiita
Activerecordã‚’ä½¿ã£ã¦ã‚‹ã¨ãã€é–¢é€£(Association)ã®ã‚ã‚‹modelåŒå£«ã‚’ã¾ã¨ã‚ã¦å–å¾—ã—ãŸã„æ™‚ãŒã‘ã£ã“ã†ã‚ã‚‹ã€‚ãã‚“ãªæ™‚ã€includesã‚„joinsã‚’ä½¿ãˆã°åŠ¹çŽ‡è‰¯ããƒ‡ãƒ¼ã‚¿ã‚’å–å¾—å‡ºæ¥ã‚‹ã‚“ã ã‘ã©ã€å®Ÿã¯ã“ã®äºŒã¤ã¯æŒ¯ã‚‹èˆžã„ã‚„ç‰¹å¾´ãŒå…¨ç„¶é•ã£ã¦ãŸã‚Šã™ã‚‹ã€‚ã‚„ã‚„ã“ã—ã„æ°—ãŒã—ãŸã®ã§ã€ã“ã“ã§ã¡ã‚‡ã£ã¨ã¾ã¨ã‚ã¦ãŠãã€‚ å…ˆã«çµè«–ã‚’æ›¸ã„ã¦ãŠãã¨ã€åŸºæœ¬çš„ã«ã¯ includesã¯å…ˆèªã¿ã—ã¦ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ãŠãã€‚ joinsã¯ãŸã INNER JOINã—ã¦ãã‚Œã‚‹ã€‚ ã¨æ€ã£ã¦ãŠã‘ã°OKã€‚ ã¡ãªã¿ã«ã€railsã®versionã¯4.1.0ã€‚Webä¸Šã«è½ã¡ã¦ã‚‹æƒ…å ±ã¯å¤ã„ã›ã„ã‹è‹¥å¹²ç¾çŠ¶ã®æŒ™å‹•ã¨ã¯é•ã£ã¦ãŸã‚Šã—ãŸã®ã§ã€æ°—ã‚’ã¤ã‘ãŸæ–¹ãŒè‰¯ã•ãã†ã€‚ includes includesã¯ãƒ‡ãƒ¼ã‚¿ã®å…ˆèªã¿ã‚’ã—ã¦ãã‚Œã‚‹ã€‚ãã®ç‚ºã€é–¢é€£modelã«å¯¾ã™ã‚‹å‚ç…§ã‚’æŒã¡ãŸã„å ´åˆã«ä½¿ã†ã€‚ãã†è¨€ã‚ã‚Œã¦ã‚‚ã‚ˆãã‚ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€å®Ÿéš›ã«ä½¿ç”¨ä¾‹ã‚’è¦‹ã¦ã¿
yukung 2017/06/30
programming

ruby

rails

tips

rdb
ãƒªãƒ³ã‚¯
ActiveRecordã®joinsã¨preloadã¨includesã¨eager_loadã®é•ã„ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
yukung 2017/06/30
programming

ruby

rails

tips

rdb
ãƒªãƒ³ã‚¯
https://qiita.com/merrill/items/de6eb7e899753ad3361a
yukung 2017/06/30
programming

ruby

rails

tips

rdb
ãƒªãƒ³ã‚¯
ãªãœAWSÂ Lambdaã¨RDBMSã®ç›¸æ€§ãŒæ‚ªã„ã‹ã‚’ç°¡å˜ã«èª¬æ˜Žã™ã‚‹ - Sweet Escape
2020/01/20 Update: æœ¬ã‚¨ãƒ³ãƒˆãƒªã®å†…å®¹ã¯2019å¹´12æœˆ3æ—¥ã«ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã•ã‚ŒãŸã€ŽAmazon RDS Proxyã€ã®ãƒªãƒªãƒ¼ã‚¹ã«ã‚ˆã‚Šå®Œå…¨ã«é™³è…åŒ–ã—ã¾ã—ãŸã€‚éŽåŽ»ã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ãŒãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’ã‚‚ã¨ã«ã—ãŸæ”¹å–„ã«ã‚ˆã£ã¦ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã¯ãªããªã‚‹ã¨ã„ã†æœ€é«˜ã®äº‹ä¾‹ã§ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ãƒ¬ã‚¹å…ƒå¹´å§‹ã¾ã£ãŸï¼ ä»Šå¹´ãŒã‚µãƒ¼ãƒãƒ¼ãƒ¬ã‚¹å…ƒå¹´ãªç†ç”±. ãã‚Œã¯Lambdaã«ä»¥ä¸‹ãŒæƒã£ãŸã‹ã‚‰. ãƒ»ã‚«ã‚¹ã‚¿ãƒ ãƒ©ãƒ³ã‚¿ã‚¤ãƒ ã§å®Ÿè³ªã©ã‚“ãªè¨€èªžã§ã‚‚åˆ©ç”¨å¯èƒ½ ãƒ»VPCåˆ©ç”¨æ™‚ã®ã‚³ãƒ¼ãƒ«ãƒ‰ã‚¹ã‚¿ãƒ¼ãƒˆæ”¹å–„ ãƒ»Provisioned Concurrencyã§ã‚¹ãƒ‘ã‚¤ã‚¯å¯¾å¿œã‚‚å¯èƒ½ ãƒ»RDS Proxyã§RDBã¨ã®æŽ¥ç¶šãŒç¾å®Ÿçš„ã« ã“ã‚Œã¾ã§5å¹´ã§å—ã‘ãŸãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ãŒã¤ã„ã«çµå®Ÿ. å¼·ã„â€” Keisuke Nishitani (@Keisuke69) 2020å¹´1æœˆ19æ—¥ RDS Proxyã®è©³ç´°ã¯ã“ã¡ã‚‰ã‹ã‚‰ã©ã†ãžã€‚ã¾ã ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§ã™ãŒãœã²è©¦ã—ã¦
yukung 2017/06/21
aws

lambda

rdb

rds

database
ãƒªãƒ³ã‚¯
ã€Œç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ã€èªã‚“ã - $shibayu36->blog;
ç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQL (WEB+DB PRESS plus) ä½œè€…:å¥¥é‡Ž å¹¹ä¹ŸæŠ€è¡“è©•è«–ç¤¾Amazon ç©ã‚“èªã«å…¥ã£ã¦ã„ãŸã®ã§èªã‚“ã ã€‚ ã“ã®æœ¬ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’ç†è§£ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦RDBã®çŸ¥è˜ã‚’æ·±ã‚ã‚ˆã†ã¨ã„ã†ã‚ˆã†ãªæœ¬ã€‚RDBã‚’å®Ÿè·µã§ä½¿ã£ã¦ã„ã‚‹äººãŒã•ã‚‰ã«çŸ¥è˜ã‚’æ·±ã‚ã‚‹ãŸã‚ã®æœ¬ã¨ã„ã†æ„Ÿã˜ã€‚å†…å®¹ã¨ã—ã¦ã¯é‡è¦ãªç†è«–ãŒRDBã¨ç´ä»˜ã‘ã‚‰ã‚Œã¦è§£èª¬ã•ã‚Œã¦ã„ã¦é¢ç™½ã‹ã£ãŸã€‚ä¸€æ–¹ã§ã€å°‚é–€ç”¨èªžãŒæ–‡ç« ä¸ã«å¤šãä½¿ã‚ã‚Œã¦ã„ã¦ã€å€‹äººçš„ã«ã¯ä½•ã‹é ã«å…¥ã£ã¦ã“ãªã‹ã£ãŸç‚¹ã¯æ®‹å¿µã ã£ãŸã€‚ ã“ã®æœ¬ã‚’èªã¿ãªãŒã‚‰ã‚ã‹ã‚‰ãªã„ã¨ã“ã‚ã‚’èª¿ã¹ã¦ã„ã¦è¦‹ã¤ã‘ãŸã®ã ã‘ã©ã€ã“ã®æœ¬ã®è‘—è€…ã®æ˜”ã®ç™ºè¡¨è³‡æ–™ã§ã‚ã‚‹ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆå¾¹åº•æŒ‡å—ï¼ï¼ã€ãŒã“ã®æœ¬ã®ç«¯çš„ãªã¾ã¨ã‚ã«ãªã£ã¦ã„ã¦ã€ã—ã‹ã‚‚éžå¸¸ã«è‰¯ã„è³‡æ–™ãªã®ã§æœ¬å½“ã«ãŠã™ã™ã‚ã€‚æœ¬ã§ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚„æ£è¦åŒ–ç†è«–ãªã©ãŒã‚ãšã‹15åˆ†ç¨‹åº¦ã§ç†è§£ã§ãã‚‹
yukung 2017/03/13
book

database

rdb
ãƒªãƒ³ã‚¯
ã€Œç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ã€ã‚’èªç ´ã™ã‚‹ãŸã‚ã®å‚è€ƒè³‡æ–™ - å‘¨å›žé…ã‚Œã®ãƒ–ãƒ«ãƒ¼ã‚¹
å…ˆæ—¥æ¥ã€ãšã£ã¨ã€Œç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ã€ã‚’èªã‚“ã§å‹‰å¼·ä¸ã§ã™ã€‚ ç§ã¯ã©ã¡ã‚‰ã‹ã¨è¨€ãˆã°ä¸‹æµãƒ¡ã‚¤ãƒ³ã§ DBè¨è¨ˆã«é–¢ã—ã¦ã¯æ„è¦‹ã§ãã‚‹ç¨‹åº¦ã§ã™ãŒã€ãã‚Œã§ã‚‚SQLã¯å‰²ã¨æ›¸ãæ–¹ã ã—DBé–¢é€£æ›¸ç±ã‚‚ã„ãã¤ã‹èªã‚“ã§ãŸã®ã§ã€ãã‚Œãªã‚Šã«åˆ¤ã£ã¦ãŸã¤ã‚‚ã‚Šã§ã—ãŸã€‚ã ã‘ã«ã€èªã‚ã°èªã‚€ã»ã©ã€ä»Šã¾ã§ RDB ã‚„ DBè¨è¨ˆã«ã¤ã„ã¦ã©ã‚Œã ã‘å‹˜é•ã„ã—ã¦ãŸã®ã‹ã€ã¤ãã¥ãèº«ã«ã¤ã¾ã•ã‚Œã‚‹æ€ã„ã§ã™ã€‚ã‚€ã‹ã—ã€Œï¼‘ãƒšãƒ¼ã‚¸ã«1åº¦ã€ã‚ãªãŸã¯æ¿€ã—ãã†ãªãšãã€ã¨ã‹ã„ã£ã¦å®£ä¼ã—ã¦ã‚‹æœ¬ã‚ã‚Šã¾ã—ãŸãŒã€ã“ã®æœ¬èªã‚“ã§ã‚‹ã¨ã€5ãƒšãƒ¼ã‚¸ã«1åº¦ã¯ã€ã€ŒãŠãŠã€ãã†ã ã£ãŸã®ã‹ãƒ¼ï¼ã€ã¨ä»°ã‘åã‚‹ã‚ˆã†ãªè¨˜è¿°ãŒå‡ºã¦ãã‚‹ã®ã§ã€æœ¬å½“ã«é©šã‹ã•ã‚Œã¾ã™ãã€‚ ç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQL (WEB+DB PRESS plus) ä½œè€…: å¥¥é‡Žå¹¹ä¹Ÿå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: æŠ€è¡“è©•è«–ç¤¾ç™ºå£²æ—¥: 2015/03/10ãƒ¡ãƒ‡ã‚£ã‚¢: å˜è¡Œæœ¬ï¼ˆã‚½ãƒ•ãƒˆã‚«ãƒãƒ¼ï¼‰ã“
yukung 2016/06/20
sql

rdb

book

database
ãƒªãƒ³ã‚¯
æ›¸ç±å‡ºç‰ˆã®ãŠçŸ¥ã‚‰ã›ï¼šç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQL
æ¥ã‚‹2æœˆ27æ—¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–°æ›¸ç±ã‚’ç™ºå£²ã•ã›ã¦é ‚ãã“ã¨ã«ãªã£ãŸã€‚ã‚¿ã‚¤ãƒˆãƒ«ã¯ã€Œç†è«–ã‹ã‚‰å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å®Ÿè·µå…¥é–€ ~ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã‚ˆã‚‹åŠ¹çŽ‡çš„ãªSQLã€ã¨ãªã£ã¦ã„ã‚‹ã€‚å˜ã«ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã¨æ›¸ã„ã¦ã‚ã‚‹ãŒã€RDBãŒãƒ¡ã‚¤ãƒ³ã®ãƒ†ãƒ¼ãƒžã®æ›¸ç±ã§ã‚ã‚‹ã€‚ å¤šãã®äººãŒæœªã ã«RDBã‚’ä½¿ã„ã“ãªã›ã¦ã„ãªã„ã®ã§ã¯ãªã„ã‹ã€‚RDBã®ä½¿ã„æ–¹ã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ã«ã¯ä½•ãŒå¿…è¦ãªã®ã‹ã€‚ãã‚ŒãŒã“ã“æ•°å¹´ç§ãŒè¿½ã£ã¦ããŸãƒ†ãƒ¼ãƒžã§ã‚ã‚Šã€ã“ã®æ›¸ç±ã‚’å‡ºã™ã“ã¨ã«ãªã£ãŸå‹•æ©Ÿã§ã‚ã‚‹ã€‚ ã‚ã¾ã‚Šã«ã‚‚é…·ã„DBè¨è¨ˆã€ã‚ã¾ã‚Šã«ã‚‚ã‚¹ãƒ‘ã‚²ãƒ†ã‚£ãªã‚¯ã‚¨ãƒªã€ã‚ã¾ã‚Šã«ã‚‚å¸Œè–„ãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã¸ã®ç†è§£ã€‚ãã†ã„ã£ãŸå•é¡Œã¯ã©ã“ã‹ã‚‰ç”Ÿã¿å‡ºã•ã‚Œã‚‹ã®ã‹ã€‚ãã®ã²ã¨ã¤ã®çµè«–ã¨ã—ã¦ãŸã©ã‚Šç€ã„ãŸã®ãŒã€ã€Œãã‚‚ãã‚‚RDBã®ä½¿ã„æ–¹ãŒã‚ã¾ã‚Šç†è§£ã•ã‚Œã¦ã„ãªã„ã®ã§ã¯ãªã„ã‹ã€ã¨ã„ã†ã“ã¨ã ã£ãŸã€‚åè‘—ã€SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã¯ã€Œã‚„ã£ã¦ã¯ã„ã‘ãªã„ã‚±ãƒ¼ã‚¹ã€ã«ã¤ã„ã¦å¦ã¶ã“ã¨ãŒã§ãã‚‹ãŒã€ãã®åå¯¾ã®ãƒ†ãƒ¼ãƒžã€ã¤ã¾ã‚Šæœ¬æ¥ã©ã®
yukung 2016/06/20
book

mysql

database

rdb

sql

design
ãƒªãƒ³ã‚¯
nullã«ã¤ã„ã¦æœ€å¾Œã¾ã§è€ƒãˆã‚‹(1) --- Tå—å½¢ã§æ¶ˆã›ã‚‹nullï¼Œæ¶ˆã›ãªã„null - æ¥µåŒ—ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°
æ£ç¾Žæ°ã¨ã‹Dateã®æœ¬ã‚’èªã‚€ã¨ã€Coddè«–æ–‡ã‚’ç†è§£ã™ã‚‹ã¨nullã®å˜åœ¨ãŒè¨±ã›ãªããªã‚‹ã®ã ãªã‚ã€ã¨æ€ã†ã€‚ ç§ã¯ã“ã®nullå¾¹åº•æŽ’é™¤ã®æ„Ÿè¦šãŒç†è§£ã§ãã¦ã„ãªã„ã€‚Coddè«–æ–‡èªã‚“ã ã“ã¨ãªã„ã—ã€‚ æ¯”è¼ƒæ¼”ç®—ã‚„é›†è¨ˆæ¼”ç®—ã®å¯¾è±¡ã« null ãŒæ··å…¥ã—ã¦ã„ã‚‹ã¨ã€ç›´æ„Ÿã«åã™ã‚‹çµæžœãŒå‡ºã¦ãã‚‹ã“ã¨ãŒã‚ã‚‹ã®ã¯ã‚ã‹ã‚‹ã€‚ åŒåƒšãŒnot nullåˆ¶ç´„ã‚’ä»˜ã‘ã¦ã„ãªã„ã®ã‚’è¦‹ã¤ã‘ã‚‹ã¨ã€Œä»˜ã‘ãªã„ã¨ã ã‚ã£ã™ã‚ˆã€ã¨è¨€ã£ãŸã‚Šã‚‚ã™ã‚‹ã€‚ ã§ã‚‚ã€ã“ã‚Œã¯ã‚ã‹ã£ãŸæŒ¯ã‚Šã‚’ã—ã¦ã„ã‚‹ã ã‘ãªã®ã ã€‚ nullãŒã‚ˆããªã„ã®ã¯å½“ãŸã‚Šå‰ã¨ã—ã¦ã€ã‚ã‚‰ã‚†ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§nullã‚’ç™ºç”Ÿã•ã›ãªã„ã“ã¨ãŒã§ãã‚‹ã®ã ã‚ã†ã‹ï¼Ÿ ã©ã†ã—ã¦ã‚‚ç™ºç”Ÿã™ã‚‹ã‚±ãƒ¼ã‚¹ãŒã‚ã‚‹ã®ã ã¨ã™ã‚Œã°ã€ã©ã®nullã¯ã‚ã£ã¦ã‚‚ã‚ˆãã¦ã€ã©ã®nullã¯ã‚ã£ã¦ã¯ãªã‚‰ãªã„ã®ã‹ï¼Ÿ whereå¥ã«å‡ºç¾ã™ã‚‹nullã¨ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªãŒè¿”ã™nullã¨ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«è¿”ã•ã‚Œã‚‹nullã¨ã€ç½ªã®é‡ã•ã¯å…¨éƒ¨åŒã˜ãªã®ã‹ï¼ˆé•ã†ã‚“ã˜ã‚ƒãª
yukung 2015/06/22
development

design

database

rdb
ãƒªãƒ³ã‚¯
ã‚°ãƒªãƒ¼CTOãŒèªžã‚‹ã€å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ é–‹ç™ºã®èˆžå°è£
9æœˆ1æ—¥ã€ã‚²ãƒ¼ãƒ é–‹ç™ºè€…å‘ã‘ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒCEDEC 2010ã€ã«ãŠã„ã¦ã€SNSã€ŒGREEã€ã‚’é‹å–¶ã™ã‚‹ã‚°ãƒªãƒ¼æ ªå¼ä¼šç¤¾ï¼ˆä»¥ä¸‹ ã‚°ãƒªãƒ¼ï¼‰ãŒã€Žå¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ã¤ãã‚Šã‹ãŸ ï½ž60åˆ†ã§ã‚ã‹ã‚‹ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰æŠ€è¡“ï½žã€ã¨é¡Œã™ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’è¬›æ¼”ã—ãŸã€‚ ä¸€æ—¥ã‚ãŸã‚Šå„„å˜ä½ã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’æŒãã‚¤ãƒ³ãƒ•ãƒ©ã¯ã©ã†ãªã£ã¦ã„ã‚‹ã®ã‹ã€‚æŠ€è¡“è€…2åãŒè§£èª¬ã—ãŸã‚¤ãƒ³ãƒ•ãƒ©æ§‹ç¯‰ã®ãƒŽã‚¦ãƒã‚¦ã‚„ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã¨ä¸€èˆ¬ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚²ãƒ¼ãƒ ã¨ã®é•ã„ã«ã¤ã„ã¦ç´¹ä»‹ã™ã‚‹ã€‚ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚²ãƒ¼ãƒ ã¨ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã¨ã®é•ã„ æœ€è¿‘ãƒ†ãƒ¬ãƒ“CMã§ã‚‚ç›®ã«ã™ã‚‹æ©Ÿä¼šãŒå¤šããªã£ã¦ããŸSNSï¼ˆã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ï¼‰ã®ã€ŒGREEï¼ˆã‚°ãƒªãƒ¼ï¼‰ã€ã€‚2010å¹´6æœˆæ™‚ç‚¹ã®æ•°å—ã§ã€ä¼šå“¡æ•°2059ä¸‡äººã€æœˆé–“353å„„ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¨ã„ã†è¨€ã‚ãšã¨ã—ã‚ŒãŸå¤§äººæ°—ã‚µã‚¤ãƒˆã ã€‚ä¸ã§ã‚‚æºå¸¯é›»è©±å‘ã‘ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒç‰¹å¾´çš„ã§ã€å°‚ç”¨æ©Ÿå‘ã‘ã®ã‚²ãƒ¼ãƒ ã¨æ¯”ã¹ã‚‹ã¨ã‚³ã‚¢ã‚²ãƒ¼ãƒžãƒ¼ä»¥å¤–ã®ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã‚‚å¤šãã€åˆ©
yukung 2010/09/14
gree

webservice

performance

rdb
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
yukung 2010/01/10
development

database

oop

rdb
ãƒªãƒ³ã‚¯
1