[B! db] cos31ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

cos31 id:cos31

dbã«é–¢ã™ã‚‹cos31ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

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

DB KPIå–å¾—ã®ã‚¹ã‚¹ãƒ¡ - ç‹ãƒˆãƒ¬ã¨ã¨ã‚‚ã«ç”Ÿãã‚‹DBAã®é›‘è¨˜
ã¾ãšãã‚‚ãã‚‚KPIã£ã¦ãªã‚“ã‚„ãã‚“ã€ã¨ã€‚ Key Performance Indicator æ¥ç¸¾ç®¡ç†è©•ä¾¡ã®ãŸã‚ã®é‡è¦ãªæŒ‡æ¨™ KPIã¨ã¯ã€Key Performance Indicatorã€‘ï¼ˆé‡è¦æ¥ç¸¾è©•ä¾¡æŒ‡æ¨™ï¼‰ - æ„å‘³/è§£èª¬/èª¬æ˜Ž/å®šç¾© ï¼š ITç”¨èªžè¾žå…¸ ç”¨èªžçš„ãªæ„å‘³ã¯ã“ã‚“ãªã¨ã“ã§ã™ãŒã€ã“ã“ã§ã¯ã–ã£ãã‚Šã€ŒDBæ€§èƒ½è©•ä¾¡æŒ‡æ¨™ã€ã¨è€ƒãˆã¦ãã ã•ã„ã€‚ ã†ã¡ã®ä¼šç¤¾ã§ã¯å®šå¸¸çš„ã«MySQLã‹ã‚‰æƒ…å ±ã‚’å¸ã„ã‚ã’ã¦ã€ã“ã‚Œã‚’è“„ç©ã—ã¤ã¤æ€§èƒ½ç®¡ç†ã«å½¹ç«‹ã¦ã¦ã„ã¾ã™ã€‚ ã“ã‚Œã‚’DB KPIç®¡ç†ãªã‚“ã¦å‘¼ã‚“ã§ã„ã¾ã™ã€‚ è‘—ä½œæ¨©ãŒæ€ªã—ã„ã®ã§ã‚½ãƒ¼ã‚¹ã‚’è¼‰ã›ã‚‹ã®ã¯æŽ§ãˆã¾ã™ãŒã€å»¶ã€…ã¨show statusã®60ç§’é–“ã®å¹³å‡ã‚’å–ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’daemontoolsã§å›žã—ç¶šã‘ã¦ã„ã¾ã™ã€‚ å–å¾—å¯¾è±¡ã¯Com_[insert|delete|update|select]ã€Innodb_rows_% (ã†ã¡ã¯InnoDBã°ã‹ã‚Šãªã®ã§) ã‚ãŸã‚Šã§ã™ã€‚ ç´¯ç©
cos31 2013/03/15
db

analysis
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
6. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 8. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 3 honda xxx FALSE
cos31 2011/08/11
DB

è«–ç†å‰Šé™¤
ãƒªãƒ³ã‚¯
ER Master
<body> <span>ã“ã®ãƒšãƒ¼ã‚¸ã¯ãƒ•ãƒ¬ãƒ¼ãƒ å¯¾å¿œã®ãƒ–ãƒ©ã‚¦ã‚¶ã§ã”è¦§ãã ã•ã„ã€‚</span> </body>
cos31 2009/08/13
eclipse

db

er
ãƒªãƒ³ã‚¯
KOF 2008 ã®ç™ºè¡¨è³‡æ–™ - naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
KOF 2008 ã§ã®ç™ºè¡¨è³‡æ–™ã€Œã¯ã¦ãªæµå¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã€ã‚’ä»¥ä¸‹ã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¾ã—ãŸã€‚ http://bloghackers.net/~naoya/ppt/081108huge_data.ppt ä¸€éƒ¨å‚è€ƒæ–‡çŒ®ã‹ã‚‰ã®å¼•ç”¨ (Introduction to Information Retrieval ã‹ã‚‰ Vector space model ã®å›³ã€ãŸã¤ã‚’ã® ChangeLog ã‹ã‚‰è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å›³) ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®å ´ã‚’å€Ÿã‚Šã¦æ„Ÿè¬ã€‚ ç’°å¢ƒã«ã‚ˆã£ã¦ã¯ãŠãã‚‰ããƒ•ã‚©ãƒ³ãƒˆã®è¡¨ç¤ºãŒã„ã¾ã„ã¡ã ã¨æ€ã„ã¾ã™ãŒã€ã”äº†æ‰¿ãã ã•ã„ã€‚ è¿½è¨˜ SlideShare ã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¾ã—ãŸã€‚ 081108huge_data.pptView SlideShare presentation or Upload your own. (tags: linux mysql) è¿½è¨˜: ãƒ¡ãƒ¢ãƒªã¯ãƒ‡ã‚£ã‚¹ã‚¯ã® 150 å€ã«ã¤ã„ã¦
cos31 2008/11/13
hatena

