[B! sql] gam-22ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

gam-22 id:gam-22

sqlã«é–¢ã™ã‚‹gam-22ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

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

BigQueryã®ã‚¯ã‚¨ãƒªã§å®šæ•°ã‚’å®šç¾©ã—ã¦è¤‡æ•°ç®‡æ‰€ã§ä½¿ã„ãŸã„ - å”¯ç‰©æ˜¯çœŸ @Scaled_Wurm
BigQueryã§ã‚¯ã‚¨ãƒªã‚’æ›¸ãã¨ãã«ã€åŒã˜æ—¥ä»˜ã‚„å€çŽ‡ã€å††å‘¨çŽ‡ãªã©ã®å®šæ•°ã‚’ã‚¯ã‚¨ãƒªã®è¤‡æ•°ç®‡æ‰€ã§ä½¿ã„ãŸã„æ™‚ãŒã‚ã‚Šã¾ã™ å˜ç´”ã«è¤‡æ•°ç®‡æ‰€ã«æ›¸ãã¨ä¿®æ£ã™ã‚‹ã¨ãã«å¤§å¤‰ãªã®ã§ã€å…±é€šã®ã‚‚ã®ã‚’è¤‡æ•°ç®‡æ‰€ã§ä½¿ã„ã¾ã‚ã™æ–¹æ³•ã‚’èª¿ã¹ã¦ã¿ã¾ã—ãŸ UDF(ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©é–¢æ•°)ã«ã‚ˆã‚‹æ–¹æ³• å®šæ•°ã‚’è¿”ã™é–¢æ•°ã‚’å®šç¾©ã—ã¦ä½¿ã†æ–¹æ³•ãŒä¸€ç•ªç°¡å˜ã§ã™ ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©ã®é–¢æ•° Â |Â BigQuery ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ Â |Â Google Cloud Platform Standard SQLã®UDFã¯ä»¥ä¸‹ã®ã‚ˆã†ãªå½¢å¼ã§æ›¸ã‘ã¾ã™ CREATE TEMPORARY FUNCTION é–¢æ•°å(å¼•æ•°å åž‹, ...) AS (ä½¿ã„ãŸã„SQL); ã“ã‚Œã‚’ä½¿ã†ã¨ä»¥ä¸‹ã®ã‚ˆã†ã«å®šæ•°ã¨ã—ã¦ä½¿ã†ã“ã¨ãŒã§ãã¦ã€ä¿®æ£ã—ãŸã„ã¨ãã¯é–¢æ•°ã®å®šç¾©ã ã‘ã‚’å¤‰ãˆã‚Œã°ã‚ˆããªã‚Šã¾ã™ #StandardSQL CREATE TEMPORARY FUNCTION RATE1() AS (0.
gam-22 2019/05/16
BigQuery ã§ã¯å®šæ•°ã‚„å¤‰æ•°ã¯å®šç¾©ã§ããªã„ã®ã§ã€ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ã‚’ä»£æ›¿ã«ã¤ã‹ã†ã®ãŒè‰¯ã„ã‚‰ã—ã„

sql

BigQuery
ãƒªãƒ³ã‚¯
SQL
äº¬å¤§ãƒžã‚¤ã‚³ãƒ³ã‚¯ãƒ©ãƒ–ãŒæ•™ãˆã‚‹çµ¶å¯¾ã«å¤±æ•—ã—ãªã„è¨€èªžã®é¸ã³æ–¹ ã‚ãƒŸã«ã¯ SQL ãŒã‚ªã‚¹ã‚¹ãƒ¡ã ï¼ ãƒãƒ¥ãƒ¼ãƒªãƒ³ã‚°å®Œå…¨ SQLã¯ãƒãƒ¥ãƒ¼ãƒªãƒ³ã‚°å®Œå…¨ãªã®ã§ï¼Œä»–ã®è¨€èªžã¨åŒæ§˜ã«å®Ÿç”¨çš„ãªãƒ—ãƒã‚°ãƒ©ãƒ ã‚’è¨˜è¿°ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼Ž ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é€£æºã§ãã‚‹ SQLã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å•ã„åˆã‚ã›ã‚‹æ©Ÿèƒ½ã‚‚æŒã£ã¦ã„ã‚‹ãŸã‚ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’ç”¨ã„ãŸãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ç°¡å˜ã«è¨˜è¿°ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼Ž ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã¯ãƒ•ã‚£ãƒœãƒŠãƒƒãƒæ•°åˆ—ã®ç¬¬10é …ã¾ã§ã‚’è¡¨ç¤ºã™ã‚‹ã‚³ãƒ¼ãƒ‰ã§ã™ï¼Ž å®Ÿè¡Œçµæžœ WITH RECURSIVE fib(x, y, i) AS ( VALUES(0, 1, 1) UNION ALL SELECT y, x + y, i + 1 FROM fib LIMIT 1477 ) SELECT x from fib WHERE i <= 10; Tweet
gam-22 2017/04/02
ã¸ã‡ã€œâ€œSQLã¯ãƒãƒ¥ãƒ¼ãƒªãƒ³ã‚°å®Œå…¨ãªã®ã§ï¼Œä»–ã®è¨€èªžã¨åŒæ§˜ã«å®Ÿç”¨çš„ãªãƒ—ãƒã‚°ãƒ©ãƒ ã‚’è¨˜è¿°ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼Ž â€

