How can I use SQLite with Unity 3 and iOS Basic?
This is the only solution I’ve found: MonoSQLite | Integration | Unity Asset Store
You can’t use SQLite for iOS Basic because of the .NET socket restriction Unity Basic Policy acknowledges: Powerful 2D, 3D, VR, and AR software for cross-platform development of games and mobile apps.
This asset does not use .NET sockets but plugins to use native Cocoa SQLite which is integrated to the C# code. Therefore, you can write in C# Mono Develop and it will call out native .mm code in the iOS build.
hi, you can use this code its easy to use and its free for your individual use,
use example:
SqliteDatabase sqlDB = new SqliteDatabase(“config.db”);
string query = “INSERT INTO User(UserName) VALUES( ‘Santiago’)”;
sqlDB.ExecuteNonQuery(query);
its so easy… the file “config.db” is necessary exist in the “StreamingAssets” folder
i hate the people who sell this things in the assets store, something easy like this… we need more open sources users ![]()
link — > click here to download
link — > GitHub Repository
works on iOS, MAC OSX, Windows, i dont sure if works on web and android, if you test in that OS tell me the result… thanks
A really dedicated solution as local data storage for your games is Siaqodb see more info here: http://siaqodb.com/?p=482
- easy to use, very simple API
- works on all platforms: PC, Mac, iOS, Android
- works for all Unity3D editions(not needed Pro edition)
- no SQL knowledge needed
- 100% managed code
- small footprint
Just put a siaqodb.dll in your scripts folder and GO!, no extra configuration, no nightmares with unmanaged references
Although the solution from Cristoph sounds good it is a commercial solution whereas iOS already supports SQLite via cocoa so I too would like to know how to integrate SQLite with Unity iOS Basic.
That is 100% managed code, full SQLite3 support, all platforms.
No native dependencies.