db

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
MySQL/PostgreSQLï¼‹Sennaã§è¡Œã†ãƒ©ã‚¯ãƒ©ã‚¯å…¨æ–‡æ¤œç´¢â€¦â€¦Tritonnï¼†Ludiaå°Žå…¥ã®ãƒã‚¤ãƒ³ãƒˆ | gihyo.jp
Tritonnã€Ludiaã€ãã—ã¦Sennaã¨ã¯â€¦â€¦ æ˜¨ä»Šã®Web 2.0ã¨å‘¼ã°ã‚Œã‚‹ã‚ˆã†ãªWebã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã€ä¸€èˆ¬çš„ã«å¤§é‡ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ãƒ‡ãƒ¼ã‚¿ã‚’å†…éƒ¨ã«ä¿æœ‰ã—ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚å¤§é‡ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‹ã‚‰ç›®çš„ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’ãƒ¦ãƒ¼ã‚¶ãŒé¸ã³å–ã‚‹æ‰‹æ®µã®ä¸€ã¤ã¨ã—ã¦å…¨æ–‡æ¤œç´¢ãŒæŒ™ã’ã‚‰ã‚Œã¾ã™ã€‚å…¨æ–‡æ¤œç´¢ã¨ã¯ã€æ¤œç´¢å¯¾è±¡ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã®ä¸èº«ã™ã¹ã¦ã«å¯¾ã—ã¦æ¤œç´¢ã‚’è¡Œã†ã“ã¨ã‚’æŒ‡ã—ã¾ã™ã€‚ãŸã¨ãˆã°ã€ã‚¿ã‚°ã‚„ã‚¿ã‚¤ãƒˆãƒ«ã‚’å¯¾è±¡ã«ã—ãŸæ¤œç´¢ã ã‘ã§ã¯ã€ç›®çš„ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’ç™ºè¦‹ã§ããªã„ã‚ˆã†ãªå ´åˆã«æœ‰åŠ¹ãªæ¤œç´¢ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿æŒã•ã‚ŒãŸå¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç°¡å˜ã«å…¨æ–‡æ¤œç´¢ã—ãŸã„ã€ã¨ã„ã†å ´åˆã‚‚å¤šã„ã“ã¨ã§ã—ã‚‡ã†ã€‚æœ¬ç¨¿ã§ã¯ã€ãã‚Œã‚’å®Ÿç¾ã«ã™ã‚‹å…¨æ–‡æ¤œç´¢ã‚·ã‚¹ãƒ†ãƒ ã¨ã—ã¦ã€æ¬¡ã®2ã¤ã‚’å–ã‚Šä¸Šã’ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ Tritonn Ludia ã“ã‚Œã‚‰ã¯ãã‚Œãžã‚Œã€Tritonnã¯ã€ŒMySQLâ ã€â ã€Ludiaã¯ã€ŒPostgreSQLã€ã¨ã„ã†ã€Webã‚·ã‚¹ãƒ†ãƒ ã‚’é–‹ç™ºã™ã‚‹ä¸Šã§äººæ°—ã®é«˜
cos31 2007/12/25
senna

å…¨æ–‡æ¤œç´¢

æ¤œç´¢

mysql

postgresql

