[B! db] kei-sã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kei-s id:kei-s

dbã«é–¢ã™ã‚‹kei-sã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (28)

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

ã‚¤ãƒŸãƒ¥ãƒ¼ã‚¿ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«(å…¥é–€ç·¨)
6. Step1 ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã®æŠ½å‡º ç™ºé€æ‹…å½“è€…ãŒå—æ³¨ãƒªã‚¹ãƒˆã‚’ã‚‚ã¨ã«ã€å•†å“ã®åœ¨åº«ã‚’ç¢ºèªã—ã€åœ¨åº«ãŒ ã‚ã‚Œã°å•†å“ã‚’ç™ºé€ã™ã‚‹ã€‚ â‘ è¦æ±‚ä»•æ§˜ã®ã€Œå‹•è©žã€ã‚’æŠœãå‡ºã—ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã™ã‚‹ã€‚ â‘¡ â‘ ã«é–¢ã‚ã‚‹ã€Œåè©žã€ã‚’æŠœãå‡ºã—ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã™ã‚‹ã€‚ â‘¢ ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£é–“ã®é–¢é€£ã«ç·šã‚’å¼•ã â‘£ å±žæ€§ã‚„å€™è£œã‚ãƒ¼ã‚‚åˆ†ã‹ã‚‹ç¯„å›²ã§æ›¸ã„ã¦ãŠãã¾ã™ã€‚ é–“é•ã„ï¼ ã“ã®æ®µéšŽã§å®Ÿè£…ã‚’ãƒ—ãƒãƒ‘ãƒ†ã‚£ãƒ•ã‚¡ã‚¤ãƒ«ã«ã™ã‚‹ã¨ã‹ã€Enum ã«ã™ã‚‹ã¨ã‹æ±ºã‚æ‰“ã¡ã§ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã—ã¦è¡¨ã•ãªã„ã®ã¯ã‚„ ã‚ã¾ã—ã‚‡ã†ã€‚ ã¾ãšã€ã¯ã˜ã‚ã«ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’æŠ½å‡ºã—ã¾ã™ã€‚
kei-s 2014/11/13
db
ãƒªãƒ³ã‚¯
Amazon RDSã®ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ï¼‹Rails4.0ï¼‹multi_dbã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸ - ITã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ç”Ÿãã‚‹
Webã§è² è·åˆ†æ•£ã™ã‚‹å ´åˆã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ç°¡å˜ã«ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆå‡ºæ¥ã¾ã™ãŒã€DBï¼ˆãŒRDBMSã®å ´åˆï¼‰ã¯ï¼‘ã¤ã«é›†ç´„ã™ã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ ã—ã‹ã—ã“ã®æ§‹æˆã ã¨ã©ã†ã—ã¦ã‚‚DBãŒæ€§èƒ½é¢ã§ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚ŠãŒã¡ã§ã€ãã‚Œã‚’è§£æ¶ˆã™ã‚‹ï¼‘ã¤ã®ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã¨ã—ã¦Readã‚’ãƒ¬ãƒ—ãƒªã‚«ã¸åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ ä»Šå›žã¯ãã‚Œã‚’Amazon RDSã®ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ã¨multi_dbã¨ã„ã†gemã‚’ä½¿ã£ã¦è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ ã™ã§ã«DBã¯RDSï¼ˆMySQLï¼‰ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ãŒãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ã¯åˆ©ç”¨ã—ã¦ã„ãªã„ã€ã¨ã„ã†ã“ã¨ã‚’ã‚¹ã‚¿ãƒ¼ãƒˆåœ°ç‚¹ã¨ã—ã¦ã„ã¾ã™ã€‚ Amazon RDSã®ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«Amazon Web Services ãƒ–ãƒã‚°: Amazon RDSã®æ–°æ©Ÿèƒ½ï¼šRead Replica(ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«)ã®ç™ºè¡¨ ãƒªãƒ¼ãƒ‰ãƒ¬ãƒ—ãƒªã‚«ã¨ã¯ãã®åã®é€šã‚Šã€RDSã®èªå–ã‚Šå°‚ç”¨è¤‡è£½ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã§ã™ã€‚ RDSãƒžã‚¹ã‚¿ã‹ã‚‰å®š
kei-s 2014/01/15
rails