sql

ãƒãƒ¥ãƒ¼ãƒªãƒ³ã‚°å®Œå…¨

ãƒ—ãƒã‚°ãƒ©ãƒ
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
gam-22 2015/10/05
ã“ã®è¾ºã‚’å®Ÿè·µã™ã‚‹ã ã‘ã§ISUCON5ã®äºˆé¸ã§1ä¸‡ç‚¹è¶…ãˆãŸã€‚

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

sql

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

mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
Goã®database/sql.Stmtã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’æ”¹å–„ã—ã¾ã—ãŸ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
å…ˆæ—¥ã€ Goã«åˆã‚ã¦ç§ã®ãƒ‘ãƒƒãƒãŒå–ã‚Šè¾¼ã¾ã‚Œ ã€ã‚³ãƒ³ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚¿ã«ä»²é–“å…¥ã‚Šã—ã¾ã—ãŸã€‚ ã“ã®ãƒ‘ãƒƒãƒã¯ã€ database/sql.Stmt ã‚’ãƒ˜ãƒ“ãƒ¼ã«ä½¿ã£ãŸæ™‚ã«æ€§èƒ½ãŒã ã„ãŸã„16ã‚³ã‚¢ä»¥ä¸Šã®ã‚³ã‚¢æ•°ã«ã‚¹ã‚±ãƒ¼ãƒ«ã—ãªã„ã¨ã„ã†å•é¡Œã‚’è§£æ±ºã™ã‚‹ã‚‚ã®ã§ã™ã€‚ ã“ã†ã„ã£ãŸå•é¡Œã‚’ã©ã†ã‚„ã£ã¦èª¿æŸ»ã™ã‚‹ã®ã‹ã¨ã€Goã«ãƒ‘ãƒƒãƒãŒå–ã‚Šè¾¼ã¾ã‚Œã‚‹ã¾ã§ã®æ‰‹é †ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ èƒŒæ™¯ ç§ã¯ Tech Empower ã® FrameworkBenchmarks ã¨ã„ã†ã€ã„ã‚ã‚“ãªè¨€èªž/ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã§åŒä¸€ã®ã‚¢ãƒ—ãƒªã‚’ä½œã£ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã™ã‚‹ã¨ã„ã†ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã€ä¸»ã«Pythoné–¢é€£ã®ãƒ¡ãƒ³ãƒ†ãƒŠã‚’ã—ã¦ã„ã¾ã™ã€‚ Goã«ã‚‚èˆˆå‘³ãŒã‚ã‚‹ã®ã§ã€Ginã¨ã„ã†ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’è¿½åŠ ã—ãŸã‚Šã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼ã«å‚åŠ ã—ãŸã‚Šã—ã¦ã„ã¾ã™ã€‚ 2014-05-01 ã«è¡Œã‚ã‚ŒãŸå‰å›žã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ Round 9 ã§ã¯ã€ PEAK Hosting ãŒå®Ÿè¡Œç’°å¢ƒã«åŠ ã‚ã‚Šã¾ã—ãŸã€‚ã“ã®ç’°å¢ƒã¯ã€ãƒ‡ãƒ¥
gam-22 2015/01/26
sql

database

ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯

programming

