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

sugyan id:sugyan

databaseã«é–¢ã™ã‚‹sugyanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

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

ã‚¼ãƒã‹ã‚‰ä½œã‚‹æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³
è»½é‡ãªæ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ã‚¹ã‚¯ãƒ©ãƒƒãƒã§é–‹ç™ºã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ã€ã©ã®ã‚ˆã†ã«å®Ÿè£…ã—ãŸã®ã‹ã‚’å¿…è¦çŸ¥è˜ã®è§£èª¬ã‚’äº¤ãˆãªãŒã‚‰ã¾ã¨ã‚ã¦ã„ãã¾ã™ã€‚ å®Ÿè£…ã¯Goè¨€èªžã«ã‚ˆã‚‹ã‚‚ã®ã§ã™ãŒã€æœ¬è¨˜äº‹ã®ã»ã¨ã‚“ã©ã¯è¨€èªžéžä¾å˜ãªå†…å®¹ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ ç†è€…ã¯æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ãƒ„ãƒ¼ãƒ«ã‚’ã„ãã¤ã‹é–‹ç™ºã—ã¦ã„ã¾ã™ã€‚ãã®ä¸ã®ä¸€ã¤ã§ã‚ã‚‹Aliã¯è² è·ãƒ†ã‚¹ãƒˆç”¨ã®cliãƒ„ãƒ¼ãƒ«ã§ã€ãƒ¡ãƒˆãƒªã‚¯ã‚¹ã‚’ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã§ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ æç”»ã§ãã‚‹ã®ãŒç‰¹å¾´ã§ã™ã€‚ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«ãƒ¬ã‚¤ãƒ†ãƒ³ã‚·ãƒ¼ãªã©ã®è¨ˆæ¸¬çµæžœãŒéš›é™ãªãæ›¸ãè¾¼ã¾ã‚Œã¦ãã‚‹ä¸ã€åŒæ™‚ã«ä¸€å®šã®ã‚¯ã‚¨ãƒªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ±‚ã‚ã‚‰ã‚Œã¾ã™ã€‚ ã“ã‚Œã¯è¨€ã£ã¦ã—ã¾ãˆã°ã€ç°¡æ˜“ã‚¯ã‚¨ãƒªæ©Ÿèƒ½ä»˜ãã®pushåž‹ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã‚·ã‚¹ãƒ†ãƒ ã‚’å˜ä¸€ãƒ›ã‚¹ãƒˆã§å®Ÿç¾ã™ã‚‹ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ ä»¥å‰ã¾ã§ã®å®Ÿè£…ã§ã¯ãƒ’ãƒ¼ãƒ—ä¸Šã®å¯å¤‰é•·é…åˆ—ã«ãƒ‡ãƒ¼ã‚¿ãƒã‚¤ãƒ³ãƒˆã‚’è¿½åŠ ã—ã¦ã„ãã ã‘ã ã£ãŸã®ã§ã€å½“ç„¶ãªãŒã‚‰æ™‚é–“ã®çµŒéŽã¨ã¨ã‚‚ã«ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ãŒå¢—åŠ ã—ã¦ã„ãå•é¡Œã‚’æŠ±ãˆã¦
sugyan 2021/06/30
database

tsdb

golang
ãƒªãƒ³ã‚¯
SQL Training 2021
Transcript SQL æ ªå¼ä¼šç¤¾ AI Shift ä¸‰å®… æ‚ å¤ª 1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 2. SQL I 3.ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ 4. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ 5. ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ 6. å®Ÿè¡Œè¨ˆç”» 7. SQL II ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ â€œA database is an organized collection of inter-related data that models some aspect of the real-world â€œ (CMU) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ã€å®Ÿä¸–ç•Œã®ã‚ã‚‹å´é¢ã‚’ãƒ¢ãƒ‡ãƒ«åŒ–ã—ãŸã€ç§©åº ã ã£ãŸã€ç›¸äº’ã«é–¢é€£ã—ãŸãƒ‡ãƒ¼ã‚¿ã®é›†ã¾ã‚Š DBMS â€¢ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ â—¦ ä¾‹ï¼šMySQL, Oracle Database, SQLite, Mongo DB â€¢ DBMSã®ç›®çš„ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼
sugyan 2021/06/24
sql

