[B! MySQL] fjwr38ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

fjwr38 id:fjwr38

MySQLã«é–¢ã™ã‚‹fjwr38ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (43)

${{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ã€ã‚’è¶…ãˆãŸï¼ï¼Ÿ | ã‚½ãƒ•ãƒˆã‚¢ãƒ³ãƒ†ãƒŠ
Database Friendsã¨ã„ã†ã‚µã‚¤ãƒˆãŒRDBMS (ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹)ã®äººæ°—æŠ•ç¥¨ã‚’è¡Œã£ãŸã¨ã“ã‚ã€ã€ŒPostgreSQLã€ãŒã€ŒMySQLã€ã«åœ§å€’çš„ãªå·®ã‚’ã¤ã‘ã¦äººæ°—ãƒŠãƒ³ãƒãƒ¼ãƒ¯ãƒ³ã¨ãªã‚Šè©±é¡Œã¨ãªã£ã¦ã„ã¾ã™(Hacker Newsã€Reddit)ã€‚ ã“ã®äººæ°—æŠ•ç¥¨ã¯ã€ŒWhat is your favorite RDBMS?"ã€(ã‚ãªãŸã®å¥½ããªRDBMSã¯?)ã¨ã„ã†ãŠé¡Œã®ã‚‚ã¨ã§è¡Œã‚ã‚Œã€900ä»¥ä¸Šã®å›žç”ãŒã‚ã£ãŸã‚ˆã†ã§ã™ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹è°è«–ãŒåˆ¥ã‚Œã‚‹Mongo DBã¸ã®ç¥¨ã¯é™¤å¤–ã•ã‚ŒãŸã¨ã®æ³¨æ„æ›¸ãã‚‚ã‚ã‚Šã¾ã™ã€‚ PostgreSQLãŒ41.6%ã‚‚ã®ç¥¨ã‚’é›†ã‚ãŸã“ã¨ã«é–¢ã—ã€OracleãŒMySQLã‚’è²·åŽã—ãŸã“ã¨ãŒå½±éŸ¿ã—ãŸã®ã§ã¯ï¼Ÿã¨ã‹ã€å¥½ã¿ã¨å®Ÿéš›ã®ã‚·ã‚§ã‚¢ã¯é•ã†ã®ã§ã¯ï¼Ÿã¨ã„ã£ãŸåˆ†æžãŒè¡Œã‚ã‚Œã¦ã„ã¦ã€å®Ÿéš›MySQLã®ã»ã†ãŒãƒãƒ”ãƒ¥ãƒ©ãƒ¼ã§ã‚ã‚‹ã¨ã„ã†èª¿æŸ»çµæžœã‚‚ã‚ã‚Šã¾ã™(èª¿æŸ»1ã€èª¿æŸ»2ã€Stackov
fjwr38 2014/10/24
postgresql

MySQL
ãƒªãƒ³ã‚¯
MariaDB - Wikipedia
The LAMP software bundle (here additionally with Squid). A high performance and high-availability solution for a hostile environment MariaDBã¯ã€MySQLæ´¾ç”Ÿã¨ã—ã¦é–‹ç™ºã•ã‚Œã¦ã„ã‚‹ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ (RDBMS) ã§ã‚ã‚‹ã€‚ MariaDBã®é–‹ç™ºã¯ã€MySQLã®ã‚ªãƒªã‚¸ãƒŠãƒ«ã‚³ãƒ¼ãƒ‰ã®ä½œè€…ã§MySQL ABã®å‰µè¨è€…ã§ã‚‚ã‚ã‚‹ãƒŸã‚«ã‚¨ãƒ«ãƒ»ã‚¦ã‚£ãƒ‡ãƒ‹ã‚¦ã‚¹ã«ã‚ˆã‚Šã€ç¾åœ¨ã‚ªãƒ©ã‚¯ãƒ«ã«ã‚ˆã£ã¦æ‰€æœ‰ã•ã‚Œã¦ã„ã‚‹MySQLã‚’ãƒ•ã‚©ãƒ¼ã‚¯ã—ã¦ç«‹ã¡ä¸Šã’ã‚‰ã‚ŒãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã‚ˆã‚Šè¡Œã‚ã‚Œã¦ã„ã‚‹[6]ã€‚é…å¸ƒãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯ã€GNU General Public Licenseã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³2[5]ã€‚MariaDBã®åã¯ã€ã‚¦ã‚£ãƒ‡ãƒ‹ã‚¦ã‚¹ã®2ç•ªç›®ã®å¨˜ã®åå‰ã‹ã‚‰æŽ¡ã‚‰ã‚Œã¦ã„ã‚‹[7]ã€‚ ãƒãƒ¼ã‚¸
fjwr38 2014/06/20
mariadb

mysql
ãƒªãƒ³ã‚¯
MySQL with Node.js
I've just started getting into Node.js. I come from a PHP background, so I'm fairly used to using MySQL for all my database needs. How can I use MySQL with Node.js?
fjwr38 2014/04/21
MySQL

node
ãƒªãƒ³ã‚¯
Ruby on Rails on MySQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å…¥é–€
Rails 3 ç³»+MySQL ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹å‘ã‘ã« 1. ã©ã®ã‚ˆã†ã«ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’æŽ¢ã™ã®ã‹ 2. ã©ã®ã‚ˆã†ãªè¨è¨ˆã‚’è¡Œãˆã°ã„ã„ã®ã‹ 3. Railsä¸Šã§ã©ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã‘ã°ã„ã„ã®ã‹ ã®3ç‚¹ã«çµžã£ã¦ã“ã®ãƒ—ãƒ¬ã‚¼ãƒ³ã‚’ã¿ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œãˆã‚‹ã‚ˆã†ã«è³‡æ–™ä½œæˆã‚’è¡Œã„ã¾ã—ãŸRead less
fjwr38 2014/02/26
Ruby on Rails

ActiveRecord

mysql
ãƒªãƒ³ã‚¯
ç¬¬3å›želasticsearchå‹‰å¼·ä¼šã§ãƒˆãƒ¼ã‚¯ã—ã¾ã—ãŸ #elasticsearchjp - Y-Ken Studio
2014å¹´2æœˆ7æ—¥ã«ãƒªã‚¯ãƒ«ãƒ¼ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚ºã§é–‹å‚¬ã•ã‚ŒãŸã€Œç¬¬3å›ž ElasticSearchå‹‰å¼·ä¼šã€ã§ãƒˆãƒ¼ã‚¯ã—ã¦ãã¾ã—ãŸï¼å‰å›žã®çš†æ§˜ã®ç™ºè¡¨ã¯Kibanaã«é–¢ã™ã‚‹æƒ…å ±ãŒãƒ¡ã‚¤ãƒ³ã§ã—ãŸãŒã€ä»Šå›žã¯æ¤œç´¢æŠ€è¡“ä¸å¿ƒã®ã‚¬ãƒãªå†…å®¹ã§ã¨ã¦ã‚‚æ¥½ã—ã‹ã£ãŸã§ã™ã€‚ æ‡‡è¦ªä¼šã§ã¯ä»Šå›žç™ºè¡¨ã—ãŸYamabikoã®ã‚³ã‚¢éƒ¨åˆ†ã§ã‚ã‚‹ fluent-plugin-mysql-replicator ã‚’å®Ÿéš›ã«åˆ©ç”¨ã—ã¦ã„ã‚‹æ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã‚‹ãªã©ã€æ„Ÿè¬æ„Ÿæ¿€é›¨ã‚ã‚‰ã‚Œã§ã—ãŸï¼ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ ãã®ä»–ã«ã‚‚2ç¤¾åˆåŒã§åˆåŒå‹‰å¼·ä¼šã‚’é–‹å‚¬ã—ã‚ˆã†ã¨ã„ã£ãŸãŠè©±ã‚’é ‚ã‘ã‚‹ãªã©ã€å®Ÿã‚Šã®ã‚ã‚‹æ™‚é–“ã‚’éŽã”ã›ã¾ã—ãŸã€‚ ç™ºè¡¨ãƒ†ãƒ¼ãƒž ä»Šå›žã¯ã€ŒMySQLãƒ¦ãƒ¼ã‚¶è¦–ç‚¹ã§ã®å°ã•ãå§‹ã‚ã‚‹Elasticsearchã€ã¨ã„ã†ç™ºè¡¨ã§ã™ã€‚ ãƒã‚°ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ©ã‚¤ã‚ºã‚¢ãƒ—ãƒªã§ã‚ã‚‹Kibanaã‚’é€šã˜ã¦Elasticsearchã«è§¦ã‚Œã‚‹æ–¹ã‚‚å°‘ãªã‹ã‚‰ãšãŠã‚Šã€ä¸–é–“ã§ã¯Kibanaã¨ã‚»ãƒƒãƒˆã§ä½¿ã†ç‰©ã§ã‚ã‚‹ã‚ˆã†ãª
fjwr38 2014/02/19
MySQL

elasticsearch
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒã‚™ãƒ¼æœªçµŒé¨“è€…ã‹ã‚™ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚±ã‚™ãƒ¼ãƒ ã‚’é€šã—ã¦çŸ¥ã£ãŸã‚µãƒ¼ãƒã‚™ãƒ¼ã®äº‹
23. ä¾‹ãˆã°ã“ã‚“ãªã‚³ãƒ¼ãƒ‰ 2011âˆ¼ # Â ã“ã®ä¸ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã¨ã„ã†ä»®å®š try: # Â ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã®ä½“â¼’åŠ›ï¦Šã‚’æ¶ˆè²» player.consume_Ì²vitality() # Â ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã®çµŒé¨“å€¤ã‚¢ãƒƒãƒ— player.add_Ì²experience() except: # Â ã‚¨ãƒ©ãƒ¼èµ·ããŸã‚‰DBã‚’ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ transaction.rollback() else: # Â å•é¡Œãªã‘ã‚Œã°DBæ›´ï¤æ–°ã€‚çµŒé¨“å€¤ãŒå¢—ãˆã‚‹ã€‚ transaction.commit() ä½“åŠ›â†’KVS çµŒé¨“å€¤â†’DB â€»å®Ÿéš›ã®ã‚³ãƒ¼ãƒ‰ã¨ã¯ç•°ãªã‚Šã¾ã™ 24. ä¾‹ãˆã°ã“ã‚“ãªã‚³ãƒ¼ãƒ‰ 2011âˆ¼ # Â ã“ã®ä¸ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã¨ã„ã†ä»®å®š try: # Â ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã®ä½“â¼’åŠ›ï¦Šã‚’æ¶ˆè²» player.consume_Ì²vitality() # Â ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã®çµŒé¨“å€¤ã‚¢ãƒƒãƒ— player.add_Ì²experience() excep
fjwr38 2014/02/10
gumi

MySQL
ãƒªãƒ³ã‚¯
æ—¥ä»˜åž‹ã¨æ™‚åˆ»åž‹(DATE, TIME, DATETIME, TIMESTAMP, YEAR)
MySQL ã§åˆ©ç”¨å¯èƒ½ãªãƒ‡ãƒ¼ã‚¿åž‹ã®ä¸ã§æ—¥ä»˜åž‹ã¨æ™‚åˆ»åž‹(DATE, TIME, DATETIME, TIMESTAMP, YEAR)ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ DATE æ—¥ä»˜ '1000-01-01' ã‹ã‚‰ '9999-12-31' ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ ï¼š 'YYYY-MM-DD' DATETIME[(fsp)] æ—¥ä»˜ã¨æ™‚é–“ã®çµ„ã¿åˆã‚ã› '1000-01-01 00:00:00.000000' ã‹ã‚‰ '9999-12-31 23:59:59.999999' ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ ï¼š 'YYYY-MM-DD HH:MM:SS[.fraction]' TIMESTAMP[(fsp)] ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ— TIMESTAMP å€¤ã¯ã€ã‚¨ãƒãƒƒã‚¯ ('1970-01-01 00:00:00' UTC) ã‹ã‚‰ã®ç§’æ•° '1970-01-01 00:00:01.000000' UTC ã‹ã‚‰ '2038-01-19 03:14
fjwr38 2014/02/07
MySQL

datetime
ãƒªãƒ³ã‚¯
DropboxãŒ2æ—¥ä»¥ä¸Šãƒ€ã‚¦ãƒ³ã€‚åŽŸå› ã¯ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ç”¨ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®ãƒŸã‚¹
ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒ“ã‚¹ã®DropboxãŒã€ç±³å›½æ™‚é–“1æœˆ10æ—¥ã®åˆå¾Œã‹ã‚‰ç´„2æ—¥é–“ã«ã‚ãŸã£ã¦éšœå®³ã‚’å¼•ãèµ·ã“ã—ã¦ã„ã¾ã—ãŸã€‚ç›´æŽ¥ã®åŽŸå› ã¯ã€OSã‚’ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã™ã‚‹ãŸã‚ã«å®Ÿè¡Œã—ãŸãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ç”¨ã‚¹ã‚¯ãƒªãƒ—ãƒˆã«ãƒã‚°ãŒã‚ã£ãŸã“ã¨ã§ã™ã€‚ éšœå®³ã®çŠ¶æ³ã‚’æ™‚ç³»åˆ—ã§è¿½ã„ã¤ã¤ã€åŽŸå› ã«ã¤ã„ã¦ã®å ±å‘Šã‚’è¦‹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ç´„48æ™‚é–“ç¶šã„ãŸå¾©æ—§ä½œæ¥ éšœå®³ã®çŠ¶æ³å ±å‘Šã«ã¤ã„ã¦ã¯ã€Dropbox Tech Blogã®ã€ŒDropbox Status Updateã€ã§ã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ãƒã‚¤ãƒ³ãƒˆã”ã¨ã«å¼•ç”¨ã—ã€è¨³ã—ã¾ã—ãŸã€‚ éšœå®³ç™ºç”ŸãŒèªè˜ã•ã‚ŒãŸã®ã¯ã€ç±³å¤ªå¹³æ´‹æ™‚é–“ã®åˆå¾Œ6æ™‚40åˆ†ã§ã™ã€‚å¾Œã«ãªã£ã¦åˆ†ã‹ã‚‹ã®ã§ã™ãŒã€ã“ã®æ—¥ã®5æ™‚åŠã«éšœå®³ã®åŽŸå› ã¨ãªã£ãŸãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãŒå§‹ã¾ã£ã¦ã„ã¾ã™ã€‚ãã‚Œã‹ã‚‰1æ™‚é–“å¾Œã«Dropboxã®ãƒ€ã‚¦ãƒ³ãŒç™ºè¦šã—ã¾ã™ã€‚ 1/10 at 6:40pm PT: We are aware that the Dropbox site
fjwr38 2014/01/14
dropbox

MySQL
ãƒªãƒ³ã‚¯
Amazon.co.jp: MySQLã«ã‚ˆã‚‹ã‚¿ãƒ•ãªã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹: ä½è—¤çœŸäºº, æ¡‘é‡Žç« å¼˜, å²¡ç”°é”å…¸, å¤§é»’åœç¥: æœ¬
fjwr38 2014/01/08
ã„ã„ã»ã‚“ã‚‰ã—ã„

MySQL

database
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã®ç¾…é‡ç›¤
PostgreSQLã®ãƒãƒ¼ãƒ«ç®¡ç†ã¨ãã®æ³¨æ„ç‚¹ï¼ˆOpen Source Conference 2022 Online/Osaka ç™ºè¡¨è³‡æ–™ï¼‰NTT DATA Techno logy & Innovation
fjwr38 2013/11/16
MySQL

postgresql
ãƒªãƒ³ã‚¯
Linuxç³»ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢3å¹´ç›®ã®ã‚¹ã‚ãƒ«ã‚’è¦‹æŠœã50ã®è³ªå•ï¼ˆãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã®å ´åˆï¼‰
æ•°å¹´å‰ã«ãªã‚“ã¨ãªãé¢ç™½ãŒã£ã¦æ›¸ã„ã¦ãŸã€ŒLinuxç³»ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢3å¹´ç›®ã®ã‚¹ã‚ãƒ«ã‚’è¦‹æŠœã50ã®è³ªå•ï¼ˆãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã®å ´åˆï¼‰ã€ã¨ã„ã†ã®ãŒã€æ˜”ã®è³‡æ–™ã‚’ã‚ã•ã£ã¦ã‚‹ã¨å‡ºã¦ãã¦ã€æ„å¤–ã¨é¢ç™½ã‹ã£ãŸã®ã§å°‘ã—ã ã‘æ‰‹ã‚’åŠ ãˆã¦ï¼ˆå¤ã„æƒ…å ±ã¨ã‹ã‚ã£ãŸã®ã§ï¼‰å…¬é–‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ æ„å¤–ã¨ãƒªã‚¢ãƒ«ãªã‚‚ã®ãŒã‚ã£ã¦æ‡ã‹ã—ã„æ°—åˆ†ã«ãªã‚Šã¾ã—ãŸã€‚éŽåŽ»ã«æ›¸ã„ãŸä»¥ä¸‹ã®è¨˜äº‹ã‚‚ã©ã†ãžå‚è€ƒã«ã—ã¦ä¸‹ã•ã„ã€‚ ã€ŒLinux ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ç›®æŒ‡ã—ã¦å…¥ç¤¾ä¸€å¹´ç›®ã«ã‚„ã£ã¦å½¹ã«ãŸã£ãŸã¨æ€ã†äº‹ã€ ã€ŒLinux ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’è¾žã‚ã¦å¤§å¦é™¢ã«å…¥å¦ã—ã¾ã—ãŸã€ è¿½è¨˜ï¼š è¨å•1ãŒã‚ã¾ã‚Šã«ã‚ˆããªã„ã®ã§ã€@tagomorisã•ã‚“ã®ã‚¢ãƒ‰ãƒã‚¤ã‚¹ã‚’é ‚ãã¤ã¤å¤‰æ›´ã—ã¾ã—ãŸã€‚1ã‚’æ¶ˆã—ã¦3ã‚’è¿½åŠ ã—ã¦ã„ã¾ã™ã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ 2000å°ä»¥ä¸Šã®ã‚µãƒ¼ãƒãƒ¼é‹ç”¨çµŒé¨“ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ ã‚µãƒ¼ãƒã‚„ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æ©Ÿå™¨ã®ã‚ãƒƒãƒ†ã‚£ãƒ³ã‚°çµŒé¨“ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ ã‚µãƒ¼ãƒã‚„ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æ©Ÿå™¨ã®äº¤æ›ã‚’ç¾åœ°ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼è·å“¡ã«
fjwr38 2013/11/14
MySQL

linux
ãƒªãƒ³ã‚¯
SQLã‚’çŸ¥ã‚‰ãªã„åã©ã‚‚ãŸã¡ - komagataã®ãƒ–ãƒã‚°
ã€ŒSQL? ã‚ªãƒ¯ã‚³ãƒ³ï½—ï½—ï½— ArelãŒå…¨éƒ¨ã‚«ãƒãƒ¼ã—ã¦ã‚‹ã‹ã‚‰ã„ã‚‰ãªã„ã§ã—ã‚‡ãƒ¼ m9(^Ð”^)ã€ ã¨@hrysdé”ã®ä¸–ä»£ã«è¨€ã‚ã‚Œã¦ã‚‹æ°—ãŒã™ã‚‹è¢«å®³å¦„æƒ³æ°—å‘³ã®æˆ‘ã€…ãŠã£ã•ã‚“ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã™ã€‚ æœ€è¿‘ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ³ã®æ–¹ã€…ã‚‚æ€–è©±ã«ã‚³ãƒŸãƒƒãƒˆã‚’ã©ã‚“ã©ã‚“ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¦ä¸–ä»£é–“ã®æ–çµ¶ã‚’è‹¥å¹²æ„Ÿã˜ã¦ã¾ã™ã€‚ ãã‚Œã¾ã§æ°—ã«ã—ãŸã“ã¨ãªã‹ã£ãŸã‚“ã§ã™ãŒåƒ•ã‚„@kjirouãªã©ã®ãŠã£ã•ã‚“ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã¯ORMã‚’ä½¿ã£ã¦ã„ã¦ã‚‚ã€æ—¥ä»˜é–¢ä¿‚ã®å‡¦ç†ã¨ã‹ã€ã¡ã‚‡ã£ã¨ãƒžã‚¤ãƒŠãƒ¼ãªã‚«ãƒ©ãƒ åž‹ã¨ã‹ã€ç•°ç¨®ã®DBé–“ã§ã¯ä½¿ãˆãªã•ãã†ãªå‡¦ç†ã‚’ç„¡æ„è˜ã«é¿ã‘ã¦ã„ã¦ã€é¿ã‘ã¦ã„ã‚‹ã¨ã„ã†æ„è˜ã™ã‚‰ãªã‹ã£ãŸã‚“ã§rails ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã‚‚developmentã¯sqlite3ã€productionã¯mysqlã§ã‚‚å•é¡ŒãŒå‡ºã‚‹ã“ã¨ã¯ã»ã¨ã‚“ã©ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ ã—ã‹ã—ã€ãƒ‹ãƒ¥ãƒ¼ã‚¨ã‚¤ã‚¸é”ã¯sqlite3ã§ã—ã‹å‹•ã‹ãªã„å‡¦ç†ã‚’ãƒã‚·ãƒã‚·ãƒ—ãƒ«ãƒªã‚¯ã—ã¦ãã‚‹ã®ã§æ€–è©±ã®developmentã‚‚mysqlã«
fjwr38 2013/10/30
SQL

MySQL
ãƒªãƒ³ã‚¯
Sequel ã«ã¤ã„ã¦ (ãã®1) - tmtms ã®ãƒ¡ãƒ¢
æœ€è¿‘ Sequel ã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’è§¦ã£ã¦ã‚‹ã®ã§ç°¡å˜ã«ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ Sequel Sequel ã¯ Ruby ã®æ§‹æ–‡ã§ SQL ã‚¯ã‚¨ãƒªã‚’è¨˜è¿°ã™ã‚‹ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ SQL ã®æ–‡æ³•ãŒå«Œã„ãªè‡ªåˆ†ã«ã¯æŒã£ã¦æ¥ã„ã§ã™ã€‚ RDB æ¯Žã®å·®ç•°ã‚‚å¸åŽã—ã¦ãã‚Œã¾ã™ã€‚ è‡ªåˆ†ã¯ MySQL ã—ã‹çŸ¥ã‚‰ãªã„ã®ã§ã€ä»¥ä¸‹ã¯ MySQL ã§ã®ä¾‹ã§ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« % gem install sequel % gem install ruby-mysql æŽ¥ç¶š DB = Sequel.connect('mysql://user:password@hostname:port/dbname') # ã¾ãŸã¯ DB = Sequel.mysql('dbname', :host=>'hostname', :user=>'user', :password=>'password', :port=>'port') ä¸Šã®ä¾‹ã§ã¯å®š
fjwr38 2013/10/28
MySQL

Ruby
ãƒªãƒ³ã‚¯
FacebookãŒä½•åƒå°ã‚‚ã®MySQLã‚’äººæ‰‹ã‚’ä½¿ã‚ãšè‡ªå¾‹ç®¡ç†ã™ã‚‹ä»•çµ„ã¿ã€ŒMySQL Pool Scannerï¼ˆMPSï¼‰ã€
ãŠãã‚‰ãä¸–ç•Œã§ã‚‚ã£ã¨ã‚‚å¤§è¦æ¨¡ã«MySQLã®ã‚¯ãƒ©ã‚¹ã‚¿ã‚’å±•é–‹ã—ã€é‹ç”¨ã—ã¦ã„ã‚‹ã®ãŒFacebookã§ã—ã‚‡ã†ã€‚è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚Šä½•åƒå°ã‚‚ã®MySQLã‚µãƒ¼ãƒã‚’é‹ç”¨ã™ã‚‹ãŸã‚ã«ã€è‡ªå‹•åŒ–ã®ä»•çµ„ã¿ã¯æ¬ ã‹ã›ã¾ã›ã‚“ã€‚ ãã®è‡ªå‹•åŒ–ãŒã©ã®ã‚ˆã†ãªä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã®ã‹ã€‚Facebookã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹Shlomo Priymakæ°ãŒã€Under the hood: MySQL Pool Scanner (MPS)ã¨ã„ã†è¨˜äº‹ã‚’Facebookã§å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ ã‹ãªã‚Šé•·ã„è¨˜äº‹ãªã®ã§ã€ã“ã“ã§ã¯ãã®ãƒã‚¤ãƒ³ãƒˆã‚’ã¾ã¨ã‚ã¦è§£èª¬ã—ã¦ã¿ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²åŽŸæ–‡ã‚’ã‚ãŸã£ã¦ã¿ã¦ãã ã•ã„ã€‚ MPSã®ãŠã‚‚ãª3ã¤ã®æ©Ÿèƒ½ Facebookã§ç¨¼åƒã—ã¦ã„ã‚‹MySQLã¯ã€ã¤ãã«1ã¤ã®ãƒžã‚¹ã‚¿ãƒ¼ã¨ãã“ã‹ã‚‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã•ã‚ŒãŸè¤‡æ•°ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã‚ˆã‚‹ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã‚’æ§‹æˆã—ã¦ã„ã¾ã™ã€‚ã“ã®ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã®æ§‹é€ ã‚’ç¶æŒã—ç¶šã‘ã‚‹ã“ã¨ã§ã€å¯ç”¨æ€§ã¨
fjwr38 2013/10/28
MySQL
ãƒªãƒ³ã‚¯
SQLã«å¯¾ã™ã‚‹MySQLã¨ã€NoSQLã«å¯¾ã™ã‚‹MongoDBã¯ä¼¼ã¦ã„ã‚‹â€•â€•ä¸»ã«æœ‰å®³ãªæ„å‘³ã§ | Yakst
MySQLã®ã‚¸ãƒ§ã‚¤ãƒ³ãŒé…ã„ã“ã¨ã§SQLå…¨èˆ¬ã®ã‚¸ãƒ§ã‚¤ãƒ³ãŒé…ã„ã¨æ€ã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚‹ã‚ˆã†ã«ã€NoSQLã®ä¸ã§ã‚‚Mongo DBãŒæ¯”è¼ƒçš„åºƒãä½¿ã‚ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ããŸä»Šã€Mongo DBã®æ¬ ç‚¹ãŒNoSQLã®æ¬ ç‚¹ã ã¨å‹˜é•ã„ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¦ã„ã‚‹ã®ã§ã¯ãªã„ã‹ã€‚ã€ŒSQL Performance Explainedã€è‘—è€…Markus Winandæ°ã®æŒ‡æ‘˜ã€‚ æ˜¨æ—¥(9/30)ã®å¤•æ–¹ã€ç§ã¯ã€ŒSQLã«å¯¾ã™ã‚‹MySQLã®ã‚ˆã†ã«ã€NoSQLã«å¯¾ã™ã‚‹Mongo DBã«ã¯ã‚ˆããªã„é¢ãŒã‚ã‚‹ã€ã¨ãƒ„ã‚¤ãƒ¼ãƒˆã‚’ã—ãŸã€‚ã‚ã„ã«ããã®ãƒ„ã‚¤ãƒ¼ãƒˆã«ã¯èª¬æ˜ŽãŒæ¬ ã‘ã¦ã„ãŸã€‚ã¨ã¯ã„ãˆ1ã¤ã®ãƒ„ã‚¤ãƒ¼ãƒˆã«å…¨ã¦ã®å¿…è¦ãªèª¬æ˜Žã‚’å«ã‚€ã“ã¨ã¯ã§ããªã„ã ã‚ã†ã‹ã‚‰ã€ã“ã®è¨˜äº‹ã§èª¬æ˜Žã—ã‚ˆã†ã€‚ãƒ„ã‚¤ãƒ¼ãƒˆã¸ã®è¿”äº‹ã¨ã—ã¦å—ã‘å–ã£ãŸã„ãã¤ã‹ã®ç–‘å•ã«ç”ãˆã‚‰ã‚Œã‚Œã°ã¨æ€ã†ã€‚ ã¾ãšæœ€åˆã«ã€ç§ã¯å¤šè¨€èªžæ°¸ç¶šåŒ–ã®è€ƒãˆæ–¹ã«è³›åŒã¯ã™ã‚‹ãŒã€NoSQLã®ç†±ç‹‚çš„æ”¯æŒè€…ã§ã¯ãªã„ã¨ã„ã†ã“ã¨ã‚’çŸ¥ã£ã¦ãŠã„ã¦ã»ã—ã„ã€‚
fjwr38 2013/10/17
MySQL

SQL
ãƒªãƒ³ã‚¯
Facebookã«ãŠã‘ã‚‹MySQLã‚’ç”¨ã„ãŸå¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®ç¾å®Ÿï½žMySQL Connect 2013
ç±³ã‚ªãƒ©ã‚¯ãƒ«ãŒä¸»å‚¬ã™ã‚‹MySQLã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒMySQL Connectã€ãŒ9æœˆ21æ—¥ã‹ã‚‰23æ—¥ã¾ã§ã€ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã§é–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚Oracle OpenWorldã€JavaOneã¨ã®åŒæ™‚é–‹å‚¬ã§ã—ãŸã€‚ åŸºèª¿è¬›æ¼”ã®1ã¤ã«ã¯ã€MySQLã®ãƒ˜ãƒ“ãƒ¼ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚ã‚‹Facebookã®Harrison Fiskæ°ãŒç™»å£‡ã€‚Facebookã«ãŠã‘ã‚‹MySQLã®å½¹å‰²ã€å¤§è¦æ¨¡é‹ç”¨ã®èƒŒæ™¯ãªã©ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ãã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ MySQL@Facebook Lots and lots of small data Harrison Fiskæ°ã€‚ Facebookã§ãƒ‡ãƒ¼ã‚¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¼ãƒ ã®ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚’ã—ã¦ã„ã‚‹ã€‚ç¤¾å†…ã§ã¯MySQLã¯ã‚‚ã¡ã‚ã‚“ã€HBase Hadoopãªã©ã«ã‚‚é–¢ã‚ã£ã¦ã„ã‚‹ã€‚ ã¾ãšã¯ã€ã©ã‚“ãªç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã£ã¦ã„ã‚‹ã®ã‹ã«ã¤ã„ã¦ã€‚ Facebookã¨ã¯åŸºæœ¬çš„ã«ã‚°ãƒ©ãƒ•ã ã€‚ã‚°
fjwr38 2013/09/27
MySQL

facebook
ãƒªãƒ³ã‚¯
ã„ã¾ã©ãã®ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢é€£é–‹ç™º
profile id: Songmu (ã‚½ãƒ³ãƒ ãƒ¼) Masayuki Matsuki http://www.songmu.jp/riji/ https://metacpan.org/author/SONGMU ã‚«ãƒ¤ãƒƒã‚¯æŠ€è¡“éƒ¨ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ äº‹æ¥éƒ¨ äºŒå¹´åŠã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ æ¼¬ã‘ ä»Šå¹´æ–°ãŸã«ä¸Šã’ãŸCPANãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« Riji Puncheur DBIx::Schema::DSL Cache::Redis Config::PL Redis::LeaderBoard DBIx::FixtureLoader SQL::Maker::Plugin::JoinSelect Teng::Plugin::SearchJoined Git::Repository::FileHistory GitDDL::Migrator UnazuSan Plack::Middleware::Woothee Plack::Mi
fjwr38 2013/09/20
MySQL

redis
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
fjwr38 2013/09/20
MySQL

mariadb
ãƒªãƒ³ã‚¯
Google swaps out MySQL, moves to MariaDB
'They're moving it all,' says MariaDB Foundation headman Updated Google is migrating its MySQL systems over to MariaDB, allowing the search company to get away from the Oracle-backed open source database. The news came out at the Extremely Large Databases (XLDB) conference in Stanford, California on Wednesday, one month after El Reg reported that Google had assigned one of its engineers to the Mar
fjwr38 2013/09/13
MySQL
ãƒªãƒ³ã‚¯
MySQL Indexå‹‰å¼·ä¼šå¤–éƒ¨å…¬é–‹ç”¨
12. Â© CROOZ,Inc. 12 ï¼‘ï¼ŽINDEXã¨ã¯ãªã«ã‹ ä½•æžšç›®ãŒãªã«ã‹ã‚’äº‹å‰ã«ãƒ¡ãƒ¢ã£ã¦ãŠã‘ã°è‰¯ã„ï¼ ã‚¹ãƒ¼ãƒˆ ãƒ©ãƒ³ã‚¯ ä½ç½® ãƒãƒ¼ãƒˆ Q 1 ã‚¹ãƒšãƒ¼ãƒ‰ 9 2 : : : ãƒ€ã‚¤ãƒ¤ 1 40 : : : ã‚¹ãƒšãƒ¼ãƒ‰ 6 45 ãªãœãªã‚‰ã€è¦æ±‚ã¯ã€Œã‚«ãƒ¼ãƒ‰ã‚’å¼•ãå›žæ•°ã‚’æœ€ã‚‚å°‘ãªã ã—ã¦ã‚¹ãƒšãƒ¼ãƒ‰6ã‚’æŽ¢ã™ã“ã¨ã€ ã‚»ã‚³ã„ã¨ã‹ãŠã‚‚ã†ãƒ’ãƒˆã¯ã„ã‚‹ã‹ ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒä½•ã‚‚ã‚»ã‚³ã„ã“ ã¯ã—ã¦ã„ãªã„ã§ã™ã€‚ å‰ææ¡ä»¶ãªã©ä¸€åˆ‡ãªã„ã‹ã‚‰ ã“ã®ãƒ¡ãƒ¢ã•ãˆã‚ã‚Œã°ä½ç½®ã‚’æŒ‡å®šã—ã¦1å›žå¼•ã‘ã°æ¸ˆã‚€
fjwr38 2013/09/12
MySQL

index
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