go
ãƒªãƒ³ã‚¯
ã‚ªãƒˆã‚³ã®ã‚½ãƒ¼ãƒˆãƒ†ã‚¯ãƒ‹ãƒƒã‚¯2008
ä»Šæ—¥ã¯ä»•äº‹ç´ã‚ã ã£ãŸã®ã§ã€ä¸€å¹´ã®ç· ã‚ããã‚Šã¨ã—ã¦MySQLã«ãŠã‘ã‚‹ã‚½ãƒ¼ãƒˆã®è©±ã§ã‚‚ã—ã‚ˆã†ã¨æ€ã†ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åˆ©ç”¨ã—ãªã„ã‚¯ã‚¨ãƒªã§æœ€ã‚‚ã‚ˆãè¦‹ã‹ã‘ã‚‹ã‚‚ã®ã®ã²ã¨ã¤ã¯ã€ORDER BYã‚’ç”¨ã„ãŸã‚½ãƒ¼ãƒˆå‡¦ç†ã ã‚ã†ã€‚ã‚‚ã—ã€ã‚½ãƒ¼ãƒˆå‡¦ç†ã«ãŠã„ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ç”¨ã„ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚Œã°ã€MySQLã¯çµæžœã‚’æŠ½å‡ºã—ã¦ã‹ã‚‰çµæžœè¡Œã‚’ã‚½ãƒ¼ãƒˆã™ã‚‹ã®ã§ã¯ãªãã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹é †ã«è¡Œã‚’å–ã‚Šå‡ºã›ã°è‰¯ã„ã®ã§é«˜é€Ÿã«ã‚½ãƒ¼ãƒˆå‡¦ç†ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€‚ç‰¹ã«ã€LIMITå¥ã‚„WHEREå¥ã‚’ç”¨ã„ã¦è¡Œã®çµžã‚Šè¾¼ã¿ã‚’è¡Œã†å ´åˆã¯åŠ¹æžœãŒçµ¶å¤§ã§ã‚ã‚‹ã€‚ã—ã‹ã—ã€ã²ã¨ãŸã³ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åˆ©ç”¨ã§ããªã„çŠ¶æ³ã«ç›´é¢ã™ã‚‹ã¨ã€ãŸã¡ã¾ã¡ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãŒç™ºç”Ÿã—ã¦æ€§èƒ½ãŒåŠ£åŒ–ã—ã¦ã—ã¾ã†ã€‚ ä¾‹ãˆã°ã€100ä¸‡è¡Œã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ ¼ç´ã—ãŸt1ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚‹ã¨ã™ã‚‹ã€‚ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãŸå ´åˆã‚’è€ƒãˆã‚ˆã†ã€‚ mysql> SELECT col1, col2 ... colx
gam-22 2014/07/28
å½¹ã«ç«‹ã£ãŸ

tips

db

SQL

sort

Performance

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ç‘æ³¢å¤§å¦ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è©±ã‚’ã—ã¦ãã¾ã—ãŸ - kuenishi's blog
ç‘æ³¢å¤§å¦ã®å·å³¶å…ˆç”Ÿã«å‘¼ã°ã‚Œã¦æœ¨ã€é‡‘ã¨æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ç‰¹åˆ¥è¬›ç¾©Dã¨ã„ã†ã‚„ã¤ã«å‚åŠ ã—ã¦ããŸã€‚ã“ã‚“ãªã“ã¨ã«ãªã‚‹ã¨ã¯æ€ã£ã¦ã„ãªã‹ã£ãŸãŒã€ã‚ã‚ã†ã“ã¨ã‹è¬›å¸«å´ã§å‘¼ã°ã‚Œã¦ã—ã¾ã„ã€æ€ãˆã°é ãã¸æ¥ãŸã‚‚ã®ã ã¨æ„Ÿæ…¨æ·±ã„ã€‚ãƒ•ãƒªã¯ã€ŒRiakã¨NoSQLã®è©±ã‚’ã—ã¦ã‚‚ã‚‰ãˆãŸã‚‰ã€ã¨ã„ã†éžå¸¸ã«è‡ªç”±åº¦ã®é«˜ã„å†…å®¹ãªã®ã§ã€ã›ã£ã‹ããªã®ã§åƒ•ã®çŸ¥ã£ã¦ã„ã‚‹ã“ã¨ã‚’å…¨éƒ¨è©°ã‚è¾¼ã‚“ã§è©±ã—ã¦ã‚„ã‚ã†ã¨æ€ã£ãŸã‚‰10åˆ†å»¶é•·ã—ã¦ã•ã‚‰ã«ã‚¹ãƒ©ã‚¤ãƒ‰10æžšåˆ†ãã‚‰ã„ã‚’æ¶ˆåŒ–ä¸è‰¯ã§çµ‚äº†ã¨ã„ã†ã€ã¿ã£ã¨ã‚‚ãªã„æ„Ÿã˜ã«ãªã£ã¦ã—ã¾ã£ãŸã€‚ã‹ãªã‚Šç«¯æŠ˜ã£ã¦ãƒã‚¤ãƒ³ãƒˆã ã‘èª¬æ˜Žã—ãŸã®ã§æµã‚ŒãŒåˆ†ã‹ã‚‰ãšè‹¦åŠ´ã—ãŸæ–¹ã‚‚å¤šã„ã¨æ€ã†ãŒã€ã¾ã‚åƒ•ã®æ€§æ ¼ãªã®ã§è¨±ã—ã¦ã»ã—ã„ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¬›ç¾©ã‚’ã²ã¨é€šã‚Šçµ‚ãˆãŸé™¢ç”Ÿãƒ¬ãƒ™ãƒ«ã‚’æƒ³å®šã—ã¦ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ä½œã£ãŸã®ã§ã€ã‚‚ã—ã‹ã™ã‚‹ã¨ã€ã‚ã‚Šã¨é›£ã—ã‹ã£ãŸã‚Šåˆ†ã‹ã‚Šã«ãã‹ã£ãŸã‚Šã™ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã®ã§ã€ã‚ã‹ã‚‰ãªã„ã“ã¨ãŒã‚ã£ãŸã‚‰é©å½“ã«è³ªå•ã—ã¦ãã ã•ã„ã€‚ è¨€ã„ãŸã‹ã£ãŸã“ã¨ã®æµã‚Œã‚’åƒ•ãªã‚Šã«ã¾ã¨ã‚ã‚‹ã¨
gam-22 2014/02/02
ç‘æ³¢å¤§å¦