database

education
ãƒªãƒ³ã‚¯
rdb antipattern refactoring
Builderscon 2017ã®ç™»å£‡è³‡æ–™ã§ã™ https://builderscon.io/tokyo/2017/session/c8f36693-32aa-4bf1-816a-4966f3859926
sugyan 2017/08/05
builderscon

RDB

database

presentation
ãƒªãƒ³ã‚¯
æ™‚ç³»åˆ—DBã£ã¦çµå±€ã©ã‚ŒãŒã„ã„ã‚“ã ã£ã‘ #TSDB - weblog of key_amb
â€»4/6 ãã®å¾Œèª¿ã¹ãŸæƒ…å ±ãªã©ã‚’è¨˜äº‹æœ«å°¾ã«è¿½è¨˜ å‰æã¨ãªã‚‹ãƒ‹ãƒ¼ã‚º ã‚µãƒ¼ãƒã®è² è·æƒ…å ±ã¨ã‹ã€ã‚¢ã‚¯ã‚»ã‚¹çŠ¶æ³ã®ã‚ˆã†ãª KPI ã‚’å–å¾—ãƒ»ä¿å˜ã—ã€å¯è¦–åŒ–(å‚ç…§ã—ã¦ã‚°ãƒ©ãƒ•åŒ–)ã—ãŸã„ã€‚ ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ æ€§ãŒè¦æ±‚ã•ã‚Œã‚‹ã€‚5åˆ†ä»¥ä¸Šå‰ã®ãƒ‡ãƒ¼ã‚¿ã—ã‹è¦‹ã‚Œã¾ã›ã‚“ã¿ãŸã„ãªã®ã¯ãŠå‘¼ã³ã§ãªã„ã€‚ å¤ã„ãƒ‡ãƒ¼ã‚¿ã¯ãã‚“ãªã«ç²¾åº¦ã¯æ°—ã«ã—ãªã„ã‘ã©ã€ãƒãƒ³ã‚°ã‚¹ãƒ‘ãƒ³ã§ä¿¯çž°ã—ã¦è¦‹ã‚ŒãŸã‚‰ä¾¿åˆ©ã€‚ æœ€è¿‘ã¯ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ç’°å¢ƒã®æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿è§£æžã‚‚ãƒ“ã‚¸ãƒã‚¹ã§ã¯ã‘ã£ã“ã†ãƒ‹ãƒ¼ã‚ºãŒã‚ã‚Šãã†ã ã‘ã©ã€ãã£ã¡ã¯ã‚‚ã†å°‘ã—è¦æ±‚ãŒå¤šãã†ã€‚ ã“ã“ã§ã¯è€ƒãˆãªã„ã“ã¨ã«ã™ã‚‹ã€‚ é¸æŠžè‚¢ã«ãªã‚Šãã†ãªã‚‚ã® å¤ãã‚ˆã RRDtool Elasticsearch + Kibana Graphite + Grafana Influx DB + Grafana ç‰ Zabbix ä»–ã«ã€ç¾å®Ÿçš„ã«ã¯ SaaS ã«ä»»ã›ã‚‹ã¨ã„ã†æ‰‹æ®µã‚‚ã‚ã‚‹ã ã‚ã†ã‘ã©ã€ãã†è¨€ã†ã¨è©±ãŒçµ‚ã‚ã£ã¦ã—ã¾ã„ãã†ãªã®ã§ã€ã“ã“ã§ã¯è€ƒãˆãªã„ã“ã¨
sugyan 2016/04/08
database
ãƒªãƒ³ã‚¯
Webã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£æ¦‚è«– - ã‚†ã†ã†ããƒ–ãƒã‚°
å…ˆæœˆæŠ•ç¨¿ã—ãŸ2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å¦ã¶é“ã®ã‚Šã¨ä»£è¡¨çš„ãªå®Ÿè£…ãƒ¢ãƒ‡ãƒ«ã®æ¦‚è¦ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ã€å‰å›žåŒæ§˜ã€ä¸»ã«æ–°å’Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒé–“ã®æŽ¥ç¶šç®¡ç†ãƒ¢ãƒ‡ãƒ«ã¨é‹ç”¨äº‹æƒ…ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã‚„ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ä½•ãªã®ã‹ã€ãªãœå¿…è¦ãªã®ã‹ã¨ã„ã£ãŸã“ã¨ãŒä¸»ãªè©±é¡Œã§ã™ã€‚ èƒŒæ™¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–ã¨ã¯ãªã«ã‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®ã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ°¸ç¶šåŒ–æ‰‹æ³• ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã¨ã¯ãªã«ã‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ‰ãƒ©ã‚¤ãƒåž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°: ãƒ—ãƒã‚ã‚·åž‹ ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°å…¨ä½“ã«ã¤ã„ã¦ PostgreSQLã¨MySQL å‚è€ƒè³‡æ–™ ã¾ã¨ã‚ èƒŒæ™¯ 2015å¹´Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£åºè«–ã§ã¯ã€Webã‚µãƒ¼ãƒã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®è©±ã¨Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§
sugyan 2015/07/06
web