db

aws

rds
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
kei-s 2012/12/10
db

postgresql

javascript
ãƒªãƒ³ã‚¯
ç¬¬31å›žã€€Rubyistã®ãŸã‚ã®MongoDBå…¥é–€ï¼ˆ1ï¼‰ | gihyo.jp
ã¯ã˜ã‚ã« ã“ã“æœ€è¿‘ã€NoSQLã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ãŒæ³¨ç›®ã‚’é›†ã‚ã¦ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ä¸€èˆ¬çš„ã«ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆï¼ˆã‚µãƒ¼ãƒã®å°æ•°ã‚’å¢—ã‚„ã—ã¦æ€§èƒ½å‘ä¸Šã‚’å›³ã‚‹æ‰‹æ³•ï¼‰ãŒé›£ã—ãã€ç‰¹ã«å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã«ãŠã„ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä¸Šã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚Šãˆã¾ã™ã€‚ã¾ãŸã€ã‚¿ã‚°ã‚„ã‚°ãƒ©ãƒ•æ§‹é€ ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã¯é–¢ä¿‚ãƒ¢ãƒ‡ãƒ«ã«é¦´æŸ“ã¿ã«ãã„ãŸã‚ã€ãã‚Œã‚‰ã‚’æ‰±ã†éš›ã«ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚³ãƒ¼ãƒ‰ã‚‚ãŽã“ã¡ãªã„ã‚‚ã®ã«ãªã‚ŠãŒã¡ã§ã™ã€‚ ã“ã‚Œã‚‰ã®å•é¡Œã‚’èƒŒæ™¯ã«ã€ä½•ã«ã§ã‚‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†ã®ã§ã¯ãªãã€ç”¨é€”ã«å¿œã˜ã¦KVSãªã©ä»–ã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’é¸æŠžã™ã‚‹æµã‚ŒãŒåºƒã¾ã‚Šã¤ã¤ã‚ã‚Šã¾ã™ã€‚ã“ã®ãƒ ãƒ¼ãƒ–ãƒ¡ãƒ³ãƒˆãŒNoSQLï¼ˆNot Only SQLï¼‰ã¨å‘¼ã°ã‚Œã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚ ä»Šå›žã¯ã€NoSQLãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®1ã¤ã§ã‚ã‚‹Mongo DBã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ Mongo DBã¨ã¯ Mongo DBã¯é«˜ã„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’ç‰¹å¾´ã¨ã™ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘åž‹ãƒ‡ãƒ¼
kei-s 2010/02/15
db

mongodb

json
ãƒªãƒ³ã‚¯
DBMã«ã‚ˆã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - mixi engineer blog
æ£æœˆæ—©ã€…ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã«ã‹ã‹ã£ã¦å¯è¾¼ã‚“ã mikioã§ã™ã€‚é›»è»Šã«ä¹—ã‚‹æ™‚ã‚„ç¹è¯è¡—ãªã©ã«å‡ºã‚‹æ™‚ã¯ãƒžã‚¹ã‚¯ç€ç”¨ãŒå¿…é ˆã§ã™ãã€‚ã•ã¦ä»Šå›žã¯ã€Tokyo Cabinetã§å®Ÿè£…ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«æ–¹å¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚æ„å¤–ã«ã©ã†ã—ã¦å¼·åŠ›ãªæ©Ÿèƒ½ãªã®ã§ã€ã“ã®ãƒã‚¿ã¯é€£è¼‰ã™ã‚‹ã“ã¨ã‚’äºˆå‘Šã—ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ ç°¡å˜ã«è¨€ãˆã°ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ˆã†ã«ã€è¤‡æ•°ã®åˆ—ã‹ã‚‰ãªã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ ¼ç´ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚SQLã‚„è¡¨çµåˆãªã©ã®è¤‡é›‘ãªæ©Ÿèƒ½ã¯ã‚µãƒãƒ¼ãƒˆã—ã¾ã›ã‚“ãŒã€ãã®ã¶ã‚“é«˜é€Ÿã«å‹•ä½œã—ã¾ã™ã€‚ã¤ã¾ã‚Šã€DBMã®é€Ÿåº¦ã§å‹•ããƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«é¢¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ï¼ˆåŽ³å¯†ã«ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã‚ã‚Šã¾ã›ã‚“ï¼‰ã€‚ TCã®åŸºæœ¬ã¨ãªã‚‹ãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€å˜ç´”ãªkey/valueåž‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚Šã€ã¤ã¾ã‚Šã‚ãƒ¼ã«ã‚‚å€¤ã«ã‚‚ã‚¹ã‚«ãƒ©ï¼ˆæ•°å€¤ã‚„æ–‡å—åˆ—ãªã©ã®ç‰¹ã«æ§‹é€ ã‚’æŒãŸãªã„å˜ä¸€ã®å€¤ï¼‰ã—ã‹æ ¼ç´ã™ã‚‹ã“ã¨ã¯ã§ãã¾ã›ã‚“
kei-s 2009/01/19
tokyocabinet

