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

ttakezawa id:ttakezawa

sqliteã«é–¢ã™ã‚‹ttakezawaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã‚¹ã‚¯ãƒ¼ãƒ«ã‚¬ãƒ¼ãƒ«ã‚¹ãƒˆãƒ©ã‚¤ã‚«ãƒ¼ã‚ºã® å†…è£½ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚¨ãƒ³ã‚¸ãƒ³
è¿‘å¹´ã€ãƒã‚¤ã‚¹ãƒšãƒƒã‚¯ãªã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã€é«˜å“è³ªãªãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãŒæ™®åŠã—ã€ãã‚Œã«ã‚ˆã‚Šãƒ¢ãƒã‚¤ãƒ«ã‚²ãƒ¼ãƒ ã®åˆ¶ä½œæ‰‹æ³•ã‚„ãã‚Œã‚’å–ã‚Šå·»ãç’°å¢ƒã‚‚å¤‰åŒ–ã—ã¦ãã¾ã—ãŸã€‚ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹ã§ã¯ã€ãã®ã‚ˆã†ãªç’°å¢ƒã®å¤‰åŒ–ã«å¯¾ã—ã¦ã€æ—¥ã€…æ–°ãŸãªãƒãƒ£ãƒ¬ãƒ³ã‚¸ã‚’ã—ç¶šã‘ã¦ã„ã¾ã™ã€‚ãã—ã¦ã€ã“ã®ã‚ˆã†ãªã‚¹ãƒ”ãƒ¼ãƒ‰æ„Ÿæº¢ã‚Œã‚‹æ¥ç•Œã®æµã‚Œã«ã¯ã€ä¼šç¤¾ã®æž ã‚’è¶…ãˆãŸæŠ€è¡“æƒ…å ±ã®å…±æœ‰ã€äº¤æµãŒæ¬ ã‹ã›ãªã„ã¨æ„Ÿã˜ã¦ãŠã‚Šã¾ã™ã€‚ ãã“ã§ã“ã®å¤ã€ç¤¾å†…ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ»ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ãƒ‡ã‚£ãƒ¬ã‚¯ã‚¿ãƒ¼ã«ã‚ˆã‚‹æœ€æ–°ã®ãƒ¢ãƒã‚¤ãƒ«é–‹ç™ºã®æŠ€è¡“æƒ…å ±ã‚„ç¤¾å†…ãƒ¢ãƒã‚¤ãƒ«ã‚¨ãƒ³ã‚¸ãƒ³ã€é–‹ç™ºç§˜è©±ã«ã‚ˆã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’ãƒ¡ã‚¤ãƒ³ã«ã€ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹ ãƒ¢ãƒã‚¤ãƒ« ã‚ªãƒ¼ãƒ—ãƒ³ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’é–‹å‚¬ã™ã‚‹é‹ã³ã¨ãªã‚Šã¾ã—ãŸã€‚ã¾ãŸã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®å¾Œã¯ç™»å£‡ã™ã‚‹å¼Šç¤¾ã‚¹ã‚¿ãƒƒãƒ•ã¨ç›´æŽ¥ãƒ‡ã‚£ã‚¹ã‚«ãƒƒã‚·ãƒ§ãƒ³ã‚„ãƒ•ãƒªãƒ¼ãƒˆãƒ¼ã‚¯ãŒã§ãã‚‹å ´ã‚’è¨ã‘ã¦ãŠã‚Šã¾ã™ã€‚ã“ã®æ©Ÿä¼šã«ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹ã¨ã„ã†ä¼šç¤¾ã«ã¤ã„ã¦ã‚‚ã€ã‚ˆã‚Šè©³ã—ãçŸ¥ã£ã¦é ‚ã‘ã‚Œã°å¹¸ã„ã§ã™ã€‚ ãƒžãƒãƒ¼ã‚¸ãƒ£ãƒ¼ãƒ»ãƒ†ã‚¯
ttakezawa 2014/07/17
game

iphone

android

c++

