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

starcycle id:starcycle

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

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

MOONGIFT: Â» Railsã‚’ä½¿ã£ã¦DBæ§‹é€ ã‚’ç¢ºèªã™ã‚‹ã€ŒRails schema browser pluginã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
Railsã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã®ä¸€ã¤ãŒã€DBã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã ã‚ã†ã€‚RDBMSã¯ä¾¿åˆ©ãªåé¢ã€ãƒ—ãƒã‚°ãƒ©ãƒ è¨€èªžã¨æºãŒã‚ã‚Šã€æ‰±ã„ãŒé¢å€’ãªæ™‚ãŒã‚ã£ãŸã€‚ãã®ãŸã‚ã€O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ã®ã‚ˆã†ãªãƒ„ãƒ¼ãƒ«ãŒä½œã‚‰ã‚Œã€çŠ¶æ…‹ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã¨ã—ã¦ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒã¨ã¦ã‚‚ä¾¿åˆ©ã ã£ãŸã€‚ é–‹ç™ºã—ã¦ã„ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã®DBæ§‹é€ ãŒæ‰‹è»½ã«é–²è¦§ã§ãã‚‹ ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚ˆã£ã¦DBã®æ§‹é€ ã‚„ä¸èº«ã‚’ã‚ã¾ã‚Šæ„è˜ã›ãšã¨ã‚‚é–‹ç™ºãŒè¡Œãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã¯ã¨ã¦ã‚‚ä¾¿åˆ©ã ã€‚ã ãŒã€ãã®åé¢DBã®ãƒªã‚½ãƒ¼ã‚¹ã‚’éŽå‰°ã«ä½¿ã£ã¦ã—ã¾ã†ã€å¯Œè±ªçš„ãªã‚·ã‚¹ãƒ†ãƒ ã«ãªã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚æ™‚ã«ã¯ãã®æ§‹é€ ã‚’è¦‹è¿”ã™æ™‚ã‚‚å¿…è¦ã ã‚ã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Rails schema browser pluginã€DBæ§‹é€ å‡ºåŠ›ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ Rails schema browser pluginã¯Railsãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ãƒ‡ãƒ¼ã‚¿ã®è¡¨ç¤ºãªã©ã¯å…¨ã¦WW
starcycle 2008/07/24
rails

db

ã‚¹ã‚ãƒ¼ãƒž

æ§‹é€

ãƒ—ãƒ©ã‚°ã‚¤ãƒ³

todo
ãƒªãƒ³ã‚¯
MOONGIFT: >> Railsã«ãŠã‘ã‚‹MySQLã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’åˆ†æžã™ã‚‹ã€ŒPalmistã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
Railsã¯åº¦ã€…é…ã„ã¨ã„ã†ã“ã¨ãŒè©±é¡Œã«ä¸ŠãŒã‚‹ã€‚Rubyè‡ªä½“ã®æ€§èƒ½ã‚‚ã‚ã‚‹ã ã‚ã†ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¯Œè±ªçš„ã«ä½¿ã£ã¦ã„ã‚‹ã®ã«ã‚‚åŽŸå› ãŒã‚ã‚‹ã€‚ä¾¿åˆ©ã§ã‚ã‚‹ãŸã‚ã«ã¤ã„ã¤ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¤šç”¨ã—ã¦ã„ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ã®å–ã‚Šå‡ºã—ã‚’è¤‡é›‘ï¼ˆéƒ½åº¦é›†è¨ˆãªã©ï¼‰ã«ã—ã¦ã„ãªã„ã ã‚ã†ã‹ã€‚ ãƒ¡ã‚¤ãƒ³ç”»é¢ å€‹äººçš„ãªçµŒé¨“ã‹ã‚‰è¨€ãˆã°ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚ŠãŒã¡ãªã®ã¯ãƒ¬ãƒ³ãƒ€ãƒªãƒ³ã‚°ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã€‚ã“ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å•é¡Œç‚¹ã‚’æ´—ã„å‡ºã™ã®ã«ä¾¿åˆ©ãªã®ãŒã€ã¾ãŸã—ã¦ã‚‚Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã¯Palmistã€Railsã®MySQLå®Ÿè¡Œå±¥æ´ã‚’è¦‹ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ã‚½ãƒ¼ã‚¹ã¯Githubã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ãŒãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯æ˜Žè¨˜ã•ã‚Œã¦ã„ãªã‹ã£ãŸã®ã§æ³¨æ„ã—ã¦ã„ãŸã ããŸã„ã€‚ Palmistã¯ä»–ã®Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿å–ã£ã¦ã€ãã‚Œã‚’è§£æžã—ã¦è¡¨ç¤ºã—ã¦ãã‚Œã‚‹ã€‚ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ©ã€ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã€DBã¸ã®CRUDã”ã¨ã«ãƒªã‚¹ãƒˆã‚¢ãƒƒãƒ—ã—ã¦ãã‚Œã‚‹ã€‚å®Ÿ
starcycle 2008/06/06
rails

