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

astrsk_hori id:astrsk_hori

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

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

SQL vs NoSQLã€ã‚°ãƒ¼ã‚°ãƒ«ã«ãŠã‘ã‚‹æˆ¦ã„ï¼ˆå‰ç·¨ï¼‰ã€‚Google I/O 2012
SQLã¨NoSQLã§ã¯ã©ã¡ã‚‰ãŒå„ªã‚Œã¦ã„ã‚‹ã®ã‹ï¼Ÿ ã‚°ãƒ¼ã‚°ãƒ«ã®æ‹…å½“è€…ãŒãƒ‡ã‚£ãƒ™ãƒ¼ãƒˆï¼ˆã¨ã„ã†ã‚ˆã‚Šå°èŠå±…ï¼š-ï¼‰ã‚’è¡Œã£ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯ã€å…ˆã€…é€±é–‹å‚¬ã•ã‚ŒãŸGoogle I/O 2012ã§è¡Œã‚ã‚ŒãŸã‚‚ã®ã€‚SQLã¨NoSQLã«ã¯æ©Ÿèƒ½çš„ã«ã©ã®ã‚ˆã†ãªé•ã„ãŒã‚ã‚Šã€ã©ã†ä½¿ã„åˆ†ã‘ã‚‹ã¹ããªã®ã‹ã€æ˜Žç¢ºãªèª¬æ˜ŽãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ¡ãƒªãƒƒãƒˆ ã‚°ãƒ¼ã‚°ãƒ«ã®Alfred Fulleræ°ï¼ˆNoSQLæ‹…å½“ï¼‰ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã¯ãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ä¸è¦ã€ãƒ‘ãƒƒãƒã‚‚ç§ãŸã¡ãŒé©ç”¨ã—ã¦ãŠã‚Šã€åˆ©ç”¨è€…ã¯é‹ç”¨ã«ã¤ã„ã¦å¿ƒé…ã™ã‚‹å¿…è¦ãŒãªã„ã€ã¨ã„ã£ãŸãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„åœ°åŸŸåˆ†æ•£ã§ãƒ‡ãƒ¼ã‚¿ã‚‚ä¿å…¨ã•ã‚Œã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒ
astrsk_hori 2012/07/10
nosql

sql

Google

DB

ã‚¯ãƒ©ã‚¦ãƒ‰

database
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¢ãƒƒãƒ—ï¼ | QK
mysqlã«ã¯ã€ãƒ¬ãƒ³ã‚¸ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã£ã¦ã‚‚ã®ãŒã‚ã‚Šã¾ã—ã¦ã€ã†ãƒ¼ãªã‚“ã§ã—ã‚‡ï¼Ÿã‚ã‚‹è¦å‰‡ã«ã—ãŒã£ãŸãƒ‡ãƒ¼ã‚¿ã‚’ãŠã®ãŠã®ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã«æŒ¯ã‚Šåˆ†ã‘ã¦ãã‚Œã‚‹æ©Ÿèƒ½ã§ã™ã€‚ ãƒ»ãƒ‡ãƒ¼ã‚¿é ˜åŸŸãŒåˆ†å‰²ã•ã‚Œã‚‹ãŸã‚ã€å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‡¦ç†ã™ã‚‹ã“ã¨ã«ã‚ˆã‚‹æ€§èƒ½ä¸Šã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®ç™ºç”Ÿã‚’æŠ‘ãˆã‚‰ã‚Œã‚‹ ãƒ»MyISAMãªã©ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã«ä¸Šé™ãŒã‚ã‚‹å ´åˆã§ã‚‚ãã‚Œä»¥ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ ã¨ã„ã£ãŸç‚¹ã§ã™ã€å°‘ãªã„ãƒ‡ãƒ¼ã‚¿ã§ã™ã¨ã“ã‚Œã¨ã„ã£ãŸåˆ©ç‚¹ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ãŒã€æ•°ç™¾ä¸‡è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã§ã™ã¨ã€ã“ã®ãƒ‡ãƒ¼ã‚¿åˆ†å‰²ãŒã€å¤§ããªåŠ¹æžœã‚’å‘¼ã¶ã€‚ã€‚ã‹ã‚‚ã—ã‚Œãªã„ã§ã™ã—ã€ãã†ã§ãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ï¼ˆæ±— ãŸã ã€ã¯ã£ãã‚Šã¨ã„ãˆã‚‹ã®ãŒã€ã‚ã‚‹è¦å‰‡ã«å¾“ã£ãŸãƒ‡ãƒ¼ã‚¿ã‚’ã€SELECTã™ã‚‹éš›ã«ãã®SELECTã§å¿…è¦ã®ç„¡ã„ãƒ‡ãƒ¼ã‚¿ã¾ã§ã€mysqlãŒã‚·ãƒ¼ã‚¯ã™ã‚‹å¿…è¦ãŒãªã„ã£ã¦ã„ã£ãŸã¨ã“ã‚ã§ã—ã‚‡ã†ã‹ï¼ŸãŸã ã—ã€ãƒ‡ãƒ¼ã‚¿ã‚’ã¾ãŸãæ¤œç´¢ãŒç™ºç”Ÿã™ã‚‹å ´åˆã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯éžãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã¨æ¯”
astrsk_hori 2012/04/26
ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°

