/SQLiteUnityKit

Framework to connect to SQLite database from Unity for iOS, Android, MAC , Windows

Primary LanguageC#

#SQLiteUnityKit

Framework to connect to SQLite database from Unity for iOS, Android, MAC and Windows

***** please don't use this code for sell an asset *****

##change log ###v 2.0 changes:

  • Refactored to use System.Data-like structures. This should help with existing DB code
  • Added unit tests
  • Removed Unity-specific features, you'll need to copy DB files again
  • TODO: Update this README...

###v 1.1 changes:

  • Add android support (read below how to do)
  • sqlite libs version for android (v3.3.17) It has been compiled with the android native development kit release 9 and the target arm is ARMv5TE (which should cover most android devices).
  • change all DllImport from internal to private

###How to Use:

SqliteDatabase sqlDB = new SqliteDatabase(“config.db”);
string query = “INSERT INTO User(UserName) VALUES( ‘Santiago’)”;
sqlDB.ExecuteNonQuery(query);

####IMPORTANT: the file “config.db” is necessary exist in the “StreamingAssets” folder.

If this folder does not exist create it in the root folder of your Unity project.



###to execute a query this libs have 2 simple methods:

void ExecuteNonQuery(string query)  //for SQL query like UPDATE, DELETE....
Dictionary ExecuteQuery(string query)  //for SQL query like SELECT ....

##for Android compatibility:
Copy the file "libsqlite3.so" (sqlite libs for android) into the folder "Assets/Plugins/Android" it's important copy that otherwise it will not be included to the final apk package.

follow this simple steps and you can get full compatibility with android.

credits


####feedback?