Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLiteѧϰ±Ê¼Ç£¨2£©

ÔÙ˵ÔÚlinuxϽ¨Á¢.a ºÍµãso
     µ½ÍøÕ¾ÏÂÔØ sqlite-amalgamation-3.6.22.tar.gz Õâ¸ö°ü£¬·´ÕýÎÒÏÂÁËsqlite3-3.6.22.bin.gz½âѹºó±àÒë²»ÁË¡£
     ½âѹ£¬ÔËÐÐ
    #  ./configure --host=armv5l-linux --prefix=/opt/sqlite3/arm --enable-threadsafe.
    --host=armv5l-linux±íʾËùÓÃµÄÆ½Ì¨¡£Èç¹ûÊÇx86ƽ̨£¬¾Í²»ÓüÓÕâ¾ä»°£¬×¢Òâ,ÎҵıàÒëÆ÷ÊÇarmv5l-linux-gcc,Èç¹ûÓõıàÒëÆ÷ÊÇarm-linux-gcc,ÄÇôӦ¸ÃÊäÈë--host=arm-linux¡£
    --prefix=/opt/sqlite3/arm¡£±íʾ°²×°Â·¾¶£¬Èç¹û²»ÊäÈ룬°²×°Ê±×°µ½Òþ²ØÄ¿Â¼¡£
    --enable-threadsafe.ÔÊÐí¶àÏ̡߳£
    #make
    #make install
    ÔÚarm/libÏÂÓÐÁË*.so ºÍ *.a ÁË£¬ÅäºÏsqlite3.h ,¾Í¿ÉÒÔµ÷ÓÃSQLTEµÄ½Ó¿ÚÁË¡£


Ïà¹ØÎĵµ£º

SQLite ¼ò½é

SQLite ÊÇÒ»¸öʵÏÖÁËÍ걸µÄ£¨self-contained)£¬¿ÉǶÈëµÄ(embeddable)£¬ÁãÅäÖÃ(zero-configuration)µÄSQLÊý¾Ý¿âÒýÇæµÄСÐ͵ÄCº¯Êý¿â¡£Ëü°üº¬ÒÔϵÄÌØµã£º
.
    ÊÂÎñ´¦ÀíÔ­×Ó»¯(atomic)£¬Ò»Ö»¯(consistent)£¬³Ö¾Ã»¯(isolated)£¬¾øÔµ»¯(durable)£¬¼´Ê¹ÊÇÔÚϵͳ±ÀÀ£ºÍµôµçʱ
    ÁãÅäÖ㬲» ......

SQLite 3 ÔÓ¼Ç

1¡¢ÈçºÎµÃµ½×îºó²åÈëÏîµÄ×Ô¶¯Ôö³¤IDÖµ£¿ ¶ÔÓ¦µÄC#´úÂë¶ÎÈçÏ£º

using (SQLiteConnection cn = new SQLiteConnection (¡°data source = Test.db¡±))
{
      cn.Open ();

      SQLiteCommand cmd = new SQLiteCommand ......

SQLite ³õ̽

»¹Êdzõ̽£¬×öµÄÏîĿҪÓõ½ÇáÇɵı¾µØÊý¾Ý¿â£¬ÓÚÊÇÕÒÁË sqlite 3 ÊÔÓÃÖ®£¬»¹²»´í£¬¹»ÇáÇÉ¡£
ÉÏÕâ¶ùÈ¥ÏÂÔØ³ÌÐòºÍ²é¿´Îĵµ£º http://www.sqlite.org/download.html
Õâ»Ø¿ª·¢ÓõÄÊÇ C#£¬ÓÚÊÇÕÒÁ˸ö.NETµÄ¿â Finisar.SQLite £¬µ½Õâ¶ùÈ¥ÔØ http://adodotnetsqlite.sourceforge.net/
Òª¼ÇµÄÒ²²»ÊÇʲô´ó²»Á˵Ķ«Î÷£¬Ê¾ÀýÍøÕ¾É϶ ......

Sqlite Êý¾Ý¿â

1¡¢SQLite¼ò½é
¡¡¡¡SQLiteµÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾ­ÓÐ9¸öÄêÍ·ÁË. SQLiteÒ²Ó­À´ÁËÒ»¸ö°æ±¾ SQLite 3ÒѾ­·¢²¼.
¡¡¡¡SQLiteÊÇÒ»¿îÇáÐ͵ÄÊý¾Ý¿â£¬ÊÇ×ñÊØACIDµÄ¹ØÁªÊ½Êý¾Ý¿â¹ÜÀíϵͳ£¬ËüµÄÉè¼ÆÄ¿±êÊÇǶÈëʽµÄ£¬¶øÇÒĿǰÒѾ­ÔںܶàǶÈëʽ²úÆ·ÖÐʹÓÃÁËËü£¬ËüÕ¼ÓÃ×ÊÔ´·Ç³£µÄµÍ£¬ÔÚǶÈëʽÉ豸ÖУ¬¿ÉÄÜÖ»ÐèÒª¼¸°ÙKµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