MySQL

ãƒ†ãƒ¼ãƒ–ãƒ«

table

ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³

partitioning

db
ãƒªãƒ³ã‚¯
Spider DeNA Technology Seminar #2
12. ãƒ†ãƒ¼ãƒ–ãƒ«ãƒªãƒ³ã‚¯ Spider Storage Create table tbl_a ( tbl_a tbl_a col_a int, Engineâ€™s table col_b int, primary key(col_a) DB1 ) engine = Spider Other Storage Connection â€˜ 2.Get data tbl_a host â€œDB1â€, Engineâ€™s table table â€œtbl_aâ€, user â€œuserâ€, password â€œpassâ€ â€˜; tbl_a tbl_b Local DB 3.Join 1.Request select tbl_a.col_a, tbl_b.col_c 4.Response from tbl_a, tbl_b where tbl_a.col_a = 1 and tbl_a.col_b = tbl_b
astrsk_hori 2010/07/13
ä½¿ã£ã¦ã¿ãŸã„

spider

DB

MySQL
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
astrsk_hori 2010/05/20
MySQL

tips

PHP

sql

DB

performance

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ã¾ã‚‹ã§é”æ³•ã®ã‚ˆã†ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ï¼Ÿï¼ŸVP for MySQLã«ã‚ˆã‚‹é©šæ„•ã®ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€‚
å…ˆæ—¥ã€SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã¤ã„ã¦2åº¦ã«æ¸¡ã‚Šæœ¬ãƒ–ãƒã‚°ã§ç´¹ä»‹ã—ãŸï¼ˆãã®ï¼‘ï¼šNot Only NoSQL!! é©šç•°çš„ãªã¾ã§ã«WRITEæ€§èƒ½ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ãã®ï¼’ï¼šå¿«é©ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆç”Ÿæ´»ã¸ã®ç¬¬ä¸€æ©ã€‚SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ï¼ï¼‰ãŒã€SPIDERã®ä½œè€…ã§ã‚ã‚‹æ–¯æ³¢æ°ã¯ã€å®Ÿã¯ã‚‚ã†ä¸€ã¤é©šãã¹ãã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’é–‹ç™ºã—ã¦ã„ã‚‹ã€‚ãã®åã‚‚ã€VPã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã ã€‚ã¡ã‚‡ã£ã¨åœ°å‘³ãªåå‰ã ãŒã€VPã¨ã¯ã€Vertical Partitioningï¼ˆåž‚ç›´ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ï¼‰ã®ç•¥ã§ã€è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸Šã«VPã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’è¢«ã›ã¦ã€åž‚ç›´ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ï¼ˆã‚«ãƒ©ãƒ ã”ã¨ã«ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹é ˜åŸŸã‚’åˆ†ã‘ã‚‹ï¼‰ã‚’å®Ÿç¾ã™ã‚‹ã¨ã„ã†ã‚‚ã®ã ã€‚ä»–ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸Šã«è¢«ã›ã‚‹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ã¨ã£ã¦ã„ã‚‹ã¨ã„ã†ç‚¹ã§ã¯ã€VPã¨SPIDERã®ç™ºæƒ³ã¯åŒã˜ã§ã‚ã‚‹ã€‚ä»¥ä¸‹ã¯ã€VPã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®å‹•ä½œ
astrsk_hori 2010/04/20
MySQL

vp

spider

VPã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³

db