db
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘PostgreSQLã®é«˜é€ŸåŒ–ã¨é«˜ä¿¡é ¼åŒ–ã‚’å®Ÿç¾ã™ã‚‹ã€Œpgpool-IIã€ã‚’ä½¿ã£ã¦ã¿ã‚‹ (1) pgpool-IIã®æ¦‚è¦ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
pgpool-IIã®æ¦‚è¦ ã€Œpgpool-IIã€ã¨ã¯ã€PostgreSQLã®é«˜é€ŸåŒ–ã¨é«˜ä¿¡é ¼åŒ–ã‚’ç›®çš„ã¨ã—ãŸãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§ã‚ã‚‹ã€‚pgpool-IIã¯ã€ä¸‹å›³ã®ã‚ˆã†ã«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨PostgreSQLã®é–“ã«å…¥ã‚‹å½¢(ãƒ—ãƒã‚ã‚·å½¢å¼)ã§å‹•ä½œã™ã‚‹ã€‚ãªãŠã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¯PostgreSQLã‚µãƒ¼ãƒã¸æŽ¥ç¶šã™ã‚‹ã®ã§ã¯ãªãã€pgpool-IIã¸æŽ¥ç¶šã™ã‚‹ã“ã¨ã«ãªã‚‹ã€‚ pgpool-IIã¯ç¾åœ¨ã€pgpool Development Groupã«ã‚ˆã‚Šé–‹ç™ºãŒç¶™ç¶šã•ã‚Œã¦ã„ã‚‹ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«ã¯ä¿®æ£BSDãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã‚’æŽ¡ç”¨ã—ã¦ãŠã‚Šã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã®ã§è‡ªç”±ã«åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯http://pgfoundry.org/projects/pgpoolã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ãªãŠã€2007å¹´10æœˆ1æ—¥ç¾åœ¨ã®pgpool-IIã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯1.2.1ã§ã‚ã‚‹ã€‚ pgpool-IIã¯ã•ã¾ã–
cos31 2007/11/08
ãªã‚“ã ã‹ã‚“ã ä½¿ã£ãŸã“ã¨ãªã„ã®ã§ã€ä½¿ã£ã¦è¦‹ãŸã„ãªã

postgresql

db
ãƒªãƒ³ã‚¯
_ [Rails] ã¨ã‚Šã‚ãˆãšDBåˆ†å‰²ã™ã‚‹ã ã‘ãªã‚‰é©šãã»ã©ç°¡å˜ã ã£ãŸä»¶ - Don'tStopMusic(2007-10-31)
_ [Ruby] Ruby ã®æ–°ãƒã‚´ Ruby Associationã¯2007å¹´10æœˆ29æ—¥ã€Rubyå…¬å¼ãƒã‚´é¸å®šã‚³ãƒ³ãƒ†ã‚¹ãƒˆã€ŒRubyãƒã‚´ã‚³ãƒ³ãƒ†ã‚¹ãƒˆã€ã®çµæžœã‚’ç™ºè¡¨ã—ãŸã€‚Rubyã®å…¬å¼ãƒã‚´ã«ã¯Tom Schaubæ°ã®ä½œå“ãŒæŽ¡ç”¨ã•ã‚ŒãŸã€‚ Rubyã®å…¬å¼ãƒã‚´æ±ºå®š! | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ« å…¬å¼ãƒã‚´ãŒæ±ºå®šã—ã¾ã—ãŸã€‚ãŠãªã˜ã¿ã®ãƒ«ãƒ“ãƒ¼ã‚’ä½¿ã£ã¦ã„ã‚‹ã›ã„ã‹ã€ãã‚“ãªã«ä»£ã‚ã‚Šæ˜ ãˆã—ãªã„ã‚ˆã†ãªã€‚ ã¾ã¤ã‚‚ã¨ã•ã‚“ãŒ [ruby-list:44161]Rubyå…¬å¼ãƒã‚´ã‚³ãƒ³ãƒ†ã‚¹ãƒˆçµæžœç™ºè¡¨ ã§é¸è€ƒåŸºæº–ã‚’è¿°ã¹ã¦ã„ã¾ã™ãŒã€ãã‚Œãžã‚Œã†ãªãšã‘ã‚‹ç†ç”±ã§ã™ã€‚ èˆˆå‘³æ·±ã„ã¨æ€ã£ãŸã®ãŒã€ã€Žã€Œã‹ã‚ã„ã„ã€ã‚‚ã®ã¯é™¤ãã€ã¨ã„ã†é …ã€‚ã€Œã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã€ã¨ã„ã†è¨€è‘‰ã‚‚å›ã‹ã‚Œå§‹ã‚ã¦ã„ã‚‹ä»Šæ—¥ã“ã®é ƒã€Rubyã‚‚ãã‚ãã‚å¤§äººã¨ã—ã¦æ‰±ã‚ã‚Œã‚‹ã‚ˆã†ã«ã¨ã„ã†è¦ªå¿ƒãªã®ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãã€‚ _ [Ruby] ç¬¬äºŒå›žRubyèªå®šè©¦é¨“ã‚’å—ã‘ã‚‹äºˆå®š ç ”
cos31 2007/11/01
seasarï¼’ã«ã‚‚ã“ã‚“ãªã®ãªã„ã‹ãªãï½ž

