[B! DB] SWIMATH2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

SWIMATH2 id:SWIMATH2

DBã«é–¢ã™ã‚‹SWIMATH2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

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

ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã«ãŠã‘ã‚‹æœ€è¿‘ã®ActiveRecordé‹ç”¨äº‹æƒ… - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã‚¤ãƒ³ãƒ•ãƒ©ã‚¹ãƒˆãƒ©ã‚¯ãƒãƒ£ãƒ¼éƒ¨ã®æˆç”°ï¼ˆ@mirakuiï¼‰ã§ã™ã€‚ Rails ã® OR ãƒžãƒƒãƒ‘ãƒ¼ã§ã‚ã‚‹ ActiveRecord ã§ã™ãŒã€ã¿ãªã•ã‚“ã©ã®ã‚ˆã†ã«é‹ç”¨ã—ã¦ã„ã¾ã™ã‹ï¼Ÿ ActiveRecord ã‚’ä½¿ã†ã¨ã€ SQL ã‚’ç›´æŽ¥æ‰±ã†ã“ã¨ãªãã€æŠ½è±¡åŒ–ã•ã‚ŒãŸè¡¨ç¾ã§ RDB ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã®ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºåŠ¹çŽ‡ã¨ã„ã†è¦³ç‚¹ã§ã¯ãƒ¡ãƒªãƒƒãƒˆãŒå¤§ãã„ã§ã™ã€‚ ä¸€æ–¹ã§ã€ ActiveRecord ãŒé§†ä½¿ã•ã‚Œã¦ã„ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚µãƒ¼ãƒã«é…ç½®ã—ã¦ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ã¨ã—ã¦é‹ç”¨ã™ã‚‹ç«‹å ´ã‹ã‚‰ã™ã‚‹ã¨ã€ã„ãã¤ã‹ã®å•é¡Œã«çªãå½“ãŸã‚Šã¾ã™ã€‚ ã¾ãšã¯ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰æœ¬ä½“ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹ã€æœ€æ–°ã® rake stats ã‚’ã”è¦§ãã ã•ã„ã€‚ +----------------------+-------+-------+---------+---------+-----+-------+ | Name | Lines | LOC
SWIMATH2 2020/04/12
db
ãƒªãƒ³ã‚¯
Behavior Driven Database Development Â· Passionate about data
SWIMATH2 2019/01/13
DBã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã¨ã‹åˆ¶ç´„ã¨ã‹ã‚‚BDDã§ãƒ†ã‚¹ãƒˆã—ã‚ˆã†ã¨ã„ã†è©±/ç†å¿µã¯åˆ†ã‹ã‚‹ã‘ã©ã€ORMä½¿ã£ã¦ã—ã¾ã†ã¨ã‚ã¾ã‚Šã«å¯†çµåˆãªãƒ†ã‚¹ãƒˆã«ãªã£ã¦ã—ã¾ã†æ„Ÿã˜ãŒã™ã‚‹

DB
ãƒªãƒ³ã‚¯
DataBase Refactoring
â– ã‚ªãƒ¼ãƒ—ãƒ³ã‚»ãƒŸãƒŠãƒ¼å²¡å±±ã®ç™»å£‡è³‡æ–™ã§ã™ã€‚ http://okayama.open-seminar.org/ â– Twitterã¾ã¨ã‚ https://togetter.com/li/1109418
SWIMATH2 2019/01/05
db
ãƒªãƒ³ã‚¯
slick-doc-ja 3.0 â€” ORMã‹ã‚‰Slickã‚’åˆ©ç”¨ã™ã‚‹äººã¸
Slick 3.0.0 documentation - 11 Coming from ORM to Slick Permalink to Coming from ORM to Slick â€” Slick 3.0.0 documentation ORMã‹ã‚‰Slickã‚’åˆ©ç”¨ã™ã‚‹äººã¸Â IntroductionÂ Slickã¯ã€Hibernateã‚„ä»–ã®JPAãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã®ã‚ˆã†ãªORMï¼ˆobject-relational mapperï¼‰ã§ã¯ç„¡ã„ã€‚Slickã¯ORMã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ã‚’æ°¸ç¶šåŒ–ã•ã›ã‚‹ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®1ã¤ã§ã‚ã‚Šã€ã„ãã¤ã‹ã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã¯å…±æœ‰ã—ã¤ã¤ã‚‚ã€å¤§ããªé•ã„ãŒã„ãã¤ã‹ã‚ã‚‹ã€‚æœ¬ç« ã§ã¯Slickã®ãƒ¡ãƒªãƒƒãƒˆã«ã¤ã„ã¦ã®ç†è§£ã‚’æ‰‹åŠ©ã‘ã—ã¤ã¤ã€ORMã¨ã®é•ã„ã«ã¤ã„ã¦é †ã«èª¬æ˜Žã™ã‚‹ã€‚object-relationalãªã‚‚ã®ã«å¯¾ã—ã¦è¨€åŠã•ã‚Œã‚‹æ§˜ã€…ãªå•é¡Œï¼ˆobject-relation-impedance mi
SWIMATH2 2018/12/31
ã†ãƒ¼ã‚“çµå±€ relational model ã‚’ãã®ã¾ã¾ä½¿ã†ã¨ã„ã†ã®ãŒè‰¯ã„ã®ã‹ãªã‚ã€‚çµå±€ domain å±¤ã®ãƒ¢ãƒ‡ãƒ«ã«å¤‰æ›ã™ã‚‹å¿…è¦ã‚ã‚Šãã†ã ã‘ã©ãã“ã‚’ã©ã†è§£æ±ºã™ã‚‹ã®ã‹æ°—ã«ãªã‚‹