sqlite
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ Cassandraã€Mongodbã€SQLiteã€H2ã€MySQLã€Postgres - cypher256's blog
ä¸‹è¨˜ã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒè‰¯ã•ã’ãª SQLite ã‚’ä½¿ç”¨äºˆå®šã§ã™ãŒã€ã‚‚ã£ã¨é€Ÿã„ã‚‚ã®ãŒç„¡ã„ã‹ç¢ºèªã®ãŸã‚ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚SQL åˆ©ç”¨å‰æã§ã™ãŒã€NoSQL ãŒåœ§å€’çš„ãªæ€§èƒ½ã‚’å‡ºã™å ´åˆã¯æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã§ KVS ã‚‚ç¢ºèªã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ä»¶æ•°ã¯ 1 å„„ä»¶ç¨‹åº¦ã€JDBC SQL åˆ©ç”¨å¯èƒ½ INSERTã€UPDATE ã¯ãƒãƒƒãƒ SELECT ã¯ä¸»ã‚ãƒ¼ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã‚’é‡è¦– å°†æ¥ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®ãŸã‚ã®åˆ†æ•£ã¯ã‚ã‚Šãˆã‚‹ãŒã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã§é…ã„ã®ã¯ã ã‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ è¨ˆæ¸¬ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å ã‚¿ã‚¤ãƒ— å½¢æ…‹ è©•åˆ¤ è¨ˆæ¸¬ã«ã¤ã„ã¦ã®å‚™è€ƒ SQLite RDB çµ„ã¿è¾¼ã¿ â€»2 ãŠã‚‚ã¡ã‚ƒã€Androidæ¨™æº– JDBCæ“ä½œ â€»1 H2 RDB çµ„ã¿è¾¼ã¿ â€»2 çµ„ã¿è¾¼ã¿æœ€é€Ÿ JDBCæ“ä½œ â€»1 Derby RDB çµ„ã¿è¾¼ã¿ â€»2 Javaæ¨™æº–ã§
ttakezawa 2012/10/14
mysql

cassandra

postgresql

sqlite

mongodb

performance

redis
ãƒªãƒ³ã‚¯
å°‘ã—ç›®å…ˆã‚’å¤‰ãˆã¦ä»–ã®ã“ã¨ã‚’ - æ™‚è¨ˆå±‹ã®é›‘è¨˜å¸³
èª¿ã¹ã¦ã¿ãŸï½¡*1 è³‡æ–™ãŒè‡´å‘½çš„ã«å°‘ãªã„FTS3ã«Custom tokenizerã‚’å¤–éƒ¨æ‹¡å¼µã¨ã—ã¦å–°ã‚ã›ã‚‹æ–¹æ³•ã¨ã‹ã‚’ã¼ã¡ã¼ã¡ï½¡ ã¾ãšã¯æœ€åˆã«ï½¤ è¨€è‘‰ã®å®šç¾©ã‚’ï½¡ï½¡ï½¡ FTS3 SQLiteã«å®Ÿè£…ã•ã‚Œã¦ã„ã‚‹å…¨æ–‡æ¤œç´¢ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ï½¡ç¾åœ¨ãƒ‰ãƒ©ãƒ•ãƒˆï½¡ Tokenizer å…¨æ–‡æ¤œç´¢ã®Indexingã‚’è¡Œã†éš›ï½¤ã©ã®ã‚ˆã†ãªè¦å‰‡ã§Indexã‚’ä½œæˆã™ã‚‹ã‹ãŒè©°ã¾ã£ã¦ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«*2 Source Tokenizerã«æ¸¡ã£ã¦ããŸãã®ã‚‚ã®ã®æ–‡å—åˆ—ï½¡ã“ã‚Œã‚’Tokenizerã§Tokenã«åˆ†è§£ã™ã‚‹ï½¡ Token Sourceã«æ¸¡ã£ã¦ããŸæ–‡å—åˆ—ã‚’åˆ†è§£ã—ãŸè¦ç´ *3 ä½•ã‚‚ã—ãªã„ã§å‡ºæ¥ã‚‹ã“ã¨ï½¡ ã¯ã˜ã‡ã‚“ã˜ã‡ã‚“ãªã‹ã£ãŸã‚Šã™ã‚‹*4ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ®µéšŽã§ï½¤FTS3ãŒæœ‰åŠ¹ã«ãªã£ã¦ãªã„ã¨ï½¤ãã‚‚ãã‚‚ã‹ã‚‰ã—ã¦ä½¿ãˆãªã„ï½¡*5 ã˜ã‚ƒã‚ï½¤ã©ã®ã‚ˆã†ã«ä½¿ã†ã®ã‹ ã¨ã„ã†ã¨ï½¤ä»¥ä¸‹ã®é€šã‚Šï½¤åŸºæœ¬çš„ã«ä»®æƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã—ã¦ä½œæˆã™ã‚‹ï½¡*6 CREATE VIRTUAL TABL
ttakezawa 2009/09/18
sqlite