ruby

ruby on rails

db
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘PHPç‰ˆRuby on Rails? - DBæ“ä½œã‚¯ãƒ©ã‚¹ã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹"PHP Object Generator" | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
PHPã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚ã‚‹PHP Object Generatorã®æœ€æ–°ç‰ˆã€ŒPHP Object Generator ï¼ˆä»¥ä¸‹ã€POGï¼‰3.0ã€ãŒ26æ—¥ï¼ˆç±³å›½æ™‚é–“ï¼‰ã€å…¬é–‹ã•ã‚ŒãŸã€‚PHPã§é–‹ç™ºã•ã‚ŒãŸWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã€The BSD Licenseã®ã‚‚ã¨ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã€‚POGã§ã¯ã€ã‚¯ãƒ©ã‚¹åã¨ã‚¢ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ãƒˆã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã§åŒãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®PHPã‚¯ãƒ©ã‚¹ãŒç”Ÿæˆã•ã‚Œã‚‹ä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã€‚PHP4/PHP5ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§å‹•ä½œã™ã‚‹ã‚³ãƒ¼ãƒ‰ãŒç”Ÿæˆã•ã‚Œã‚‹ã€‚ å¯¾è±¡ã¨ã™ã‚‹PHPã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã€ã‚¯ãƒ©ã‚¹åã€æ“ä½œã™ã‚‹ã‚¢ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ãƒˆã‚’æŒ‡å®šã—ã¦æ“ä½œã™ã‚‹ã‚³ãƒ¼ãƒ‰ã‚’è‡ªå‹•çš„ã«ç”Ÿæˆã•ã›ã‚‹ POGã¯ã‚‚ã¨ã‚‚ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚³ãƒ¼ãƒ‰ã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹ã“ã¨ã§é–‹ç™ºæ™‚é–“ã‚’å‰Šæ¸›ã™ã‚‹ã“ã¨ã‚’ç›®çš„ã¨ã—ã¦é–‹ç™ºã•ã‚ŒãŸã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®ã‚³ãƒ¼ãƒ‰ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã”ã¨ã«ç•°ãªã‚‹ãŒã€çµå±€ä¼¼ãŸ
cos31 2007/07/31
é–‹ç™º

pog

php

library

db
ãƒªãƒ³ã‚¯
MOONGIFT: Â» Railsã§DBç®¡ç†ã€ŒRailsMyAdminã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
Railsã§é–‹ç™ºã‚’è¡Œã†éš›ã«DBã¯å¿…é ˆã ã‚ã†ã€‚ç°¡æ˜“çš„ãªã‚‚ã®ã§ã‚ã‚Œã°SQLiteã§è‰¯ã„ãŒã€ã“ã‚Œã¾ã§ã®çµŒé¨“ã§ã¯å¤§æŠµMySQLãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ DBç®¡ç†ã«ã¯phpMyAdminã‚„ã€GUIã®DBç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã—ã¦ããŸãŒã€Railsä¸Šã§ä¸€æ‹¬ç®¡ç†ã§ãã‚‹ã“ã¡ã‚‰ãŒä¾¿åˆ©ãã†ã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯RailsMyAdminã€Railsä¸Šã®DBç®¡ç†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ RailsMyAdminã§ã¯Railsã§ã®DBè¨å®šã‚’åˆ©ç”¨ã™ã‚‹ã®ã§è¨å®šã‚‚æ‰‹é–“ã‚‚ãªãç°¡å˜ã«åˆ©ç”¨ã§ãã‚‹ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦ç°¡å˜ã«ã§ãã€environment.rbã«è¨å®šã‚’æ›¸ãåŠ ãˆã‚‹ã ã‘ã§ã„ã„ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã‚„ãƒ‡ãƒ¼ã‚¿ã®ä¸€è¦§è¡¨ç¤ºã€è¿½åŠ ã€ç·¨é›†ã¯ã‚‚ã¡ã‚ã‚“å¯èƒ½ã ã€‚ã¾ãŸã€created_at/updated_atã¨ã„ã£ãŸRailsç‰¹æœ‰ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã¯å€¤ã‚’å…¥ã‚Œã‚‰ã‚Œãªã„ã®ã‚‚ä¾¿åˆ©ã ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã®å¤‰æ›´ã¯ã‚‚ã¡ã‚ã‚“ä¸å¯ã§ã€migration
cos31 2007/07/19
database