database
ãƒªãƒ³ã‚¯
textsearch_senna
N-gram ã‚’ä½¿ç”¨ã—ãŸã€çµ„ã¿è¾¼ã¿åž‹ã®æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ã§ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ : ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã®ã»ã‹ã€Windows ç”¨ãƒã‚¤ãƒŠãƒªã‚‚ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆ ãƒ¡ãƒ¼ãƒªãƒ³ã‚°ãƒªã‚¹ãƒˆ ã¸ã®å‚åŠ æ¦‚è¦ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ãƒ†ã‚ã‚¹ãƒˆæ¤œç´¢æ©Ÿèƒ½ %% æ¼”ç®—å @@ æ¼”ç®—å ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ (senna) ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ»ã‚ªãƒ—ã‚·ãƒ§ãƒ³ (WITH) ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ senna.drop_index() senna.reindex_index() ä¸è¦ãƒ•ã‚¡ã‚¤ãƒ«ã®èª¿æŸ» TODO æ¦‚è¦ æ—¥æœ¬èªžãƒ†ã‚ã‚¹ãƒˆã®å…¨æ–‡æ¤œç´¢ã‚’è¡Œã„ã¾ã™ã€‚ å½¢æ…‹ç´ è§£æžãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ textsearch-ja ã¨ã¯ç•°ãªã‚Šã€textsearch_senna ã§ã¯ N-gram ãƒ™ãƒ¼ã‚¹ã®å…¨æ–‡æ¤œç´¢ã‚’è¡Œã„ã¾ã™ã€‚ æ¤œç´¢ã«ã¯ã€å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ Senna ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ åˆ©ç‚¹ã¨ã—ã¦ã€æ–‡å—ã™ã¹ã¦ã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹åŒ–ã™ã‚‹ãŸã‚ LIKE ä¸é–“ä¸€è‡´æ¤œç´¢ã«è¿‘ã„çµæžœ
astrsk_hori 2010/02/23
postgresã®å…¨æ–‡æ¤œç´¢

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

DB

PostgreSQL

senna

tsearch2

textsearch
ãƒªãƒ³ã‚¯
ç¨¼å‹•çµ±è¨ˆæƒ…å ±ã‚’æ´»ç”¨ã—ã‚ˆã†(3) â€” Let's Postgres
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ ç¬ åŽŸ è¾°ä» æœ‰ç”¨ãªæƒ…å ±ã‚’æŒã¤ãƒ†ãƒ¼ãƒ–ãƒ« / ãƒ“ãƒ¥ãƒ¼ ç¨¼å‹•çµ±è¨ˆæƒ…å ±ã‚’æŒã¤ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ãƒ“ãƒ¥ãƒ¼ã®ä¸€éƒ¨ã«ã¤ã„ã¦ã€ã©ã®ã‚ˆã†ãªæƒ…å ±ã‚’è“„ç©ã—ã¦ã„ã‚‹ã‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚å‰ãƒšãƒ¼ã‚¸ã§ç¨¼å‹•çµ±è¨ˆæƒ…å ±ã®å–å¾—æ–¹æ³•ã‚’è¿°ã¹ã¾ã—ãŸãŒã€ç´¹ä»‹ã—ãŸã‚‚ã®ä»¥å¤–ã«ã‚‚ã€ä¸‹è¨˜ã«ç¤ºã™ã‚ˆã†ã«è‰²ã€…ãªæƒ…å ±ãŒå–å¾—ã§ãã¾ã™ã€‚ pg_stat_database DBå˜ä½ã§ã€å®Ÿæ–½ã•ã‚ŒãŸè¡¨ã‚¹ã‚ãƒ£ãƒ³ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚¹ã‚ãƒ£ãƒ³æ•°ãªã©ãŒç¢ºèªã§ãã¾ã™ã€‚DBå˜ä½ã§ã–ã£ãã‚Šã¨ã—ãŸã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£çŠ¶æ³ã‚’ç¢ºèªã™ã‚‹ã®ã«ä¾¿åˆ©ã§ã™ã€‚ã“ã®ãƒ“ãƒ¥ãƒ¼ã§ã¯ä¸‹è¨˜ã®é …ç›®ã‚’ç¢ºèªã§ãã¾ã™ã€‚ pg_stat_database åå‰ ver. èª¬æ˜Ž
astrsk_hori 2010/02/18
Postgres

postgresql

