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

einherjar id:einherjar

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

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

WordPress ã®DBä¸Šã®ã‚µã‚¤ãƒˆURLã‚’ä¸€æ°—ã«å¤‰æ› - dogmap.jp
WordPress ã‚’ã€åˆ¥ã‚µãƒ¼ãƒã«ç§»è¡Œã™ã‚‹ã«ã‚ãŸã£ã¦ã‚µã‚¤ãƒˆ URL ã‚’å¤‰æ›´ã—ãŸã„æ™‚ãŒã‚ã‚Šã¾ã™ã€‚ ä¾‹ãˆã°ã€é–‹ç™ºç’°å¢ƒã‹ã‚‰æœ¬ç•ªç’°å¢ƒã«ç§»è¡Œã™ã‚‹æ™‚ã¨ã‹ ãã‚“ãªæ™‚ã¯ã€ä»¥ä¸‹ã® SQL æ–‡ã‚’ç™ºè¡Œã™ã‚‹ã“ã¨ã§ wp_posts å†…ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€ç™ºã§ç½®æ›ã§ãã¾ã™ã€‚ UPDATE `wp_posts` SET post_content=REPLACE(post_content, "{æ—§URL}", "{æ–°URL}") where post_content like "%{æ—§URL}%"; ãŸã wp_options ã¨ã‹ wp_postmeta ã¨ã‹ã«ã¯ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ã¦ã„ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã®ã§ã€ã“ã‚Œã‚‰ã¯ãã®ã¾ã¾ç½®æ›ã™ã‚‹ã¨ã¾ãšã„ã§ã™ã€‚ (ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‡ãƒ¼ã‚¿ã®ä¸ã«ã¯ã€æ–‡å—åˆ—ã®é•·ã•ã¨ã‹ã‚‚å«ã¾ã‚Œã¦ã‚‹ã®ã§) ãã“ã§ã€ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã¯ä¸€åº¦ã‚¢ãƒ³ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºã—ã¦ã‹ã‚‰ç½®æ›ã—ã¦ã€ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºã—ãŸå¾Œã« DB ã«æ›¸ãæˆ»
einherjar 2013/01/15
wordpress

db
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®cassandraå…¥é–€
@marqsã•ã‚“ã¨@muranetã•ã‚“ã¨ä¸€ç·’ã«hbstudy#11ã§ç™ºè¡¨ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ã“ã‚Œã‚’æ©Ÿã«ã¨ã‹è¨€ã†ã¨ã§ã‹ã™ãŽã‚‹æ°—ãŒã—ã¾ã™ãŒCassandraãŒå›½å†…ã§ã‚‚ç››ã‚Šä¸ŠãŒã‚‹ã¨ã„ã„ãªãƒ¼ã¨æ€ã„ã¾ã™ã€‚ æ‡‡è¦ªä¼šã§ã‚‚çµæ§‹ä½¿ãŠã†ã¨ã—ã¦ã„ã‚‹æ–¹ãŒã„ãŸã‚Šã—ã¦ã†ã¡ã‚‚ã†ã‹ã†ã‹ã—ã¦ã‚‰ã‚Œãªã„ã§ã™ãï½— è³‡æ–™ã‚’ã‚ã’ã¾ã—ãŸã®ã§ã“ã¡ã‚‰ã‚ˆã‚ã—ã‹ã£ãŸã‚‰ã©ã†ãžï¼ ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®cassandraå…¥é–€ View more presentations from Akihiro Kuwano. ã“ã‚Œã ã‘ã¯ã‹ã‹ãªã„ã¨ï¼ ç´ æ™´ã‚‰ã—ã„ä¼šã‚’é–‹ã„ã¦ä¸‹ã•ã£ã¦ã„ã‚‹ãƒãƒ¼ãƒˆãƒ“ãƒ¼ãƒ„ã®æ–¹ã€…ã‚„ã€ã‚¹ãƒ”ãƒ¼ã‚«ãƒ¼ã®æ–¹ã€…ã€æ¥ã¦ã„ãŸã ã„ãŸæ–¹ã€…ã«æ„Ÿè¬ã—ã¦ãŠã‚Šã¾ã™ éžå¸¸ã«æ¥½ã—ã‹ã£ãŸã§ã™ï¼ ãŸã ã„ã¾äºŒæ—¥é…”ã„ã§ã™w
einherjar 2010/05/15
Cassandra

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

db.nosql

nosql

db