mysql

db

rails

ruby

ruby on rails

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
ãƒ—ãƒãŒä½œã£ãŸé»’çŒ«å°ã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ (å¼•ã£è¶Šã—ã¾ã—ãŸ)
â– æœ€æ–°æƒ…å ± é»’çŒ«ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢å·¥æˆ¿ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯å¼•ã£è¶Šã—ã¾ã—ãŸã€‚ æ–°ã—ã„ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯ã“ã¡ã‚‰ â†’ http://kuronekosoft.ewinds.net/ 5ç§’å¾Œã«è‡ªå‹•çš„ã«ã‚¸ãƒ£ãƒ³ãƒ—ã—ã¾ã™ã€‚ é»’çŒ« SQLÂ Studio ã¯ã€ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šå¯èƒ½ãªæ±Žç”¨SQLé–‹ç™ºç’°å¢ƒã§ã™ã€‚é»’çŒ« SQLÂ Studio ã«ã¯ã€SQLã‚’æ‰‹æ—©ãä½œã‚‹ãŸã‚ã®å…¥åŠ›æ”¯æ´æ©Ÿèƒ½ã‚„ã€ä½œã£ãŸSQLã‚’ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦ç®¡ç†ã™ã‚‹æ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ â– é»’çŒ« SQL StudioÂ ã«ã¤ã„ã¦çŸ¥ã‚ŠãŸã„ â†’ é»’çŒ« SQL Studio â– é»’çŒ« SQL StudioÂ ã‚’ç´¹ä»‹ã—ã¦ã„ãŸã ãã¾ã—ãŸ â†’ SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒ... - çª“ã®æœ â†’ ä½¿ã„ã‚„ã™ã„SQLå®Ÿè¡Œç’°å¢ƒ... - Unofficial DB2 BLOG â†’ ã©ã‚“ãªDBã‚‚GUIã§SQLä½œæˆ... - Hibiæ—¥è¨˜ â†’ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã®å¿…éœ€å“
cos31 2007/07/06
database

db

é–‹ç™º

ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
æ›´æ–°ãŒã‚ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã«ã¯InnoDBã‚’é¸ã¼ã†ã€‚MyISAMã‚’é¸æŠžã™ã‚‹ãªã‚‰ãã‚Œãªã‚Šã®ç†ç”±ãŒå¿…è¦ã€‚ãã‚Œã«InnoDBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯ãã‚“ãªã«æ‚ªããªã„ã‚ˆã€‚ || ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°Blog: ã‚¤ãƒ³ã‚¿ãƒ¼ã‚ªãƒ•
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
cos31 2007/07/02
MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ

performance

mysql

innodb

db
ãƒªãƒ³ã‚¯
MOONGIFT: Â» ãƒžã‚¹ã‚¿ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚’ä¸€æ°—ã«ä½œæˆã€ŒphpCodeGeneratorã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
DBã‚’ä½¿ã£ãŸé–‹ç™ºã§ã‚ã‚Œã°å¿…ãšå‡ºã¦ãã‚‹ã®ãŒãƒžã‚¹ã‚¿ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ç”»é¢ã ã€‚åŒã˜ã‚ˆã†ãªä½œã‚Šã§ã€æ¯Žåº¦ä½œã‚‹ã®ãŒé¢å€’ã«æ„Ÿã˜ã¦ã„ã‚‹äººã‚‚å¤šã„ã ã‚ã†ã€‚ã ãŒã€ãƒ¦ãƒ¼ã‚¶ã®ãŸã‚ã‚’è€ƒãˆã‚Œã°å¿…ãšå¿…è¦ãªã®ã‚‚ã‚ã‹ã£ã¦ã„ã‚‹ã¯ãšã ã€‚ ã›ã‚ã¦æ‰‹è»½ã«çµ‚ã‚ã‚‰ã›ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ã‚ˆã†ã€‚æ±ºã¾ã‚Šãã£ãŸã‚³ãƒ¼ãƒ‰ã¯è‡ªå‹•ç”Ÿæˆã—ã¦ã—ã¾ãˆã°è‰¯ã„ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯phpCodeGeneratorã€DBå®šç¾©ã«æ²¿ã£ã¦ã‚³ãƒ¼ãƒ‰ã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ phpCodeGeneratorã®ç‰¹å¾´ã¯ãªã‚“ã¨è¨€ã£ã¦ã‚‚å¯¾å¿œã—ã¦ã„ã‚‹DBã®å¤šã•ã ã€‚MySQLã€PostgreSQLã€Oracleã¨ã„ã£ãŸåŸºæœ¬çš„ãªã‚‚ã®ã¯ã‚‚ã¡ã‚ã‚“ã€Access/ODBC/SQLite/DB2/MS SQL Server/MaxDB/Visual FoxPro/FrontBase/InterBase 6/Borland Interbase 6.5/Firebird/Inform
cos31 2007/06/30
php

