I have been trying to setup a sqlite server for my game, however I am running into problems with the Using statements (Using System.Data) in particular....Ive read around on old posts and they all say it works in JS but not C# so i was wondering if there is a way to get it to work in C#
Thanks in advanced!
asked May 24 '11 at 10:32 PM
Do you use the official version from this page? Also you don't need / should not use the System.data namespace. You just need
I haven't used it yet, but maybe i give it a try. I only used mysql in the past. SQLite only in C++ ;). But in Unity i wasn't in need of a database (well we have one but on the webserver...).
You mention the location, Mono.Data.Sqlite.dll
On iOS you would use sqllite3.dylib or some .dylib
This is a good question not just for SQlite implementation, but on the use of Dynamic Link Libraries in general.
Does anyone have a comprehensive list for all SQlite implementations for Mono.Data.Sqlite on these Unity3D platforms?
A really dedicated solution as local data storage for your games is Siaqodb see more info here: http://siaqodb.com/?p=482
Just put a siaqodb.dll in your scripts folder and GO!, no extra configuration, no nightmares with unmanaged references
answered Jul 19 '11 at 09:45 AM
Using Sqlite within Unity really isn't that hard, while they can help, I really don't think third-party solutions are required. I'm pretty sure that the System.Data.Sqlite library works with C#, though my own implementation use Mono.Data.Sqlite, I can't remember if I had run into problem or if that's just a coincidence. In any case, Mono.Data.Sqlite.dll can be found in the Unity folder: C:\Program Files\Unity\Editor\Data\Mono\lib\mono\2.0.
That'll make a messy post and uncleaned code, but here's an small wrapper I extracted from a project I have somewhere. Do not use it as actual implementation, its just for you to get an idea of how it works, I've removed all goodies and safe-checks for clarity. Finally, I did modify it a little, but I'm confident it works, I've used SQLite in that manner in several standalone games.
By the way, SQLite doesn't require a server of any kind, it really boils down to database file.
answered Sep 11 '12 at 12:51 AM