library
ãƒªãƒ³ã‚¯
SQLite Full Text Search with MeCab - mynote
ã¯ã˜ã‚ã«â€ SQLiteã®å…¨æ–‡æ¤œç´¢ã®æ‹¡å¼µFTSã¯ã€ã¾ã å®Ÿé¨“çš„ãªæ®µéšŽã§fts1, fts2ã¨ä½œã£ã¦ã¯ç ´æ£„ï¼ˆï¼Ÿï¼‰ã—ã¦ãã¦ã€ä»Šã¯fts3ãŒæœ€æ–°ã®ã‚ˆã†ã§ã™ã€‚(sqlite3.5.1ï¼‰ã€‚ãŸã ã—ã€ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ¸ˆã¿ãƒã‚¤ãƒŠãƒªã®é…å¸ƒã¯æ¢ã‚ã¦ã—ã¾ã£ãŸã‚ˆã†ã§ã™ã€‚å®Ÿé¨“æ®µéšŽãªã®ã§æ¬²ã—ã„äººã¯è‡ªåˆ†ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¦ãâ™¥ã¿ãŸã„ãªã€‚ã“ã®ftsã§æ—¥æœ¬èªžãŒä½¿ãˆãªã„ã¨ã‹è‰²ã€…è¨€ã‚ã‚Œã¦ã„ã‚‹ã®ã«åŠ ãˆã¦ã€ã¡ã‚‡ã£ã¨ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ã‚’ã§ã£ã¡ä¸Šã’ã‚‹ã®ã«å¿…è¦ã«ãªã‚Šãã†ãªé›°å›²æ°—ãªã®ã§ã€æ—¥æœ¬èªžã§ã‚‚ftsãŒä½¿ãˆã‚‹ã‚ˆã†ã«ã—ã¦ã¿ã¾ã—ãŸã€‚ â†‘ ãã‚‚ãã‚‚ã®å‹•æ©Ÿâ€ ã€ŽSQLite ã®å…¨æ–‡æ¤œç´¢ã‚’ Python ã‹ã‚‰ä½¿ã£ã¦ã¿ã‚‹ (3)ã€ã‚’èªã‚“ã ã€‚ã“ã“ã§ftsã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è‹±æ–‡ç”¨ã®tokenizerï¼ˆç©ºç™½ã§å˜èªžã‚’åŒºåˆ‡ã‚‹ï¼‰ã§æ—¥æœ¬èªžã‚’ç„¡ç†ã‚„ã‚Šä½¿ã†ãŸã‚ã«MeCabã‚’ä½¿ã£ã¦åˆ†ã‹ã¡æ›¸ãã‚’ã—ã¦ã€ãã®æ–‡å—åˆ—ã‚’æŒ¿å…¥ã—ã€å–ã‚Šå‡ºã—ãŸã‚ã¨ã«é€£çµã¨ã‹ã—ã¦ãŸãƒ»ãƒ»ãƒ»ã€‚èª°ã‚‚çŸ¥ã‚‰ãªã„ã‚ˆã†ã ãŒã€å®Ÿã¯fts2
ttakezawa 2009/09/16
sqlite

fulltextsearch
ãƒªãƒ³ã‚¯
TkSQLite - mynote
Downloadâ€ Old versions Tcl script http://reddog.s35.xrea.com/software/tksqlite-0.3.2.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.1.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.2.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.3.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.4.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.5.zip http://reddog.s35.xrea.com/software/
ttakezawa 2008/10/08
windows

linux

sqlite
ãƒªãƒ³ã‚¯
sarabande.info
This domain name has been registered with Gandi.net. It is currently parked by the owner.
ttakezawa 2008/03/06
chm

sqlite
ãƒªãƒ³ã‚¯
ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ãƒ–ãƒã‚°ï½œç„¡æ–™ã§è±Šå¯Œãªæ©Ÿèƒ½ãŒå……å®Ÿ
çµµæ—¥è¨˜ ã‚°ãƒ«ãƒ¡ ãƒ©ã‚¤ãƒ•ã‚¹ã‚¿ã‚¤ãƒ«ãƒ»æš®ã‚‰ã— ãƒšãƒƒãƒˆ æ—…è¡Œãƒ»æµ·å¤– æ—¥è¨˜ ãƒ‹ãƒ¥ãƒ¼ã‚¹ ã‚¹ãƒãƒ¼ãƒ„ ãƒ“ã‚¸ãƒã‚¹ãƒ»çµŒæ¸ˆ è¶£å‘³ãƒ»å‰µä½œ éŸ³æ¥½ æ›¸ç±ãƒ»é›‘èªŒ æ¼«ç”»ãƒ»ã‚¢ãƒ‹ãƒ¡ ã‚²ãƒ¼ãƒ å—é¨“ãƒ»å¦æ ¡ ãƒ˜ãƒ«ã‚¹ãƒ»ãƒ“ãƒ¥ãƒ¼ãƒ†ã‚£ ITãƒ»å®¶é›» å¦å•ãƒ»ç§‘å¦ ã¾ã¨ã‚
ttakezawa 2007/09/06
ruby

database

active_record

nlp

sqlite
ãƒªãƒ³ã‚¯
1