SQLite4Unity3d

What's this?

When I started with Unity3d development I needed to use SQLite in my project and it was very hard to me to find a place with simple instructions on how to make it work. All I got were links to paid solutions on the Unity3d's Assets Store and a lot of different and complicated tutorials.

At the end, I decided that there should be a simpler way and I created SQLite4Unity3d, a plugin that helps you to use SQLite in your Unity3d projects in a clear and easy way and works in iOS, Mac, Android and Windows projects.

It uses the great sqlite-net library as a base so you will have Linq besides sql. For a further reference on what possibilities you have available with this library I encourage you to visit its github repository.

*Note: SQLite4Unity3d uses only the synchronous part of sqlite-net, so all the calls to the database are synchronous.

If you want to know more about why I created this plugin you can read more here.

The fast track

All you have to do to start using it in your project:

1.Download this zip, extract its content and copy the resulting folder to your Assets/Plugins folder. It contains the dlls that Unity3d will need to access sqlite.
2.Copy the SQLite.cs file into your scripts folder.
3.Don’t forget to copy your SQLite database file in your Assets/StreamingAssets folder if you’re shipping one.
4.You’re done! Now you can get access to your database using sqlite-net. ;P

Example

If you want to try it I've uploaded a small example that you will be able to find in the "Example" folder. Download the folder and open it with Unity3d to give it a try. It contains classes that will help you to start.

 

下载地址：

https://item.taobao.com/item.htm?spm=0.7095261.0.0.49361debcHxzxi&id=567115184650