DB

ORM

SQL
ãƒªãƒ³ã‚¯
Aurora ç§»è¡Œã‚’ã‚ãƒƒã‚«ã‚±ã«å¤§ããæ”¹å–„ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é‹ç”¨ | CyberAgent Developers Blog
ã¯ã˜ã‚ã« ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ•ã‚¡ãƒ³ãƒ‡ã‚£ãƒ³ã‚°ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ Makuake ã§ã‚¦ã‚§ãƒ–ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ãƒ¡ã‚¤ãƒ³ã§æ‹…å½“ã—ã¦ã„ã‚‹å‰ç”°æ…¶ç« ( @kakakakakku ) ã§ã™ï¼ŽDevelopers Blog ã§ã¯ï¼ŒéŽåŽ»ã«ã€ŽWell-Architected ã‚’ç›®æŒ‡ã—ãŸæ”¹å–„ã¨çµ„ç¹”æ–‡åŒ–ã¸ã®å½±éŸ¿ã€ã‚’åŸ·ç†ã—ãŸã‚Šï¼Œã€Žã€ŒçµŒå–¶å±¤ã‚’å·»ãè¾¼ã¾ãªã„ã¨é–‹ç™ºçµ„ç¹”ã¯å¤‰ã‚ã‚‰ãªã„ã€â€•â€•æ€¥æˆé•·ã™ã‚‹ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ•ã‚¡ãƒ³ãƒ‡ã‚£ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã€ŒMakuakeã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒç¤¾é•·ã¨å–ã‚Šçµ„ã‚“ã ã“ã¨ã€ã§çµ„ç¹”å¤‰é©ã‚’ãƒ†ãƒ¼ãƒžã«ã—ãŸã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼ã‚’å—ã‘ãŸã‚Šã—ã¦ã„ã¾ã™ï¼Žä»Šå›žã¯ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã£ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ MySQL 5.5 on EC2 ã‹ã‚‰ Amazon Auroraï¼ˆä»¥ä¸‹ï¼ŒAuroraï¼‰ã«å®Œå…¨ã«ç§»è¡Œã—ãŸäº‹ä¾‹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ï¼Žæ—¢ã«ãƒªãƒªãƒ¼ã‚¹ã‚’ã—ã¦ç´„1ãƒ¶æœˆç¨¼åƒã—ã¦ã„ã¾ã™ãŒï¼Œå¤§ããªå•é¡Œã‚‚ãªãå®‰å®šç¨¼åƒã—ã¦ã„ã¾ã™ï¼Ž èƒŒæ™¯ ä¾‹ãˆã°ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒãªã©ï¼Œæ—¢ã«ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆãŒå‰æ
SWIMATH2 2018/02/21
AWS

db

äº‹ä¾‹
ãƒªãƒ³ã‚¯
ã¤ã„ã«è§£ç¦ï¼Amazon Auroraå¾¹åº•æ¤œè¨¼ï¼
4. Masashi Terui @ marcy_terui Iâ€™m a developer and architect in the operators company (JIG-SAW Inc.) I'm the organizer on the some of events in sapporo with the theme of "Infrastructure as Codeâ€. Iâ€™m a AWS Certiï¬ed DevOps Engineer Professional. Iâ€™m a member of JAWS-UG Sapporo and GCPUG Sapporo (Coming soon!) Iâ€™m the winner of â€œTuningathon 5â€ (The theme was MySQL!) ABOUT ME 4
SWIMATH2 2018/02/21
AWS

