SQLiteÖеÄÈ«ÎÄËÑË÷
°ÝGoogleµÄScott Hessͬ־Ëù´Í£¬SQLiteÒ²ÍÆ³öÁËÈ«ÎÄËÑË÷¹¦ÄÜ¡£
SQLiteͨ¹ý½¨Á¢Ò»¸öÐéÄâ±í£¬½«ÊäÈëµÄÎÄ×Ö¸ù¾Ý¿Õ¸ñ¡¢±êµã·ûºÏµÈ¹æÔò½øÐзִʣ¬×éÖ¯³ÉÒ»¿ÃBÊ÷£¬ÒÔ´ËÀ´Ìá¸ßËÑË÷ËÙ¶È¡£
ÈçºÎʹÓÃÕâÒ»¹¦ÄÜ£¬ÐÔÄÜÉÏÈçºÎ£¬´ó¼Ò¸÷×ÔÑо¿È¥°É¡£
ÔÚÕâÀïÎҾͻ㱨һÏÂ×Ô¼ºµÄÑо¿³É¹û£º
1. SQLiteµÄÈ«ÎÄËÑË÷´óÖÂÊǰ´ÕÕ¿Õ¸ñ·Ö´Ê³öÒ»¸ö¸öµÄµ¥´Ê£¬Èç¹ûÎÄÕÂÖÐÓГasdf”ÕâÑùÒ»¸ö´Ê£¬ÄÇô£¬Äã¾ÍÐÝÏëͨ¹ý“sd”À´ÕÒµ½Õâ¶ÎÄÚÈÝÁË£¬ÒòΪËûÊÇÒÔµ¥´Ê×÷Ϊһ¸öµ¥Î»À´×éÖ¯µÄ£»
2. ¼ÈÈ»Êǿոñ·Ö´Ê£¬×ÔÈ»¾Í²»Ö§³ÖÖÐÎÄÁË£¬³ý·ÇÄãÊǰÑÒ»¸öÎÄÕÂÿ¸ö´Ê¶¼Óÿոñ»òÕß±êµã·ûºÅ·Ö¿ª£»
3. SQLiteÌṩÁË¿É×Ô¶¨ÒåµÄ´Ê·¨·ÖÎöÆ÷£¬¾ßÌåµÄÓ÷¨¿´Îĵµ£»
4. Ñо¿ÏÂporterÕâÒ»Óï·¨·ÖÎöÆ÷£¬²Î¿´Ô´ÂëÎļþ“fts3_porter.c”£¬¶ÔÓÚÒ»¸öµ¥´ÊµÄ¶àÖÖ´ÊÐΣ¬°´ÕÕÓ¢ÎĵĻù±¾¹æ·¶£¬½«¶à¸ö´ÊÐÎͳһΪһ¸ö»ù±¾µ¥´Ê£¬¾ß±¸ÁËÒ»¶¨ÓïÒåÉϵÄÖ§³Ö¡£
×ܽáÀ´Ëµ£¬Ä¿Ç°ÊÇûÓÐÌá¹©ÕæÕýÓïÒåÉϵķִʣ¬Õâ¾ÍÒª¿¿¸÷λ¿´¹Ù¶à¶àŬÁ¦ÁË£¬ºÇºÇ
¹ÙÍø¹ØÓÚÈ«ÎÄËÑË÷µÄÁ´½Ó£ºhttp://www.sqlite.org/fts3.html
Ïà¹ØÎĵµ£º
ÏÂÔØ´úÂë
È¡µÃÒ»·Ý¶þ½øÖÆ¿½±´, »òÕßÊÇÔ´´úÂë²¢×Ô¼º±àÒëËü. ¹ØÓÚ ÏÂÔØÒ³£¨download£© µÄ¸ü¶àÐÅÏ¢.
´´½¨Ò»¸öÐÂÊý¾Ý¿â
ÔÚ DOS ÃüÁîÐÐÏÂ, ÊäÈë: "sqlite3 test.db". ½«´´½¨Ò»¸öеÄÊý¾Ý¿âÎļþÃû½Ð"test.db". (Äã¿ÉÒÔʹÓò»Í¬µÄÃû×Ö)
ÊäÈë SQL ÃüÁîÔÚÌáʾ·ûÏ´´½¨ºÍдÈëеÄÊý¾Ý.
д³ÌÐòʹÓà SQLite
ÏÂÃæÊÇÒ»¸ö¼òµ¥µ ......
1. Ô´´úÂëµÄ»ñÈ¡
sqliteÊÇÒ»¸ö¹¦ÄÜÇ¿´ó¡¢Ìå»ýСÔËËãËÙ¶È¿ìµÄǶÈëʽÊý¾Ý¿â£¬²ÉÓÃÁËÈ«CÓïÑÔ·â×°£¬²¢ÌṩÁ˰ËÊ®¶à¸öÃüÁî½Ó¿Ú£¬¿ÉÒÆÖ²ÐÔÇ¿£¬Ê¹Ó÷½±ã¡£
ÏÂÔØµØÖ·£ºhttp://sqlite.org/download.html
sqliteÔ´´úÂ룺sqlite-3.6.17.tar.gz
2. sqliteÒÆÖ²µ½x86 for linu ......
ʹÓð汾£ºsqlite-3.6.14.2
ÏÂÔØµØÖ·£ºhttp://www.sqlite.org/sqlite-3.6.14.2.tar.gz
Ê×ÏȲο¼readmeµÄÌáʾ£º
“
tar xzf sqlite.tar.gz ;# Unpack the source tree into "sqlite"
mkdir bld &nbs ......
1.ÔÚSQLiteÖвåÈ뵱ǰʱ¼ä,±äÁ¿¶¨Òå²»Óöà˵
char *sql = sqlite3_mprintf("insert into Log VALUES(datetime('now', 'localtime'), '%q', '%q')", cUser, cLogContent);
int ret = sqlite3_exec(Sqlite3, sql, NULL, NULL, &pErrMsg);
ÒÔÔ·ÝΪµ¥Î»Í³¼Æ³ö·ûºÏµ±Ç°Ô·ݵļǼ, TimeΪÊý¾Ý¿âÖÐ×Ö¶ÎÃû:
char *sql = s ......