Add lsqlite3 into lua extensions

aoxu · on 4 May 2013

Add lua sqlite 3 support into lua extensions.

details

LuaSQLite3 version 0.9.1 stable release
lsqlite3 is a lua module of sqlite3. It requires sqlite3 library.
SQLite version 3.7.16.2 stable release

testing code

local sqlite3 = require("lsqlite3")

local db = sqlite3.open_memory()

db:exec[[
  CREATE TABLE test (id INTEGER PRIMARY KEY, content);

  INSERT INTO test VALUES (NULL, 'Hello World');
  INSERT INTO test VALUES (NULL, 'Hello Lua');
  INSERT INTO test VALUES (NULL, 'Hello Sqlite3')
]]

for row in db:nrows("SELECT * FROM test") do
    print(row.id, row.content)
end

aoxu · on 14 Aug 2013

Memo: only tested for iOS, didn't tested for Android.

yulinho · on 20 Jul

tested for Android 2.3 and 4.3w，work fine.

aoxu added some commits on 4 May 2013

add lsqlite3 into lua extensions 52cdeab
delete OpenFeint e608906

dualface referenced this pull request on 5 May 2013
Closed
本地持久化数据考虑sqlite? #33

aoxu added some commits on 6 Aug 2013

Merge branch 'master' of github.com:dualface/quick-cocos2d-x … 298c908
Merge branch 'master' of github.com:dualface/quick-cocos2d-x into dua… … 8b05604

Merge branch 'master' of github.com:dualface/quick-cocos2d-x into dua… … 76af65c

dualface closed this on 30 Oct 2013

quick下使用sqlite

chukong/quick-cocos2d-x