ãƒœãƒˆãƒ«ãƒãƒƒã‚¯

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ã¯ã•ã¾ã–
starcycle 2008/03/22
pgpool-II

db

postgresql
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬6å›žï¼šPostgreSQLã¨MySQLã®ç‰¹é•·ã¨ã¯ (1/3)
5å›žã«æ¸¡ã£ã¦è§£èª¬ã—ã¦ããŸæœ¬é€£è¼‰ã‚‚ä»Šå›žãŒæœ€çµ‚å›žã§ã™ã€‚ãã“ã§ä»Šå›žã¯ã€ä»Šã¾ã§ã®å†…å®¹ã‚’ã‚‚ã†1åº¦å¾©ç¿’ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãŸæœ€å¾Œã«éžå¸¸ã«ç°¡å˜ã§ã™ãŒã€MySQLã®å°†æ¥ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚
starcycle 2008/03/12
PostgreSQl

MySQL

db
ãƒªãƒ³ã‚¯
RailsMyAdminã€€ã‚’è©¦ã—ã¦ã¿ãŸ - yuumi3ã®ãŠä»•äº‹æ—¥è¨˜
MOONGIFTã§çŸ¥ã£ãŸ,RailsMyAdminã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ã€€ç¾åœ¨ã‚ã‚‹ä»•äº‹ã®ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ã‚’Railsã§ä½œã£ã¦ã„ã‚‹ã®ã§ã“ã®ã‚ˆã†ãªãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¯æœ¬å½“ã«åŠ©ã‹ã‚Šã¾ã™ã€€:-) RailsMyAdminã¯ http://www.moongift.jp/2007/07/railsmyadmin/ ã«ã‚ã‚‹ã‚ˆã†ã«ã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ä½¿ã£ã¦ã„ã‚‹å…¨ã¦ã€ã¾ãŸã¯æŒ‡å®šã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«å†…ã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒªã‚¹ãƒˆã€å¤‰æ›´ã€ä½œæˆã€å‰Šé™¤ãŒè¡Œãˆã¾ã™ï¼ˆãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ç”»é¢ã§ã™ãï¼‰ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ http://code.google.com/p/railsmyadmin/ ã«ã‚ã‚‹ã‚ˆã†ã« script/plugin install ã§ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã— script/generate my_admin ã§ RailsMyAdminã€€ä¸€å¼ã‚’ä½œæˆã—ã¾ã™ã€‚ è¨å®šã§ã™ãŒã€config/environment.rb ã«ä»¥ä¸‹ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’è¿½åŠ ã—ã¾
starcycle 2007/10/10
DB

RailsMyAdmin

RubyOnRails
ãƒªãƒ³ã‚¯
RailsMyAdmin
Railsã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ä¾¿åˆ©ãªã‚‚ã®ãŒMoonGiftã§ç´¹ä»‹ã•ã‚Œã¦ã„ãŸã®ã§ æ—©é€Ÿè©¦ã—ã¾ã—ãŸã€‚ ã€ŒRailsMyAdminã€ ï¼œæ©Ÿèƒ½ï¼ž phpMyAdminã¨åŒã˜ãã€Railsã‚¢ãƒ—ãƒªã§å‚ç…§ã•ã‚Œã¦ã„ã‚‹DBã‚’ ç›´æŽ¥æ“ä½œã™ã‚‹æ©Ÿèƒ½ãŒæä¾›ã•ã‚Œã¾ã™ã€‚ ï¼œå°Žå…¥æ‰‹é †ï¼ž RailsMyAdminã¯ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã™ã€‚ å°Žå…¥ã—ãŸã„ã‚¢ãƒ—ãƒªã§ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’æ‰“ã¡ã¾ã™ã€‚(Linuxã®å‰æï¼‰ ãƒ—ãƒã‚ã‚·ã‚µãƒ¼ãƒã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹å ´åˆã®ã¿ã€ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ å…¥åŠ›ã—ã¦ãã ã•ã„ã€‚ > set http_proxy=http://proxy.server.jp:8080> ruby script/plugin install http://railsmyadmin.googlecode.com/svn/trunk/my_admin/ > ruby script/generate my_admin æ¬¡ã«environment.rbã«ä»¥ä¸‹ã®ï¼“è¡Œ
starcycle 2007/10/10
RailsMyAdmin

DB

RubyOnRails
ãƒªãƒ³ã‚¯
WEB+DB PRESS ç·é›†ç·¨ [Vol.1~36]
starcycle 2007/07/21
DB

Web

ç·é›†ç·¨
ãƒªãƒ³ã‚¯
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
starcycle 2007/07/18
DB

RubyOnRails

MySQL
ãƒªãƒ³ã‚¯
1