è³‡æ–™
ãƒªãƒ³ã‚¯
SQL4G
SQL4GGAE(Google App Engineï¼‰ä¸Šã§ç¨¼å‹•ã™ã‚‹SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ SQL4Gã¨ã¯? SQL Database for GAEã®ç•¥ç§°ã§ã™ã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®Javaãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒH2 Database Engineã€ã‚’ãƒªãƒˆãƒ«ã‚½ãƒ•ãƒˆãŒç‹¬è‡ªã«ã‚¨ãƒ³ãƒãƒ³ã‚¹ã—ã€GAEãŒç”¨æ„ã—ã¦ã„ã‚‹BigTableã¨å‘¼ã°ã‚Œã‚‹åˆ†æ•£ã‚ãƒ¼ãƒ»ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¸å†…å®¹ã‚’æ›¸ãè¾¼ã‚ã‚‹ã‚ˆã†ã«ã—ãŸã‚‚ã®ã§ã™ã€‚ ã„ã¾ã•ã‚‰RDBï¼Ÿ GAEã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¯Javaã®å ´åˆ JDOã€JPA ã¨ã„ã£ãŸã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ãŒã€JDOã€JPAã‚’é§†ä½¿ã—ã¦GAEã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’è‡ªç”±è‡ªåœ¨ã«æ‰±ã†ã“ã¨ã¯ã€ä»Šã¾ã§RDBMSã«æ…£ã‚Œè¦ªã—ã‚“ã é–‹ç™ºè€…ã«ã¨ã£ã¦ã¯ã€å°‘ã€…æ•·å±…ã®é«˜ã„ã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ ãã®ãŸã‚ã€RDBMSã«ç›¸å½“ã™ã‚‹ç’°å¢ƒãŒå˜åœ¨ã—ãªã„GAEã¯ã€ç¾çŠ¶ã«ãŠã„ã¦ã€Œã‚¯ãƒ©ã‚¦ãƒ‰ã¯é…åŠ›çš„ã ã‘ã©ãƒ‡ãƒ¼ã‚¿å‘¨ã‚Šã«é›£ã‚ã‚Šã€ã¨ãŠè€ƒãˆã«ãªã‚‹æ–¹ãŒå¤šæ•°
einherjar 2010/02/09
google app engine

DB
ãƒªãƒ³ã‚¯
Javaã®é“ï¼šTomcatï¼ˆï¼˜ï¼ŽJDBCæŽ¥ç¶šï¼‰
æ¦‚è¦ JDBCã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ã«ã¯ã„ãã¤ã‹ã®æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ã€ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ€§ã€éžãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¾å˜ãªã©ã®é–¢ä¿‚ã‹ã‚‰ç¾åœ¨æœ€ã‚‚ã‚ˆã„ã¨ã•ã‚Œã¦ã„ã‚‹JNDIã‚’åˆ©ç”¨ã—ãŸæŽ¥ç¶šæ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚JNDIï¼ˆJava Naming and Directory Interface)ã¨ã¯NISã€ActiveDirectoryãªã©ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚µãƒ¼ãƒ“ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã®Java APIã§ã™ã€‚ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚µãƒ¼ãƒ“ã‚¹å®Ÿè¡Œç’°å¢ƒã«ä¾å˜ã›ãšã€Javaã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚µãƒ¼ãƒ“ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ç¾åœ¨ã§ã¯ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚µãƒ¼ãƒ“ã‚¹ã ã‘ã§ãªãã€Javaã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ¡ãƒ¼ãƒ«ã‚µãƒ¼ãƒãªã©ã®ãƒªã‚½ãƒ¼ã‚¹ã‚’è¦‹ã¤ã‘ã‚‹ãŸã‚ã®APIã¨ã—ã¦ã‚‚åˆ©ç”¨ã•ã‚Œã¾ã™ã€‚ JNDIãƒªã‚½ãƒ¼ã‚¹ã¨ã—ã¦JDBCã‚’è¨å®šã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€Javaã‚¢ãƒ—ãƒªã‹ã‚‰ã¯JNDIãƒªã‚½ãƒ¼ã‚¹ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã§JDBCã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ
einherjar 2008/01/15
java

jdbc

jndi

tomcat