DB
ãƒªãƒ³ã‚¯
Amazon Auroraã®å…ˆé€²æ€§ã‚’èª°ã‚‚è§£èª¬ã—ã¦ãã‚Œãªã„ã‹ã‚‰è§£èª¬ã™ã‚‹ - Qiita
TL;DR; Amazon Auroraã¯In-Memory DBã§ã‚‚ãªãDisk-Oriented DBã§ã‚‚ãªãã€In-KVS DBã¨ã§ã‚‚å‘¼ã¶ã¹ãæ–°åœ°å¹³ã«ç«‹ã£ã¦ã„ã‚‹ã€‚ ãã®æ–¬æ–°ã•ãŸã‚‹ã‚„ãƒžã‚¹ã‚¿ãƒ¼ã®ãƒ¡ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã§ã‚ã‚ŠãªãŒã‚‰Write-Backã§ã‚‚ãªãWrite-Throughã§ã‚‚ãªã„ã¨ã„ã†é©šå¤©å‹•åœ°ã€‚ ã¤ã„ã§ã«å¾“æ¥ã®ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆå‡¦ç†ã‚‚ä¸è¦ã«ãªã£ãŸã®ã§ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚‚å‘ä¸Šã—ãŸã€‚ è©³ç´°ãŒæ°—ã«ãªã‚‹äººã¯ã“ã®è¨˜äº‹ã‚’ãƒã‚§ã‚ï¼ Amazon Aurora Amazon Auroraã¯AWSã®ä¸ã§åˆ©ç”¨å¯èƒ½ãªãƒžãƒãƒ¼ã‚¸ãƒ‰(ï¼é‹ç”¨ã‚’AWSãŒé¢å€’è¦‹ã¦ãã‚Œã‚‹)ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã¯ãŸã ã®MySQLã€ã‚‚ã—ãã¯PostgreSQLã¨ã—ã¦æ‰±ã†äº‹ãŒã§ãã‚‹ã®ã§ãã‚Œã‚‰ã«ä¾å˜ã™ã‚‹æ—¢å˜ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è³‡ç”£ã‚’ãã®ã¾ã¾åˆ©ç”¨ã™ã‚‹äº‹ãŒã§ãã¦ã€è½ã¡ãŸã‚‰å†èµ·å‹•ã—ãŸã‚Šã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ‘ãƒƒãƒã‚’ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ãªã—ã§(!?)é©
SWIMATH2 2017/12/13
ã™ã”ãã†

DB

AWS
ãƒªãƒ³ã‚¯
TDDã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ä»˜ãåˆã†æ–¹æ³•
ã¯ã˜ã‚ã« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’èªã¿æ›¸ãã™ã‚‹éƒ¨åˆ†ã®ãƒ¦ãƒ‹ãƒƒãƒˆãƒ†ã‚¹ãƒˆãŒã‚„ã‚Šã«ãã„ã®ã«ã¯ã€ã„ãã¤ã‹ç†ç”±ãŒã‚ã‚Šã¾ã™ã€‚ è¤‡æ•°äººã§ãƒ†ã‚¹ãƒˆã‚’åŒæ™‚ã«å®Ÿè¡Œã™ã‚‹ã¨ã€ç«¶åˆã™ã‚‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ãŸãƒ†ã‚¹ãƒˆã¯ã€æ™‚é–“ãŒæŽ›ã‹ã‚‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ãƒ‡ãƒ¼ã‚¿ãŒå¤‰ã‚ã‚‹ã¨ã€ãƒ†ã‚¹ãƒˆãŒå¤±æ•—ã™ã‚‹ 1ç•ªç›®ã¯ã€å„è‡ªã®é–‹ç™ºç’°å¢ƒã«ãƒ†ã‚¹ãƒˆç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨æ„ã™ã‚‹ã“ã¨ã§ã€è§£æ±ºã§ãã¾ã™ã€‚2ç•ªç›®ã®å•é¡Œã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚³ãƒ¼ãƒ‰ã‚’ãƒã‚¸ãƒƒã‚¯ã‹ã‚‰åˆ†é›¢ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å®Ÿéš›ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ã‚’æ¸›ã‚‰ã™ã“ã¨ã§ã€æ”¹å–„ã§ãã¾ã™ï¼ˆãƒã‚¸ãƒƒã‚¯ã®ãƒ†ã‚¹ãƒˆã«ã¯ãƒ¢ãƒƒã‚¯ã‚„ãƒ€ãƒŸãƒ¼ã‚’ä½¿ã„ã¾ã™ï¼‰ã€‚3ç•ªç›®ã¯ã€ãƒ†ã‚¹ãƒˆã®ãŸã³ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’åˆæœŸåŒ–ã™ã‚‹ã“ã¨ãŒåŸºæœ¬ã«ãªã‚Šã¾ã™ãŒã€ãã†ã™ã‚‹ã¨ãƒ†ã‚¹ãƒˆã«é•·ã„æ™‚é–“ãŒæŽ›ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ã®é–‹ç™ºæ™‚ã«ãƒ¢ãƒƒã‚¯ã‚„ãƒ€ãƒŸãƒ¼ã‚’ä½¿ã„ã‚„ã™ãã™ã‚‹ã«ã¯ã©ã†ã™ã‚‹ã‹ã€ã¾ãŸã€ãƒ†ã‚¹ãƒˆæ™‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’å®‰å®šã•ã›ã‚‹ã«ã¯ã©ã†ã—ãŸã‚‰ã‚ˆã„ã‹
SWIMATH2 2017/11/28
ã¾ã‚åˆ†ã‹ã‚‹ã£ã¦æ„Ÿã˜ã‚‚ã™ã‚‹

DB

TDD
ãƒªãƒ³ã‚¯
DBãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’æ¯”è¼ƒã—ãŸ phpmig, migrate, goose - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
SWIMATH2 2017/11/15
DB
ãƒªãƒ³ã‚¯
1