quick下使用sqlite

Skip to content

https://github.com/chukong/quick-cocos2d-x/pull/36

Sign up Sign in

This repository

• Explore
• Features
• Enterprise
• Blog

•  Star1,009
•  Fork658

chukong/quick-cocos2d-x

New issue

Add lsqlite3 into lua extensions #36

 Closed

aoxu wants to merge 5 commits into chukong:master from aoxu:master

+20,652 −5,295 

•  Conversation 2 
•  Commits 5 
•  Files changed 2,360

Labels

Milestone

 quick-cocos2d-x v...

Assignee

No one assigned

3 participants

aoxu commented 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 added some commits on 4 May 2013

add lsqlite3 into lua extensions52cdeabdelete OpenFeinte608906

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 …298c908Merge branch 'master' of github.com:dualface/quick-cocos2d-x into dua… …8b05604

aoxu commented on 14 Aug 2013

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

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

dualface closed this on 30 Oct 2013

yulinho commented on 20 Jul

tested for Android 2.3 and 4.3w，work fine.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

• Status 
• API 
• Training 
• Shop 
• Blog 
• About

• © 2014 GitHub, Inc. 
• Terms 
• Privacy 
• Security 
• Contact