mixi

db
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
kei-s 2009/01/05
mysql

db

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
kei-s 2008/09/18
couchdb

db

erlang

json
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
é¡”ã«è¦‹ãˆã‚‹ï¼Ÿæœ€è¿‘ã€Œé€æ°´å£ã€ãŒæ°—ã«ãªã‚‹ã¨ã„ã†è©± ã€Œé€æ°´å£ã€ãŒæ°—ã«ãªã‚‹ä»Šæ—¥ã“ã®é ƒ æœ€è¿‘è¡—ä¸ã§æ°—ã«ãªã‚‹å˜åœ¨ã€ãã‚ŒãŒã“ã®ã€Œé€æ°´å£ã€ã§ã™ã€‚åœ°ä¸Šã®ãƒ•ãƒã‚¢ãŒ7éšŽä»¥ä¸Šã‚ã‚‹ãƒ“ãƒ«ãªã©ã€ä¸€å®šã®æ¡ä»¶ã‚’æº€ãŸã—ãŸå»ºç¯‰ç‰©ã«ã¯è¨ç½®ãŒç¾©å‹™ä»˜ã‘ã‚‰ã‚Œã¦ã„ã‚‹ã‚‚ã®ã§ã€ç«äº‹ãŒç™ºç”Ÿã—ãŸãƒ•ãƒã‚¢ã«ãŸã ã¡ã«æ°´ã‚’é€ã‚‹ãŸã‚ã«ä½¿ã‚ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ãƒãƒ³ãƒ—è»Šâ€¦
kei-s 2008/05/02
ruby

rails

db

mysql
ãƒªãƒ³ã‚¯
has_many :through - Self-referential has_many :through associations
Update: This article is now superceded by a new version that is updated for Rails 2.0 changes. Here we go. Rick Olson helped me figure out how to do bi-directional, self-referential associations using has_many :through. It's not obvious (until you know the trick), so here's how it's done. This example is for modeling digraphs. create_table "nodes" do |t| t.column "name", :string t.column "capacity
kei-s 2007/10/31
rails

ruby

db