DB
ãƒªãƒ³ã‚¯
ã€HOMMEZ(ã‚ªãƒ ã‚º)å…¬å¼ã€‘ã™ã¹ã¦ã¯ã€æ‚©ã‚ã‚‹ç”·æ€§ã®ãŸã‚ã«ã€‚
HOMMEZ(ã‚ªãƒ ã‚º)ã¯ã™ã¹ã¦ã®ç”·æ€§ã®æ‚©ã¿ã«å¯„ã‚Šæ·»ã„ã€å¿ƒã¨èº«ä½“ã®å¥åº·ã‚’æ”¯æ´ã—ã€ç”·æ€§ã¨ã—ã¦ã®å–œã³ã‚’äº«å—ã§ãã‚‹ç¤¾ä¼šã‚’ç›®æŒ‡ã—ã¦ã„ã¾ã™ã€‚äººã«ã¯ç›¸è«‡ã—ã¥ã‚‰ã„AGAã€ãƒ€ã‚¤ã‚¨ãƒƒãƒˆã€EDã€å¦Šæ´»ã«ã¾ã¤ã‚ã‚‹ç”·æ€§ç‰¹æœ‰ã®æ‚©ã¿ã«å¯¾ã—ã€æƒ…å ±ã‚„ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æä¾›ã™ã‚‹ã“ã¨ã§ç”·æ€§ãŒå‰å‘ãã«è‡ªåˆ†ã‚‰ã—ãç”Ÿãã‚‰ã‚Œã‚‹å¹¸ã›ã‚’å®Ÿç¾ã—ã¾ã™ã€‚
astrsk_hori 2010/02/16
postgreSQL

php

Postgres

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DB

apache
ãƒªãƒ³ã‚¯
Safari 3.1 ã«å®Ÿè£…ã•ã‚ŒãŸã€ŒClient-side database storage (SQL API)ã€ã¨ã¯ä½•ã‹ï¼Ÿ - ITæˆ¦è¨˜
ã¯ã˜ã‚ã« Safari 3.1 ã«ã¯ Client-side database storage ï¼ˆSQL API ã¨ã‚‚å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚ï¼‰ã¨ã„ã†æ–°ã—ã„ä»•æ§˜ãŒå®Ÿè£…ã•ã‚Œã¾ã—ãŸã€‚ ã¨ã„ã†ã‚ã‘ã§ã€ã“ã®æ–°ã—ã„ API ã«ã¤ã„ã¦è‰²ã€…èª¿ã¹ãŸã“ã¨ã‚’ç°¡å˜ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ Client-side database storage ãŒä½¿ãˆã‚‹ãƒ–ãƒ©ã‚¦ã‚¶ 2008 å¹´ 03 æœˆ 27 æ—¥ç¾åœ¨ã§ã¯ã€ Safari ç³»ã®ãƒ–ãƒ©ã‚¦ã‚¶ã®ã¿ã§ã™ã€‚ Safari 3.1 WebKit Nightly Client-side database storage ã¨ã¯ Selectors API ã¨ã¯ HTML5 ã§å®šç¾©ã•ã‚ŒãŸä»•æ§˜ã§ã™ã€‚è©³ç´°ã«é–¢ã—ã¦ã¯ã“ã¡ã‚‰ã‚’ã©ã†ãžã€‚ ç°¡å˜ã«èª¬æ˜Žã™ã‚‹ã¨ JavaScript å†…ã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ãˆã‚‹ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ã‚‚ã£ã¨ç°¡å˜ã«ã‚¤ãƒ¡ãƒ¼ã‚¸ã™ã‚‹ãŸã‚ã«ã€å®Ÿéš›ã®ã‚³ãƒ¼ãƒ‰ã‚’ç¤ºã™ã¨ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ va
astrsk_hori 2009/08/26
ã‚ã¨ã§èªã‚€

javascript

db
ãƒªãƒ³ã‚¯
DBå¾©æ—§ãƒ»æœ€é©åŒ–ã‚„ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆç‰ã€MySQLé–¢é€£ã®é–‹ç™ºãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹é›†:phpspoté–‹ç™ºæ—¥èªŒ
DBå¾©æ—§ãƒ»æœ€é©åŒ–ã‚„ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆç‰ã€MySQLé–¢é€£ã®é–‹ç™ºãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹é›†ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ Roundup of MySQL Cheat Sheets & Free Quick Reference Guides - Webmaster & Web Design Tools Blog MYSQLã®ã‚³ãƒžãƒ³ãƒ‰ã‚„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã«é–¢ã™ã‚‹ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆé›†ã„ã£ã±ã„ SayNoToFlash ? 25 Point Basic MySQL Setup/Optimization Checklist MySQLæœ€é©åŒ–ã®ãŸã‚ã®ï¼’ï¼•ã®ãƒã‚§ãƒƒã‚¯ãƒªã‚¹ãƒˆ How To Change MySQL Root Password MySQLã®rootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹æ–¹æ³•è‰²ã€… Recovery after DROP [ TABLE | DATABASE ] | MySQL Performance Blog MYSQLã§DROPãƒ†ãƒ¼ãƒ–
astrsk_hori 2009/07/27
ã¾ã¨ã‚

cheatsheet

db

tips