db
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘Google MySQLç™»å ´? - MySQLã®é–¢é€£ãƒ„ãƒ¼ãƒ«ã‚’å…¬é–‹ã€æœ¬ä½“ã¸ã®ãƒžãƒ¼ã‚¸ã‚’ç›®æŒ‡ã™ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ç±³Googleã¯21æ—¥(ç±³å›½æ™‚é–“)ã‹ã‚‰Google Codeã«ãŠã„ã¦ã€Œgoogle-mysql-toolsã€ã‚’å…¬é–‹ã—ã¦ã„ã‚‹ã€‚google-mysql-toolsã¯ã€Googleã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸMySQLé–¢é€£ãƒ„ãƒ¼ãƒ«ã€‚MySQLã‚’ç®¡ç†/ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã™ã‚‹ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è‡ªèº«ã®æ”¹å–„ãŒæ–½ã•ã‚Œã¦ã„ã‚‹ã€‚ åŒæ¢±ã•ã‚Œã¦ã„ã‚‹æˆæžœç‰©ã®ä¸»ãªå†…å®¹ã¯æ¬¡ã®ã¨ãŠã‚Šã€‚ mypgrep.py - pgrepã«ä¼¼ãŸMySQLã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’ç®¡ç†ã™ã‚‹ãƒ„ãƒ¼ãƒ« compact_innodb.py - ã™ã¹ã¦ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ€ãƒ³ãƒ—/ãƒªãƒãƒ¼ãƒ‰ã™ã‚‹ã“ã¨ã§InnoDBãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‚’åœ§ç¸®ã™ã‚‹ãƒ„ãƒ¼ãƒ« MySQL 4.0.26ã«å¯¾ã™ã‚‹æ©Ÿèƒ½è¿½åŠ /æ‹¡å¼µãƒ‘ãƒƒãƒ google-mysql-toolsã®é–‹ç™ºè€…ã§ã‚ã‚Šã€Googleã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹Mark Callaghanæ°ã¯ã€23æ—¥(ç±³å›½æ™‚é–“)ä»˜ã‘ã®è‡ªèº«ã®ãƒ–ãƒã‚°ã§åŒãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦è§£èª¬
einherjar 2007/08/29
database

db

google

mysql

tool
ãƒªãƒ³ã‚¯
@it-ç¬¬1å›žã€€DBã‚¢ãƒ—ãƒªã®ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆ â€• ï¼ IT
ç¬¬1å›žã€€DBã‚¢ãƒ—ãƒªã®ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆï¼šé€£è¼‰ï¼šVisual Studio 2005ã«ã‚ˆã‚‹Windowsãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ é€£è¼‰ç›®æ¬¡ Visual Studio 2005ï¼ˆä»¥ä¸‹ã€VS 2005ï¼‰ã¯ã€ä»¥å‰ã®Visual Studioã«æ¯”ã¹ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆä»¥ä¸‹ã€DBã‚¢ãƒ—ãƒªï¼‰ã‚’ä½œæˆã™ã‚‹ãŸã‚ã®æ©Ÿèƒ½ãŒéžå¸¸ã«å……å®Ÿã—ã¦ã„ã¾ã™ã€‚ã†ã¾ãæ´»ç”¨ã™ã‚Œã°ã€DBã‚¢ãƒ—ãƒªã®åŸºæœ¬çš„ãªéƒ¨åˆ†ã¯ã‚³ãƒ¼ãƒ‰ã‚„SQLæ–‡ã‚’è¨˜è¿°ã—ãªãã¦ã‚‚ä½œæˆã§ãã‚‹ã»ã©ã§ã™ã€‚ ã—ã‹ã—ã“ã‚Œã‚‰ã®VS 2005ã®æ©Ÿèƒ½ã¯è±Šå¯Œã§ã‚ã‚‹ãŒã‚†ãˆã«ã€åˆå¿ƒè€…ã«ã¨ã£ã¦ã¯ä½¿ã„ã“ãªã™ã®ãŒå°‘ã€…å›°é›£ãªéƒ¨åˆ†ã‚‚å¤šãã€åˆå¿ƒè€…ã§ãªãã¨ã‚‚1åº¦ã‚„2åº¦è§¦ã£ãŸãã‚‰ã„ã§ã¯ãªã‹ãªã‹è¦šãˆãã‚Œã‚‹ã‚‚ã®ã§ã¯ãªã„ã¯ãšã§ã™ã€‚ ã¾ãŸã€VS 2005ã®IDEæ©Ÿèƒ½ã«ã‚ˆã‚Šä½œæˆã•ã‚Œã‚‹DBã‚¢ãƒ—ãƒªã¯ã€ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã‚„ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã¨ã€ãƒ‡ã‚¶ã‚¤ãƒŠã‚„ã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰ãªã©ãŒè‡ªå‹•ç”Ÿæˆã™ã‚‹
einherjar 2007/07/24
.net

db

vb2005
ãƒªãƒ³ã‚¯
http://otn.oracle.co.jp/tech/oci/
einherjar 2007/07/24
oracle

db
ãƒªãƒ³ã‚¯
1