db

sql
ãƒªãƒ³ã‚¯
æŽ¥ç¶šæ–‡å—åˆ—ã®æ›¸ãæ–¹ã‚’ã¾ã¨ã‚ã¦ã¿ã‚‹ - ã—ã°ã‚„ã‚“é›‘è¨˜
å†…å®¹ãŒå¤ããªã£ã¦ããŸã®ã§ æŽ¥ç¶šæ–‡å—åˆ—ã®æ›¸ãæ–¹ã‚’ã¾ã¨ã‚ã¦ã¿ã‚‹ï¼ˆ2014 å¹´ç‰ˆï¼‰ - ã—ã°ã‚„ã‚“é›‘è¨˜ ã«ã¦ Azure ã«ã‚‚å¯¾å¿œã—ãŸ 2014 å¹´ç‰ˆã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ æ¯Žå›žã€æœ¬ç•ªç’°å¢ƒã«ã‚¢ãƒƒãƒ—ã™ã‚‹å‰ã«è¿·ã†ã®ãŒ SQL Server ã®æŽ¥ç¶šæ–‡å—åˆ—ã ã£ãŸã‚Šã—ã¾ã™ã€‚ ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã§ã¯åŸºæœ¬çš„ã« SQL Server èªè¨¼ãŒä½¿ã‚ã‚Œã¦ã„ã‚‹ã®ã§æ›¸ãæ›ãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã§ã™ãŒã€Initial Catalog ã¨ã‹ Data Source ã¨ã‹æ„å‘³ãŒåˆ†ã‹ã‚‰ãšã€æ¯Žå›žæ¤œç´¢ã—ã¦ã—ã¾ã†ã®ã§æ›¸ãæ–¹ã‚’ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ SQL Server Compact 4.0 <connectionStrings> <add name="(æŽ¥ç¶šæ–‡å—åˆ—å)" connectionString="Data Source=(ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«å)" providerName="System.Data.SqlServerCe.4.0" /> </
gam-22 2013/06/10
ãã‚Œãª"Initial Catalog ã¨ã‹ Data Source ã¨ã‹æ„å‘³ãŒåˆ†ã‹ã‚‰ãš"

sql

server
ãƒªãƒ³ã‚¯
SQLiteé–¢æ•°ã®ä½¿ã„æ–¹
SQLite3 ã§ã¯é›†è¨ˆã‚„æ—¥ä»˜ã«é–¢ã™ã‚‹ä¾¿åˆ©ãªé–¢æ•°ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯ SQLite3 ã«ã¦ç”¨æ„ã•ã‚Œã¦ã„ã‚‹é–¢æ•°ã®ä½¿ã„æ–¹ã‚’ã‚µãƒ³ãƒ—ãƒ«ã‚’ä½¿ã„ãªãŒã‚‰è§£èª¬ã—ã¾ã™ã€‚
gam-22 2012/02/23
sql
ãƒªãƒ³ã‚¯
SQLite/Ruby - Ruby
è»½é‡ãƒ»é«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹SQLiteã‚’Rubyã‹ã‚‰æ‰±ã†ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Windowsã®å ´åˆ RubyForgeã‹ã‚‰ã€ sqlite3-ruby(sqlite3-ruby-x.x.x.zip)ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã‚’å±•é–‹ã™ã‚‹ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’å®Ÿè¡Œã™ã‚‹ã€‚ ruby setup.rb config ruby setup.rb setup ruby setup.rb install RubyGemsã‚’ä½¿ã†å ´åˆ RubyGemsã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå¾Œã€ æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã€‚ gem install sqlite3-ruby SQLiteã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« SQLite Download Pageã‹ã‚‰ã€ sqlitedll-3_x_x.zipã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã‚’å±•é–‹ã™ã‚‹ã€‚ sqlite.dllã‚’ãƒ‘ã‚¹ã®é€šã£ãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚³ãƒ”
gam-22 2012/01/24
ruby

db

sql

sqlite
ãƒªãƒ³ã‚¯
1