tips
ãƒªãƒ³ã‚¯
83's : Railsä»¥å¤–ã§Railsã®migrationã‚’ä½¿ã†
Railsä»¥å¤–ã§DBã®ãƒ†ãƒ¼ãƒ–ãƒ«ä½œã‚‹ã¨ãã«ã€ Railsã®migrationã§ãªã„ã¨æˆ‘æ…¢ã§ããªã„æ‚£è€…ã•ã‚“ã¯ã„ã¾ã™ã‹ã€‚ (;Â´Ð”`)ï¾‰ ãƒ¡ãƒ¢ã£ã¨ãã€‚ % rake migrate % rake migrate VERSION=0 ã¨ã‹ã—ãŸã„ã®ã§ã€Rakefileã‚’ä½œã‚‹ã€‚ # Rakefile require "rubygems" require "active_record" ActiveRecord::Base.establish_connection(...çœç•¥...) # ã‚»ãƒƒãƒˆã—ã¦ãªã„ã¨nil.infoã§è½ã¡ã‚‹ã‹ã‚‰æ³¨æ„ require 'logger' ActiveRecord::Base.logger = Logger.new(STDOUT) task :migrate do ActiveRecord::Migrator.migrate('db/migrate', ENV["VERS
kei-s 2007/10/29
rails

db

ruby
ãƒªãƒ³ã‚¯
ActiveRecord ã‚’ç´ ã§ä½¿ã†ãƒ†ãƒ³ãƒ—ãƒ¬ - ãƒ‰ãƒ¬ãƒƒã‚·ãƒ³ã‚°ã®ã‚ˆã†ãª
æ¬¡ã®ã‚ˆã†ã«ã™ã‚‹ã“ã¨ã§ï¼ŒActive Record ã‚’ç´ ã§ä½¿ã†ã“ã¨ãŒå‡ºæ¥ã¾ã™ï¼ŽRuby on Rails ãŒè£å´ã§ã‚„ã£ã¦ãã‚Œã¦ã„ã‚‹ã“ã¨ã‚’è‡ªåˆ†ã§ã‚„ã‚‹ã ã‘ã§ã™ï¼Ž # Active Record ã‚’ gem ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸãªã‚‰ rubygems ã‚’ require ã™ã‚‹ require 'rubygems' require 'active_record' # æœ€å¾Œã®ã»ã†ã§ pp ã‚’ä½¿ã†ã‹ã‚‰ require ã—ã¦ãŠã require 'pp' # æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¯ UTF-8 $KCODE = 'u' # ActiveRecord ã®åˆæœŸåŒ– / ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶š ActiveRecord::Base.establish_connection( :adapter => 'mysql', :username => 'muraken', :password => File.read('passw
kei-s 2007/10/11
db

rails

ruby
ãƒªãƒ³ã‚¯
SQL Injection Cheat Sheet
Examples; (MS) means : MySQL and SQL Server etc. (M*S) means : Only in some versions of MySQL or special conditions see related note and SQL Server Table Of Contents About SQL Injection Cheat Sheet Syntax Reference, Sample Attacks and Dirty SQL Injection Tricks Line Comments SQL Injection Attack Samples Inline Comments Classical Inline Comment SQL Injection Attack Samples MySQL Vers
kei-s 2007/03/22
db

sql

security

tips
ãƒªãƒ³ã‚¯
Installing PostgreSQL 8 for Windows
PostgreSQL 8 Windowsç‰ˆã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³• PostgreSQLã¯ï¼Œã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã®æ©Ÿèƒ½ã‚’ä¸€éƒ¨å–ã‚Šå…¥ã‚ŒãŸæ‹¡å¼µåž‹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³8ã‹ã‚‰ã¯ï¼ŒWindowsç‰ˆã‚‚æ£å¼ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ ã“ã“ã§ã¯ï¼ŒPostgreSQL 8 Windowsç‰ˆã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ï¼ŒSQLã‚³ãƒžãƒ³ãƒ‰ï¼ˆCREATE TABLEæ–‡ï¼ŒINSERTæ–‡ï¼ŒSELECTæ–‡ç‰ï¼‰ãŒä½¿ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã¾ã§ã®æ‰‹é †ã¨æ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®å…¥æ‰‹ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚µãƒ¼ãƒã®èµ·å‹•ãƒ»åœæ¢ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆ è£œè¶³äº‹é … 0. æ³¨æ„ æœ¬æ–‡ã®ç„¡æ–è¤‡è£½ã¯ãŠæ–ã‚Šã—ã¾ã™ã€‚ æœ¬æ–‡ã®å†…å®¹ã«ã¤ã„ã¦ï¼Œé–“é•ã„ã‚„æ›¸ãè¶³ã‚‰ãªã„ç‚¹ãŒã‚ã‚Šã¾ã—ãŸã‚‰ï¼Œè‘—è€…ã¾ã§ãƒ¡ãƒ¼ãƒ«ã§ãŠçŸ¥ã‚‰ã›ãã ã•ã„ã€‚ æœ¬æ–‡ã«è¨˜è¼‰ã•ã‚ŒãŸURLã‚„ãƒ•ã‚¡ã‚¤ãƒ«åã¯ï¼Œã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ç‰ã«ã‚ˆã‚Šå¤‰æ›´ã«ãªã£ã¦ã„ã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚
kei-s 2007/03/07
ã€Žã‚¢ã‚«ã‚¦ãƒ³ãƒˆã€Œpostgresã€ã¯æ®‹ã£ã¦ã„ã¦ã‚‚ç‰¹ã«å•é¡Œã¯ã‚ã‚Šã¾ã›ã‚“ãŒï¼Œå†ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç‰ã®ãŸã‚ã«å‰Šé™¤ãŒå¿…è¦ã«ãªã£ãŸå ´åˆã¯ï¼Œä»¥ä¸‹ã®ã‚ˆã†ã«ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã§net userã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã¦ãã ã•ã„ã€‚ã€

db

sql

tips
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã€€[ã‚»ãƒ³ã‚µãƒ¼ãƒãƒƒãƒˆãƒ»ã‚†ã³ããŸã™å¤§å¦]
ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã€€Moteview : ERROR[08001] or psql : Connection refused (0x0000274D/10061) ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯æ£å¸¸ã«çµ‚äº†ã—ãŸã¯ãšãªã®ã«ã€ï¼ˆã‚‚ã—ãã¯ã€Mote Viewã¯ã—ã°ã‚‰ãæ£å¸¸ã«å‹•ä½œã—ã¦ã„ãŸã®ã«ã€æ°—ã¥ã„ãŸã‚‰ãƒ»ãƒ»ã€ï¼‰å‹•ã‹ãªããªã£ã¦ã„ãŸã€‚ãã‚‚ãã‚‚ã€PostgreSQLãŒèµ·å‹•ã—ãªããªã£ãŸãƒ»ãƒ»ãƒ»ã¨ã„ã†æ™‚ã®å¯¾å¿œã€‚ Moteview ã‚¨ãƒ©ãƒ¼ã‚³ãƒ¼ãƒ‰ã€€ERROR[08001]; psql ã‚¨ãƒ©ãƒ¼ã‚³ãƒ¼ãƒ‰ã€€psql: could not connect to server: Connection refused (0x0000274D/10061) Mote-Viewã‚’èµ·å‹•ã—ã¦ã‚‚DBã«ã¤ãªãŒã‚‰ãªã„ã€‚ã‚¨ãƒ©ãƒ¼ã‚’è¦‹ã‚‹ã¨"Could not connect to the server;"ã¨ãªã£ã¦ã„ã‚‹ã€‚ ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã§ãƒ—ãƒã‚»ã‚¹ã‚’è¦‹ã¦ã¿ã‚‹ã¨ã€€
kei-s 2007/02/20
db

sql

tips
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MySQL ã®è² è·åˆ†æ•£ã« LVS + keepalived ã‚’ä½¿ã†
ã‚ã¨ã§æ›¸ãã€ã¨è¨€ã£ãŸæ‰‹å‰ãªã®ã§æ›¸ãã¨ã—ã¾ã™ã€‚ DSASã®ä¸ã®äººãŒã™ã”ã„å‹¢ã„ã§ LVS ã®è©±ã‚’æ›¸ã„ã¦ãã‚Œã¦ã¾ã™ã€‚ã“ã®è¾ºã€‚LVS ã‚’ä½¿ã†ã¨ Linux ã¨ç®±ã§ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãŒä½œã‚Œã¡ã‚ƒã„ã¾ã™ã€‚æ™®é€šã«è²·ã£ãŸã‚‰æ•°ç™¾ä¸‡ã¨ã‹ã—ã¡ã‚ƒã†ã‚„ã¤ã€‚ DSAS ã®ä¸ã®ã²ã¨ã«æ„Ÿè¬ã—ã¤ã¤ã€ã„ã„æ©Ÿä¼šãªã®ã§ã‚„ã£ã¦ã¿ã‚ˆã†! ã¨æ€ã£ã¦ã„ã‚ã„ã‚è©¦ã—ã¦æ˜¨æ—¥ã‚ãŸã‚Šã‹ã‚‰ã¯ã¦ãªã®ä¸ã§ã‚‚ LVS + keepalived ã§å‹•ã‹ã—ã¯ã˜ã‚ã¦ã¾ã™ã€‚ã„ã¾ã®ã¨ã“ã‚å•é¡Œãªã—ã€‚ ãã®ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã‚’ã©ã“ã«ä½¿ã£ã¦ã‚‹ã‹ã§ã™ãŒã€æ™®é€šãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã¨ã„ã†ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰ã®å…¥ã‚Šå£ã®ã¨ã“ã‚ã«ç½®ã„ã¦ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£ã«ä½¿ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒã‚ã‚Šã¾ã™ã€‚ãŒã€ä»Šå›žã¯ã¯ã¦ãªã§ã¯ MySQL ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã®æ‰‹å‰ã«ç½®ãã¨ã„ã†å½¹å‰²ã§ã¨ã‚Šã‚ãˆãšä½¿ã„ã¯ã˜ã‚ã¾ã—ãŸã€‚ +-----------+ +-----------+ | mod_perl | | mod_perl | +----
kei-s 2007/01/16
db

linux

server

sql

tips
ãƒªãƒ³ã‚¯
pgpool-II page
kei-s 2006/12/26
db

sql
ãƒªãƒ³ã‚¯
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢
ç›®æ¬¡23.1. SQLã«ã‚ˆã‚‹ãƒ€ãƒ³ãƒ—23.1.1. ãƒ€ãƒ³ãƒ—ã®ãƒªã‚¹ãƒˆã‚¢23.1.2. pg_dumpallã®ä½¿ç”¨23.1.3. å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ‰±ã„23.2. ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ãƒ¬ãƒ™ãƒ«ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—23.3. ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒã‚¤ãƒ³ãƒˆã‚¤ãƒ³ã‚¿ã‚¤ãƒ ãƒªã‚«ãƒãƒªï¼ˆPITRï¼‰23.3.1. WALä¿ç®¡ã®è¨å®š23.3.2. ãƒ™ãƒ¼ã‚¹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ä½œæˆ23.3.3. ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ä½¿ç”¨ã—ãŸå¾©æ—§23.3.4. æ™‚ç³»åˆ—23.3.5. è¦å‘Š23.4. ãƒªãƒªãƒ¼ã‚¹é–“ã®ç§»è¡Œ è²´é‡ãªãƒ‡ãƒ¼ã‚¿ã‚’å…¨ã¦ä¿å˜ã—ã¦ã„ã‚‹ãŸã‚ã€PostgreSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯å®šæœŸçš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚Œãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®æ‰‹é †ã¯åŸºæœ¬çš„ã«ç°¡å˜ã§ã™ãŒã€ä½¿ç”¨ã•ã‚Œã¦ã„ã‚‹æŠ€è¡“ã¨ã„ãã¤ã‹ã®ä»®å®šã¨ãªã‚‹æ¡ä»¶ã®åŸºæœ¬çš„ç†è§£ã¯é‡è¦ã§ã™ã€‚ PostgreSQLã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹å ´åˆã€3ã¤ã®ç•°ãªã‚‹æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ SQLã«ã‚ˆã‚‹ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«
kei-s 2006/09/24
sql

db
ãƒªãƒ³ã‚¯
Eclipseã«SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆæ©Ÿèƒ½ã‚’è¿½åŠ ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŽEclipse SQL Explorerã€:phpspoté–‹ç™ºæ—¥èªŒ
Eclipseã«SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆæ©Ÿèƒ½ã‚’è¿½åŠ ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŽEclipse SQL Explorerã€ 2006å¹´09æœˆ05æ—¥- Eclipse SQL Explorer Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases.Eclipseã«SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆæ©Ÿèƒ½ã‚’è¿½åŠ ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŽEclips
kei-s 2006/09/06
PostgreSQLã¯ç„¡ã„ã¿ãŸã„ï¼Ÿ

db

java

tool

plugin

sql
ãƒªãƒ³ã‚¯
é€†å¼•ãSQLæ¯”è¼ƒ
Works > é€†å¼•ãSQLæ¯”è¼ƒ é€†å¼•ãSQLæ¯”è¼ƒ [Â å…±é€šäº‹é …Â ]Â [Â ORACLEÂ ]Â [Â MSSQLÂ ]Â [Â SSAÂ ]Â [Â PostgresÂ ]Â [Â MySQLÂ ]Â [Â JetÂ ]Â Last Updated. 14-May-2006 Since 08-May-2001 â– ã¯ã˜ã‚ã« è¤‡æ•°ã® RDBMS ã‚’ä½¿ã£ãŸçµŒé¨“ãŒã‚ã‚‹äººãªã‚‰ã€ãŠã‚ã‹ã‚Šã‹ã¨æ€ã„ã¾ã™ãŒã€SQL ã¯ RDBMS ã«ã‚ˆã£ã¦ç•°ãªã‚‹éƒ¨åˆ†ãŒçµæ§‹ã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã¯å„ RDBMS ã«ãŠã‘ã‚‹ åŸºæœ¬çš„ãªæ©Ÿèƒ½ï¼ˆä¸»ã«SQLã«ã¤ã„ã¦ï¼‰ã®æ¦‚è¦ã‚’ã€é€†å¼•ãã§ã€ã‹ã¤å¹³æ˜“ãªè¨€è‘‰ã§é–²è¦§ ã™ã‚‹äº‹ã‚’ç›®çš„ã«ä½œã£ãŸãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã™ã€‚ ç‰¹å®šã® RDBMS ã‚’æŒã¡ä¸Šã’ãŸã‚Šã€è²¶ã‚ãŸã‚Šã™ã‚‹ã®ãŒç›®çš„ã§ã¯ãªã„ã®ã§èª¤è§£ãªãã‚ˆã†ã€‚ ã¾ãŸã€é–“é•ã„ã«ã¤ã„ã¦ã®ã”æŒ‡æ‘˜ã‚„ã€Žã“ã†ã—ãŸæ–¹ãŒåŠ¹çŽ‡çš„ã ã€ãªã©ã®ã”æ„è¦‹ã‚‚å¤§æ“è¿Žã§ã™ã€‚ å¯¾è±¡ã¨ã—ã¦ã„ã‚‹ã®ã¯ä»¥ä¸‹ã® RDBMSã§
kei-s 2006/06/23
sql

db

tips
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
çµµã®è¶…åˆå¿ƒè€…ãƒ‰ä¸‹æ‰‹ããäººé–“ãŒã€20æ—¥é–“çµµã‚’æã„ã¦æ„Ÿã˜ãŸã“ã¨ ã‚ãŸã—ã¯ã€ã€Œæ–‡ã®äººã€ã ã€‚çµµã‚’æãã®ã¯å¤§ã®è‹¦æ‰‹ã€‚ ãã‚“ãªã‚ãŸã—ãŒã€ã²ã‚‡ã‚“ãªã“ã¨ã‹ã‚‰çµµã‚’æãå§‹ã‚ãŸã€‚ ãã†ã—ãŸã‚‰ãŠã‚‚ã—ã‚ããªã£ã¦ç´„20æ—¥é–“ã€ãªã«ãŒã—ã‹ã‚’æãã¤ã¥ã‘ã¦ã„ã‚‹ã€‚ æœªçŸ¥ã®é ˜åŸŸã§ã®æŒ‘æˆ¦ã¯ã€ç™ºè¦‹ãŒå¤šã„ã€‚ ã¾ãŸã€ã“ã“ã¾ã§çµµã‚’æã‘ãªã„äººé–“ã®æŒ‘æˆ¦ã¯ã€ã‚ã¾ã‚Šãƒãƒƒâ€¦
kei-s 2006/05/26
rails

db

sql

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