MySQL
ãƒªãƒ³ã‚¯
Ywcafe.net
Ywcafe.net This Page Is Under Construction - Coming Soon! Why am I seeing this 'Under Construction' page? Related Searches: Free Credit Report music videos Migraine Pain Relief Best Mortgage Rates Credit Card Application Trademark Free Notice Review our Privacy Policy Service Agreement Legal Notice Privacy Policy
astrsk_hori 2009/05/29
tips

db

postgreSQL
ãƒªãƒ³ã‚¯
Plurk.comã§ä½¿ã‚ã‚Œã¦ã„ã‚‹Tokyo Cabinetã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸã‚ãƒ¼/ãƒãƒªãƒ¥ãƒ¼ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹Â·LightCloud MOONGIFT
Twitterã«ä¼¼ãŸWebã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã™ã‚‹Plurk.comã€‚æ™‚é–“è»¸ã‚’æŒã¤ã“ã¨ã§ã€ã‚ˆã‚Šã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ãªå°è±¡ä¸Žãˆã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã ã€‚ä¸–ç•Œçš„ã«å±•é–‹ã—ã¦ã„ã‚‹ã®ã§ã‚¢ã‚¯ã‚»ã‚¹æ•°ã‚‚ç›¸å½“å¤šã„ã€‚ãã®ã‚ˆã†ãªä¸ã§æ´»èºã™ã‚‹ã®ãŒã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã ã€‚ å®Ÿè·µã§ä½¿ã‚ã‚Œã¦ã„ã‚‹ä¿¡é ¼æ€§é«˜ã„ã‚ãƒ¼/ãƒãƒªãƒ¥ãƒ¼ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ Plurk.comã§ã¯3ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ã‚‹ã€‚ä¸€ã¤ã¯MySQLã‚‚ã†ä¸€ã¤ã¯memcachedã€‚ãã—ã¦æœ€å¾Œã«LightCloudã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯LightCloudã€Tokyo Cabinetã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸã‚ãƒ¼/ãƒãƒªãƒ¥ãƒ¼ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã€‚ LightCloudã¯mixiãªã©ã§ã‚‚ãŠé¦´æŸ“ã¿ã®Tokyo Cabinetã‚’åˆ©ç”¨ã—ã¦æ§‹ç¯‰ã•ã‚Œã¦ã„ã‚‹ã€‚ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯Pythonã®ã¿ã§ã¯ã‚ã‚‹ãŒã€ä»–ã®è¨€èªžã¸ã®ãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ã‚‚ãã‚Œã»ã©é›£ã—ããªã•ãã†ã¨ã®ã“ã¨ã ã€‚å®Ÿéš›ã«Plurk.comã§ä½¿ã‚ã‚Œã¦ã„ã‚‹ã¨ã„ã†ç‚¹ãŒ
astrsk_hori 2009/05/27
Tokyo Cabinetã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸã‚ãƒ¼/ãƒãƒªãƒ¥ãƒ¼ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

python

db
ãƒªãƒ³ã‚¯
DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š - ã‚ˆãã®ã¯ã¦ãª
ã“ã“ã®ã¨ã“ã‚ã€javaccã¨awsã«é…äº†ã•ã‚Œã¦ã„ã‚‹ç±³æž—ã§ã™ã€‚ ã‚ˆãä½¿ã†DB(Oracle/MySQL/PostgreSQL/SQLServer)ã«ãŠã‘ã‚‹è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Šã§ä½¿ã†ã‚µã‚¤ãƒˆã®å‚™å¿˜éŒ²ã€‚ ã‚ã¨ã¯ã€Oracleã‹ã‚‰ã®Pythonæƒ…å ±ã€‚ Oracle Oracle ç‰©ç†è¨è¨ˆ http://www.oracle.com/techno logy/global/jp/columns/skillup/oracle9i/index.html é ˜åŸŸã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š http://otn.oracle.co.jp/document/estimate/index.html OTNã«ãƒã‚°ã‚¤ãƒ³ã™ã‚‹å¿…è¦ã‚ã‚Šã¾ã™ãŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§è¦‹ç©ã‚‚ã‚ŠãŒå‡ºæ¥ã¾ã™ã€‚ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæŒã£ã¦ã„ãªã„äººã¯ã€ã“ã®è¦‹ç©ã‚‚ã‚Šãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ç›®çš„ã§ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œã£ã¦ã¿ã¦ã¯ã„ã‹ãŒã§ã—ã‚‡ã†ã‹ã€‚ OLTPç³»ã¨DWHç³»ã«ãŠã„ã¦ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã‚’è€ƒæ…®ã—ã€DWHç³»ã¯ãƒ–
astrsk_hori 2009/05/12
db

tips

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
1