database
ãƒªãƒ³ã‚¯
è«–ç†å‰Šé™¤ã¯ãªãœã€Œç‹ãŒæ‚ªã„ã€ã‹
ã€Œè«–ç†å‰Šé™¤ãŒäº‘ã€…ã«ã¤ã„ã¦ - mike-neckã®ãƒ–ãƒã‚°ã€ã‚’èªã‚“ã§ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«ãŠã„ã¦ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã®æ›¸ãæ›ãˆã‚’ã™ã‚‹ãªã€immutableãªãƒžã‚¹ã‚¿ã¨æ›´æ–°ãƒã‚°ã«ã‚ˆã£ã¦å…¨ã¦ã‚’æ§‹æˆã—ã‚ã€ã¨ã„ã†ã“ã®è¨˜äº‹ã®ä¸»å¼µã¯ãƒ¢ãƒ‡ãƒªãƒ³ã‚°è«–ã¨ã—ã¦å…¨ãæ£ã—ã„ã€‚ ã ãŒã€æ®‹å¿µãªã“ã¨ã«ã€ãƒ‡ã‚£ã‚¹ã‚¯ã‚„ãƒ¡ãƒ¢ãƒªãŒè²´é‡ãªè³‡æºã ã£ãŸæ™‚ä»£ã®æŠ€è¡“ã§ã‚ã‚‹RDBã¯ã€ãã®ã‚ˆã†ãªãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã«åŸºã¥ã„ã¦è¨è¨ˆã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯å¿…ãšã—ã‚‚é©ã—ã¦ã„ãªã„ã€‚ ç¬¬ä¸€ã®å•é¡Œã¯ã€RDBã«å¯¾ã—ã¦ãªã•ã‚Œã‚‹æ§˜ã€…ãªã€Œæ›´æ–°ã€ï¼ˆãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ï¼‰ã¯ä¸å®šå½¢ï¼ˆã©ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã©ã®ã‚ˆã†ã«ä¿®æ£ã™ã‚‹ã‹ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä¾å˜ï¼‰ã ã¨ã„ã†ç‚¹ã€‚ä¸å®šå½¢ãªã€Œæ›´æ–°ã€ã‚’æ™‚ç³»åˆ—ã«ãã£ã¦RDBã«è¨˜éŒ²ã—ã¦ã„ãã®ã¯ã€è¨è¨ˆã¨ä¸¦èµ°æ€§ã®ç‚¹ã«ãŠã„ã¦å›°é›£ã‚ã‚‹ã„ã¯ç…©é›‘ãªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒå¿…è¦ã«ãªã‚‹ï¼ˆã¨ã„ã†ã‹ã€ãã®ã‚ˆã†ãªã€Œã‚¤ãƒ™ãƒ³ãƒˆã€ã«ã‚ˆã‚‹ã€Œå¤‰åŒ–ã€ã¯REDOãƒã‚°ã«æ›¸ãã€ãã®æ›´æ–°ã•ã‚ŒãŸã€ŒçŠ¶æ…‹ã€ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã«åæ˜ ã—ã¦ã„ãã¨ã„ã†ã®ãŒ
sugyan 2015/03/26
database
ãƒªãƒ³ã‚¯
ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒãªã‹ã£ãŸã‚‰INSERTã—ã¦è¿”ã™ã¿ãŸã„ãªã®ã‚’ç¢ºå®Ÿã«ã‚„ã‚‹ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…
find_or_createçš„ãªã‚„ã¤ã¯å¤§ä½“ã©ã‚“ãªORMã§ã‚‚ ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŽ¢ã™ ç„¡ã‹ã£ãŸã‚‰INSERT ã¿ãŸã„ã«å®Ÿè£…ã™ã‚‹ã“ã¨ã«ãªã‚‹ã¨æ€ã†ã€‚ãŸã ã“ã‚Œã ã¨ã€1ã¨2ã®é–“ã§ãƒ¬ãƒ¼ã‚¹ã‚³ãƒ³ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã§ã‚¨ãƒ©ãƒ¼èµ·ãã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚ä»–ã®ãƒ—ãƒã‚»ã‚¹ãŒINSERTã—ã¦ã—ã¾ã†ã¨ã‹ãã†ã„ã†ã‚„ã¤ã€‚ ãã‚Œã‚’é˜²ãŽãŸã„å ´åˆã«ã€1ã®æ™‚ç‚¹ã§FOR UPDATEã™ã‚‹ã®ã¯ã™ã”ããƒ€ãƒ¡ã§ã€ç©ºè¡Œã«FOR UPDATEã—ãŸã‚Šã™ã‚‹ã¨MySQLã ã¨ç››å¤§ã«ä¹™ã‚‹ã®ã¯æœ‰åãªè©±ã€‚ ã‚¨ãƒ©ãƒ¼ã‚’èµ·ã“ã•ãªã„ã§ã€ç¢ºå®Ÿã«ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–ã‚ŠãŸã„å ´åˆã«ã¯ã©ã†ã™ã‚Œã°ã‚ˆã„ã‹ã¨ã„ã†ã¨ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã™ã‚‹ã®ãŒè‰¯ã„ã¨æ€ã£ã¦ã„ã‚‹ã€‚UNIQUEã‚ãƒ¼åˆ¶ç´„ãªã‚ŠãŒã¡ã‚ƒã‚“ã¨ä»˜ã„ã¦ã„ã‚‹å‰æã€‚ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã¯Tengã®å ´åˆã€‚ sub find_or_create_surely { my ($self, $table, $where, $opt) = @_; my $row; my $txn = $self-
sugyan 2014/03/04
database

perl
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®masterã¨slaveã®ä½¿ã„åˆ†ã‘ã®è©±ã€‚2014å¹´ç‰ˆ - Hateburo: kazeburo hatenablog
ç¤¾å†…ã§å°‘ã—è©±é¡Œã«ãªã£ãŸã®ã§ã€‚ é‹ç”¨ä¸Šã®è©±ã¯fujiwaraã•ã‚“ã® MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº— MySQLã§å‚ç…§ã®è² è·åˆ†æ•£ã‚’è¡Œã†slaveã¯3å°ã‹ã‚‰æ§‹æˆã™ã‚‹ã®ãŒã‚ˆã„ã®ã§ã¯ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº— ã‚’ã¿ã¦ãã ã•ã„ã€‚ æœ€è¿‘ã€æ–°ã—ãã‚µãƒ¼ãƒ“ã‚¹ãŒã§ããŸã‚Šã€æ–°è¦æ©Ÿèƒ½ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¿½åŠ ã™ã‚‹éš›ã«ã¯å¿…ãšå…¨ã¦ã®å‚ç…§ã‚’masterã«å‘ã‘ã¦ã‚‚ã‚‰ã£ã¦ã„ã¾ã™ã€‚ç†ç”±ã¯ä¸Šè¨˜ã®ã‚¨ãƒ³ãƒˆãƒªã‚’èªã‚“ã§ãã ã•ã„ã€‚ã“ã®ã‚ˆã†ãªæ§‹æˆãŒå–ã‚Œã‚‹ã®ã¯ã‚‚ã¡ã‚ã‚“æ€§èƒ½çš„ã«ãã‚Œã§å•é¡Œãªã„ã‹ã‚‰ã§ã™ã€‚ æ–°ã—ã„ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã«ã€è¨å®šã•ã‚ŒãŸMySQLã€å•é¡Œã®ãªã„ã‚ˆã†ã«æ›¸ã‹ã‚ŒãŸSQLã§ã‚ã‚Œã°ã€æ•°åƒQPSã¯ä½™è£•ã«ã€ã¾ãŸå°‘ã—é ‘å¼µã‚Œã°æ•°ä¸‡QPSã‚’ä¸€å°ã§è³„ãˆã¾ã™ã€‚ãªã®ã§å¤§ä½“ã®ã‚µãƒ¼ãƒ“ã‚¹ã¯masterä¸€å°ã§ååˆ†ã§ã™ã€‚ ã•ã‚‰ã«ã“ã®è€ƒãˆæ–¹ã‚’é€²ã‚ã¦ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸ã§ sub d
sugyan 2013/11/27
webapp

database
ãƒªãƒ³ã‚¯
UnQLite - An Embeddable NoSQL Database Engine
UnQLite is a in-process software library which implements a self-contained, serverless, zero-configuration, transactional NoSQL database engine. UnQLite is a document store database similar to Mongo DB, Redis, CouchDB etc. as well a standard Key/Value store similar to BerkeleyDB, LevelDB, etc. UnQLite is an embedded NoSQL (Key/Value store and Document-store) database engine. Unlike most other NoSQL
sugyan 2013/07/04
"An Embeddable NoSQL Database Engine"

database

UnQLite
ãƒªãƒ³ã‚¯
#5ã€ŒGitDDLã¾ã˜ã‚¤ãƒŽãƒ™ãƒ¼ãƒ†ã‚£ãƒ–ã€ tech.kayac.com Advent Calendar 2012 - KAYAC Engineers' Blog
å¥½ããª IPA ã¯å¿—è³€é«˜åŽŸãƒ“ãƒ¼ãƒ«ã® @soh335 ã§ã™ã€‚ æ—©ããƒ“ãƒ¼ãƒ«é£²ã¿ãŸã„ã®ã§ã™ãŒæ›¸ã‹ãªã„ã¨æ€’ã‚‰ã‚Œã‚‹ã®ã§ä»Šæ—¥ã¯ã€éš£ã®ç™ºæ˜Žå®¶ãŒä½œã£ãŸ GitDDL ã¨ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ãã€‚ ï¼ˆéš£ã®ç™ºæ˜Žå®¶ã«ä»»ã›ã‚‹ã¨ã€ŒGitDDLã¾ã˜ã‚¤ãƒŽãƒ™ãƒ¼ãƒ†ã‚£ãƒ–ï¼ˆå®Œï¼‰ã€ã¨ã—ã‹èª¬æ˜Žã—ã¦ãã‚Œãªã„ã®ã§ï¼‰ ãªã«ã™ã‚‹ã‚‚ã®ãªã® åå‰ã‚’è¦‹ã¦é€šã‚Šã€Git ã§ database ã® schema ç®¡ç†ã‚’ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ãã‚Œä»¥å‰ã¯ã€DBIx::Class::Schema::Versioned ã¨ã‹ã‚’ä½¿ã£ã¦ã„ãŸã‚ˆã†ã§ã™ã€‚ ä»•çµ„ã¿ ã¾ãšã€Git ã§ç®¡ç†ã•ã‚Œã¦ã„ã‚‹ schema ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡ã—ç¤ºã™ã‚³ãƒŸãƒƒãƒˆã®ãƒãƒƒã‚·ãƒ¥ã‚’ database ä¸Šã§ç®¡ç†ã—ã¾ã™ã€‚ schema ã«å¤‰æ›´ãŒã‚ã£ãŸå ´åˆã€ã“ã®ã‚³ãƒŸãƒƒãƒˆã®ãƒãƒƒã‚·ãƒ¥ãŒ databse ä¸Šã®ã‚‚ã®ã¨ã§å·®ç•°ãŒç”Ÿã¾ã‚Œã¾ã™ã€‚ã‚ˆã£ã¦ database ä¸Šã® schema ã¯æœŸå¾…ã™ã‚‹ schema ã§ã¯ãª
sugyan 2012/12/06
SQL::Translator::Diffã§å·®åˆ†æŠ½å‡ºã€ã‹

kayac

adventcalendar

database
ãƒªãƒ³ã‚¯
Clojureã®ä½œè€…ãŒä½œã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹DatomicãŒå‡„ã„
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžClojureã®ä½œè€…Rich Hickeyæ°çŽ‡ã„ã‚‹Clojure Hackerã®ãƒãƒ¼ãƒ ãŒDatomic(ãƒ‡ãƒ¼ãƒˆãƒŸãƒƒã‚¯ã¨ç™ºéŸ³ã™ã‚‹ã‚‰ã—ã„)ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ã“ã‚ŒãŒä½•ã‚„ã‚‰ã¨ã¦ã¤ã‚‚ãªã„ã§ã™ã€‚10å¹´å…ˆã‚’è¡Œã£ã¦ã‚‹æŠ€è¡“ã˜ã‚ƒãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ã¾ã æœ¬ç•ªã‚µãƒ¼ãƒ“ã‚¹ã¯å§‹ã¾ã£ã¦ã„ã¾ã›ã‚“ãŒé–‹ç™ºç’°å¢ƒç”¨ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒé…å¸ƒã•ã‚Œã¦ã„ã¾ã™ã€‚ Datomicã¯æ–¬æ–°ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãªã®ã§ä¸€è¨€ã§èª¬æ˜Žã™ã‚‹ã®ã¯ã¨ã¦ã‚‚é›£ã—ã„ã§ã™ã€‚ ç§ãŒç†è§£ã§ããŸã“ã¨ã‚’ç°¡å˜ã«èª¬æ˜Žã—ã¾ã™ã€‚ 2014/1/20è¿½è¨˜ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãƒ¢ãƒ‡ãƒ«ã€ã‚µãƒãƒ¼ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã§ã¯ãªãç‹¬ç«‹ã—ã¦ä½¿ç”¨ã™ã‚‹å½¢ã«ãªã‚‹ãªã©è¨˜äº‹ä½œæˆæ™‚ã®å†…å®¹ã‹ã‚‰è‰²ã€…å¤‰æ›´ãŒåˆã£ãŸéƒ¨åˆ†ã‚’æ›´æ–°ã—ã¾ã—ãŸã€‚ å¤‰æ›´ä¸å¯ãªAppend-onlyãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ å¾“æ¥ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€ã‚ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ã¨ã„ã†ã®ã¯ãã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾å¿œã—ãŸå ´æ‰€ãŒã‚ã‚Šã€ãã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãæ›ãˆã‚‹ã¨ã„ã†ã“
sugyan 2012/03/09
ãŠã‚‚ã—ã‚ãã†ï¼

database

webservice
ãƒªãƒ³ã‚¯
1