mysql

generator

db
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: MySQL5ã‹ã‚‰ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹çµåˆã§ï¼‘ãƒ†ãƒ¼ãƒ–ãƒ«è¤‡æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã†
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
cos31 2007/06/07
database

db

mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
WWW SQL Designer
What's new? 25.9.2008 Version 2.2 SQLite storage New datatypes New translations 18.7.2008 Version 2.1.1 Fixes in MySQL XSLT Minor improvements 28.6.2008 Version 2.1 New languages Dynamic window title "note" datatype attribute 1.4.2008 Version 2.0.1 Fixed AUTOINCREMENT for Foreign Keys Minimap visual aesthetic changes 28.3.2008 Version 2.0 ! Thanks to Mirko Buffoni for numerous consultations and su
cos31 2006/10/29
ajax

database

db

erå›³

php

mysql

javascript

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
PHPã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹5ã¤ã®å•é¡Œã€ã¨ãã®è§£æ±ºæ³• - GIGAZINE
IBMã®ã‚µã‚¤ãƒˆã«ã€PHPã‹ã‚‰æ“ä½œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã—ã¦ã‚ˆãè¦‹ã‚‰ã‚Œã‚‹5ã¤ã®å•é¡Œç‚¹ã¨ãã®è§£æ±ºæ–¹æ³•ãŒæŽ²è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ã‚¶ã‚¤ãƒ³ã‚’ã™ã‚‹éš›ã€ä¸€èˆ¬çš„ã«ç™ºç”Ÿã™ã‚‹å•é¡Œç‚¹ã«ã¤ã„ã¦ã®è§£èª¬ã§ã™ã€‚ ã§ã€è‚å¿ƒã®5ã¤ã®å•é¡ŒãŒä½•ã‹ã¨ã„ã†ã¨ã€ä»¥ä¸‹ã®é€šã‚Šã€‚ Five common PHP database probl ems 1ã¤ã‚ã¯å¤ã„PHPã®ã‚³ãƒ¼ãƒ‰ã§ã¯ç›´æŽ¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã€‚ã‚³ãƒ¬ã«ä»£ã‚ã‚‹æ‰‹æ®µã¨ã—ã¦ã¯ã€PEARã®DBãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã†ã‹ã€ã‚ã‚‹ã„ã¯PHPãƒ‡ãƒ¼ã‚¿ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€PDOã®ã‚¯ãƒ©ã‚¹ã‚’ä½¿ãˆã€ã¨ã‚ã‚Šã¾ã™ã€‚ 2ã¤ã‚ã¯ã€ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’ä½¿ã‚ãªã„ã¨ã„ã†ã“ã¨ã€‚MySQLã¯åŸºæœ¬çš„ã«ãƒ¬ã‚³ãƒ¼ãƒ‰1ã¤ã«ã¤ã„ã¦ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªIDã‚’ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã—ã¦ã„ã‚‹ã‚ã‘ã§ã™ãŒã€ã“ã‚Œã‚’æ´»ç”¨ã—ã¦ã„ãªã„ã¨ã„ã†ãƒ‘ã‚¿ãƒ¼ãƒ³ã€‚ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’æœ‰åŠ¹ã«ä½¿ã£ã¦ã„ãªã„å ´åˆã€éžåŠ¹çŽ‡çš„ã§ã‚ã‚‹ã ã‘ã§ãªãã€è² è·ã‚‚é«˜ããªã‚‹ãã†ã§ã™ã€‚è§£
cos31 2006/08/04
db

php

mysql

gigazine

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1