[B! sqlite] reponã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

repon id:repon

sqliteã«é–¢ã™ã‚‹reponã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

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

sqlite: ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ–°ã—ã„ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã™ã‚‹æ–¹æ³• (è¡¨ã«æ–°ã—ã„åˆ—ã‚’è¿½åŠ ã™ã‚‹) - seclan ã®ã»ãˆã»ãˆãƒ«ãƒ¼ãƒ
sqlite ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ/ã‚µãƒ¼ãƒå½¢æ…‹ã§ãªã„çµ„ã¿è¾¼ã¿ç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã¨ã—ã¦ã€æœ€è¿‘æ³¨ç›®ã‚’æµ´ã³ã¦ã„ã¾ã™ã€‚ã“ã® sqlite ã§ã™ãŒã€ç¾åœ¨ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ sqlite3 ã¨ã€æ˜”ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ sqlite2 ã®äºŒç³»çµ±ãŒã‚ã‚Šã¾ã™ã€‚ã‚‚ã¡ã‚ã‚“ã€ä»Šã‹ã‚‰ä½¿ã†ã«ã¯ sqlite3 ã®æ–¹ãŒã‚ˆã„ã®ã§ã™ãŒã€PHP ãªã©ã§ã¯ã€ã¾ã ã¾ã sqlite2 ãŒä½¿ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã¨ã“ã‚ã§ã€sqlite2 ã§ã¯ã€ä¸€åº¦ä½œã£ãŸè¡¨ã«æ–°ã—ã„åˆ—ã‚’è¿½åŠ ã—ã‚ˆã†ã¨ã—ã¦ã‚‚ã€ãã‚Œã‚’ä¸€ç™ºã§æ“ä½œã§ãã‚‹ SQL ã¯ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ãã“ã§ã€ãã‚Œã‚’è¡Œã†ãŸã‚ã«ã€ä¸€åº¦ä¸€æ™‚çš„ãªè¡¨ã‚’ä½œæˆã—ã€ãã“ã«ç¾åœ¨ã®è¡¨ã‚’ã‚³ãƒ”ãƒ¼ã€æ–°ã—ãåˆ—ãŒè¿½åŠ ã•ã‚ŒãŸè¡¨ã‚’ä½œæˆã€ä¸€æ™‚çš„ãªè¡¨ã‹ã‚‰æ–°ã—ã„è¡¨ã¸ã‚³ãƒ”ãƒ¼ã™ã‚‹ã¨è¨€ã†æ–¹æ³•ã§ã€åˆ—ã‚’è¿½åŠ ã™ã‚‹ã¨è¨€ã†æ–¹æ³•ã‚’ã¨ã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã«ä¾‹ã‚’ç¤ºã—ã¾ã™ã€‚ã“ã®ã‚³ãƒ¼ãƒ‰ã§ã¯ã€a, b, c, ã¨ã„ã† integer åž‹ã®è¡¨ test ã‚’ä½œæˆã—ã€ãã“ã«ã€(
repon 2012/02/02
sqlite

sql
ãƒªãƒ³ã‚¯
ã€SQLiteã€‘ã§é™ç•Œã‚’æ¥µã‚ã‚ï¼ | Choco Soft
ã‚«ãƒ†ã‚´ãƒªãƒ¼ AWS (9) Docker (7) Google (13) kintone (4) Lua (2) Nadesiko3 (16) ODBCæŽ¥ç¶šã«ã¤ã„ã¦ (1) RDBãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° (3) RDBæŽ¥ç¶š (25) Access (4) FireBird (1) MySQL (2) Oracle (2) Paradox (1) Pervasive.SQL (2) PostgreSQL (3) SQL Server (3) SQLite2 (4) SQLite3 (2) Symfoware (1) Server (63) Apache (7) Nginx (8) PHP (8) SSL (16) Tips (8) Windows10 (15) Windows API (16) Wordpress (1) ãªã§ã—ã“ã§ãƒãƒƒãƒå¤–ä¼ (4) ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ (1) ä½œæˆä¸ (2) å¾’ç„¶æ—¥è¨˜
repon 2012/02/01
sqlite

tips
ãƒªãƒ³ã‚¯
ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ãƒ„ãƒ¼ãƒ«Redmineã‚’SQLite3ã§åˆ©ç”¨ã™ã‚‹ã€‚
2012å¹´05æœˆ(1) 2012å¹´02æœˆ(3) 2012å¹´01æœˆ(1) 2011å¹´06æœˆ(2) 2011å¹´05æœˆ(1) 2010å¹´11æœˆ(1) 2010å¹´08æœˆ(1) 2010å¹´07æœˆ(1) 2010å¹´06æœˆ(2) 2010å¹´05æœˆ(2) 2010å¹´01æœˆ(2) 2008å¹´10æœˆ(3) 2008å¹´09æœˆ(7) 2008å¹´08æœˆ(4) 2008å¹´07æœˆ(11) 2008å¹´06æœˆ(1) 2008å¹´04æœˆ(8) 2008å¹´03æœˆ(17) SQlite3ã«CSVãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹éš›ã«ãƒãƒžã£ãŸã€‚ by cm3 (01/24) SQLiteã‚’ç®¡ç†ã™ã‚‹GUIãƒ„ãƒ¼ãƒ« by matuzaki (10/23) SQlite3ã«CSVãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹éš›ã«ãƒãƒžã£ãŸã€‚ by jacob (10/22) google calendarã¨iPhoneã€Thunderbirdã‚’é€£æºã•ã›ã‚‹ã€‚ by ä½•æŸã€‚ (08
repon 2012/01/02
sqlite

redmine
ãƒªãƒ³ã‚¯
ã€PHPã€‘PDOé–¢æ•°ã§SQLiteã‚’ä½¿ã£ã¦ã¿ãŸ(1)ï¼ˆæ ªå¼ä¼šç¤¾ã‚³ãƒã‚¯ãƒ†ã‚£ãƒœã—ã‚ƒã„ã‚“â˜†ã®ãƒ–ãƒã‚°ï¼‰
PHPã®PDOé–¢æ•°ã‚’ä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ PHPãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã‚‚è¨˜è¼‰ã•ã‚Œã¦ã„ã¾ã™ãŒã€ã‚µãƒ³ãƒ—ãƒ«ã¨ç°¡å˜ã«ã¾ã¨ã‚ãŸã‚‚ã®ã‚’æŽ²è¼‰ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯SQLiteã‚’ä½¿ç”¨ã—ã¾ã—ãŸã€‚ ã€DBæŽ¥ç¶šã€‘ PDOã®å¼•æ•°ã«ã€Œ sqlite:ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ã‚¹ ã€ã‚’æŒ‡å®šã—ã¾ã™ã€‚ DBãŒå˜åœ¨ã—ãªã‹ã£ãŸå ´åˆã¯ã€æŒ‡å®šã—ãŸãƒ‘ã‚¹ã«DBã‚’ä½œæˆã—ã¾ã™ã€‚ if (! $db = new PDO("sqlite:test.db")) { die("DB Connection Failed."); } ã€SQLå®Ÿè¡Œã€‘ PDO::query ã§SQLæ–‡ã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ $sql = "CREATE TABLE t_user(" . "user_id integer PRIMARY KEY, " . "name text NOT NULL, " . "mail text" . ")"; if (! $db->query($sql)) { e
repon 2011/08/08
sqlite

php

pdo

sqlite3
ãƒªãƒ³ã‚¯
PHP | PHPã®è¨å®š - SQLiteã¸ã®æŽ¥ç¶š
PHPã‹ã‚‰SQLiteã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã€php.iniã§ã®è¨å®šãŒå¿…è¦ã¨ãªã‚Šã¾ã™(PHPã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦è‰²ã€…ç•°ãªã‚‹ã‚ˆã†ã§ã™ã€‚ã“ã“ã§ã¯PHP5.1.2ã®å ´åˆã§ã™)ã€‚php.iniã‚’ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ãªã©ã§é–‹ã„ã¦é ‚ãã€php_sqlite.dllã¨æ›¸ã‹ã‚ŒãŸç®‡æ‰€ã‚’æ¤œç´¢ã—ã¦ä¸‹ã•ã„ã€‚655è¡Œç›®ä»˜è¿‘ã«ã‚ã‚Šã¾ã™ã€‚ ã€Œextension=php_sqlite.dllã€ã®å…ˆé ã«ã‚»ãƒŸã‚³ãƒãƒ³(;)ãŒä»˜ã„ã¦ã„ã‚‹å ´åˆã¯ä¸Šè¨˜ã®å›³ã®ã‚ˆã†ã«ã‚»ãƒŸã‚³ãƒãƒ³ã‚’å‰Šé™¤ã—ã¦ä¸‹ã•ã„ã€‚(PHP5ä»¥é™ã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚»ãƒŸã‚³ãƒãƒ³ãŒä»˜ã„ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã®ã§ã€å¤–ã—ã¦ä¸‹ã•ã„)ã€‚ æ¬¡ã«ä¸‹è¨˜ã®2è¡Œã‚’ä»˜ã‘åŠ ãˆã¾ã™ã€‚ php_sqlite.dllã‚ˆã‚Šã‚‚å‰ã«è¨˜è¿°ã—ã¦ãŠã„ã¦ä¸‹ã•ã„ã€‚çµæžœçš„ã«php.iniã¯ä¸‹è¨˜ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ php.iniã‚’æ›¸ãæ›ãˆãŸã‚‰ä¸€åº¦Apacheã‚’å†èµ·å‹•ã—ã¦ãŠãã¾ã™ã€‚ãã—ã¦phpinfo()ã‚’å‡ºåŠ›ã™ã‚‹ã‚µãƒ³ãƒ—ãƒ«ãƒšãƒ¼ã‚¸ã‚’å®Ÿè¡Œã—ã¦ã¿ã¾ã™ã€‚ ä¸Šè¨˜
repon 2011/08/08
init

sqlite3

sqlite

php
ãƒªãƒ³ã‚¯
SQLiteã®autoincrementã®å€¤ã‚’ãƒªã‚»ãƒƒãƒˆã™ã‚‹æ–¹æ³• - T-1000ã®æ—¥è¨˜
ç§ãŒãƒªãƒªãƒ¼ã‚¹ã—ã¦ã„ã‚‹Androidã‚¢ãƒ—ãƒªã¯SQLiteã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹äº‹ãŒå¤šãã¦ã€ ç‰¹ã«ã€ãƒ‡ãƒ¼ã‚¿ã®ãƒªã‚¹ãƒˆã‚¢æ©Ÿèƒ½ã‚’ä½¿ã†ã‚‚ã®ã«ã¤ã„ã¦ã¯ã€ ãƒ‡ãƒ¼ã‚¿ã®å…¥ã‚Œæ›¿ãˆå¾Œã«ãƒªã‚»ãƒƒãƒˆã—ã¦ãŠãã¹ãã ã¨æ€ã„ã¾ã™ã€‚ ã¨ã„ã†ã“ã¨ã§ã€èª¿ã¹ã¦ã¿ã‚‹ã¨ã€ä»¥ä¸‹ã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã§ ãƒ†ãƒ¼ãƒ–ãƒ«ã®autoincrementã‚’ã‚¯ãƒªã‚¢ã™ã‚‹äº‹ãŒã§ãã‚‹ã‚ˆã†ã§ã™ã€‚ update sqlite_sequence set seq=1 where name='ãƒ†ãƒ¼ãƒ–ãƒ«å'; ã¾ã‚ã€Androidã§ç™»éŒ²ã™ã‚‹ä»¶æ•°ãŒintã®æ¡ã‚’è¶…ãˆã‚‹ç¨‹ã€ã€ŒäººåŠ›ã§ã€ç™»éŒ²ã™ã‚‹ã“ã¨ãªã‚“ã¦ ãªã„ã¨æ€ã„ã¾ã™ã‘ã©ãã€‚ã€‚
repon 2011/08/05
sqlite3

sqlite
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
repon 2011/08/04
sqlite3ã¯ã“ã®æ–¹æ³•ã§é–‹ãã€‚

sqlite

php

tips

sqlite3
ãƒªãƒ³ã‚¯
ã²ããƒ¡ãƒ¢
BeautifulSoupã¯HTMLè§£æžç”¨ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚htmllib.HTMLParserã‚„HTMLPaprser.HTMLParserã¨é•ã„ã€æ£ã—ããªã„HTMLã‚‚æ‰±ãˆã‚‹ã‚ˆã†ã§ã™ã€‚ã“ã‚Œã‚’ä½¿ã£ã¦Googleã®è¡¨ç¤ºé †ä½ã‚’èª¿ã¹ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚ #!python # vim:fileencoding=utf-8 import re import sys import time import urllib2 import urlparse from BeautifulSoup import BeautifulSoup g_url = "http://www.google.co.jp/search?hl=ja&num=100&q=" next_text = u"æ¬¡ã¸" interval = 3 client_encoding = "cp932" server_encoding =
repon 2011/07/28
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†

ruby

sqlite
ãƒªãƒ³ã‚¯
SQLite/ãƒ¬ã‚³ãƒ¼ãƒ‰æ“ä½œ - ãƒ–ãƒ¼ã‚¹ãƒˆãƒ—ãƒã‚°ãƒ©ãƒ
ã‚³ãƒ¬ã®ç¶šãã§ã™ã€‚ ãƒ¬ã‚³ãƒ¼ãƒ‰ã®è¿½åŠ (INSERT) æ§‹æ–‡ INSERT INTO ãƒ†ãƒ¼ãƒ–ãƒ«å (ã‚«ãƒ©ãƒ å1, ã‚«ãƒ©ãƒ å2) VALUES(å€¤1, å€¤2); æ–‡å—åˆ—ã‚’å…¥åŠ›ã™ã‚‹å ´åˆã¯ã€ã€Œ"ã€ãƒ€ãƒ–ãƒ«ã‚¯ã‚©ãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã§å›²ã† ã‚³ãƒžãƒ³ãƒ‰ã®æœ€å¾Œã«ã¯ã€å¿…ãšã€Œ;ã€ã‚³ãƒãƒ³ã‚’ã¤ã‘ã‚‹ ã‚«ãƒ©ãƒ æ•°ã¨é †ç•ªãŒåŒã˜ã§ã‚ã‚Œã°ã€ã‚«ãƒ©ãƒ åã‚’çœç•¥å¯èƒ½ ä¾‹(æ£å¼ç‰ˆ) sqlite> INSERT INTO t_menu (id, name) VALUES(1, "ã‚¤ãƒã‚´ãƒŸãƒ«ã‚¯"); ã“ã‚Œã§1ã¤ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒè¿½åŠ ã•ã‚Œã¾ã—ãŸã€‚ ä¾‹(çœç•¥ç‰ˆ) sqlite> INSERT INTO t_menu VALUES(2, "ã‚¤ãƒã‚´ãƒ‘ãƒ•ã‚§"); ä¾‹(é€£ç¶šç‰ˆ) sqlite> INSERT INTO t_menu VALUES(3, "ã‚¤ãƒã‚´ã‚¢ã‚¤ã‚¹"); INSERT INTO t_menu VALUES(4, "ã¾ã‚‹ã”ã¨ã‚¤ãƒã‚´"); sqlite>
repon 2011/07/28
sqlite

tips
ãƒªãƒ³ã‚¯
MSN Japan - ãƒ‹ãƒ¥ãƒ¼ã‚¹, å¤©æ°—, ãƒ¡ãƒ¼ãƒ« (Outlook, Hotmail), Bingæ¤œç´¢, Skype
repon 2011/07/28
sqlite

tips
ãƒªãƒ³ã‚¯
[æ‚ªå¾³å•†æ³•ï¼Ÿæ”¯åº—]: auto_incrementã®å€¤ã‚’1ã«æˆ»ã™æ–¹æ³•
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€auto_incrementãªIDã‚’ãƒªã‚»ãƒƒãƒˆã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¿ã¹ã¦ã„ãŸã‚‰ã€MySQLã«ã¤ã„ã¦ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ–¹æ³•ãŒã‚ã£ãŸï¼ˆå‚è€ƒï¼‰ã€‚ MySQLã®å ´åˆ alter table ãƒ†ãƒ¼ãƒ–ãƒ«å auto_increment=1; SQLiteã«ã¤ã„ã¦ã‚‚ã€ã‚ã£ã¦ã‚‹ã®ã‹ã©ã†ã‹çŸ¥ã‚‰ãªã„ã‘ã©ã€ä»¥ä¸‹ã®æ–¹æ³•ã§ãƒªã‚»ãƒƒãƒˆå‡ºæ¥ãŸã€‚ SQLiteã®å ´åˆ update sqlite_sequence set seq=1 where name='ãƒ†ãƒ¼ãƒ–ãƒ«å'; ActiveRecordã‚’æ‹¡å¼µã™ã‚‹ã¨ã—ãŸã‚‰ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ„Ÿã˜ã‹ãªï¼Ÿ RAILS_ROOT/vendor/plugins/auto_increment/init.rb class ActiveRecord::ConnectionAdapters::SQLiteAdapter def set_auto_increment( table_name, va
repon 2011/07/25
sqlite

tips
ãƒªãƒ³ã‚¯
https://net-newbie.com/sqlite/lang.html
repon 2011/07/25
sqlite

ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ

ã¾ã¨ã‚

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

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†

sqlite

tips
ãƒªãƒ³ã‚¯
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ã‚’ãƒ‘ã‚¹ã®é€šã£ãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚³ãƒ”
repon 2011/07/24
sqlite

ruby

tutorial
ãƒªãƒ³ã‚¯
ã€ãƒ¡ãƒ¢ã€‘ SQLite3ã§ã®AUTO INCREMENTã€‚
SQLite2ã§è‡ªå‹•çš„ã«ã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆï¼ˆautoincrementï¼‰ã•ã‚Œã‚‹ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã‚‹ãŸã‚ã«ã¯ã€ãã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«æ¬¡ã®ã‚ˆã†ã«è¨å®šã—ã¦ã‚„ã‚Œã°å®Ÿç¾ã§ãã¾ã—ãŸã€‚ SQLite2ã®å ´åˆ id INTEGER NOT NULL PRIMARY KEY SQLite3ã§ã‚‚åŒæ§˜ã«è¨å®šã—ã¦ã‚„ã‚Œã°ã€è‡ªå‹•çš„ã«ã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã•ã‚Œã‚‹ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ SQLite3ã®å ´åˆ id INTEGER NOT NULL PRIMARY KEY ã¾ãŸã¯ id INTEGER PRIMARY KEY ã—ã‹ã—ã€ã“ã‚Œã‚‰ã¯ã‚ãã¾ã§ã€Œæ“¬ä¼¼çš„ã«ã€autoincrementã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã ã‘ã§ã€ä¾‹ãˆã°MySQLã®AUTO_INCREMENTã¨ã¨ã¯å‹•ä½œãŒé•ã†ã‚ˆã†ã§ã™ã€‚SQLite3ã§ã¯AUTOINCREMENTã®æŒ‡å®šã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã§ã€MySQLã®AUTO_INCREMENTã¨åŒæ§˜ã®å‹•ãã‚’ã™ã‚‹ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œæˆã™ã‚‹ã“
repon 2011/07/24
sqlite

tips
ãƒªãƒ³ã‚¯
1