Do you use the official version from this page? Also you don't need / should not use the System.data namespace. You just need System.Data.SQLite. I don't believe that it works in JS and not in C#. Both are compiled to .Net/mono.

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?

• Unity for Linux Stand alone
• Unity for Android
• Unity for iOS (what is the exact .dylib name used by Mono.Data.Sqlite ?)
• Unity for Mac OS X stand alone
• Unity for Windows stand alone (looks like Mono.Data.Sqlite.dll is required by any installer)
• Unity for Flash on Linux, Mac OS X and Windows - does Mono or Unity have a plan for checking for Browser I plementations of HTML5 Web Storage System for WebKit specific or Browsws I General?

that is the best solution for you http://u3d.as/content/orange-tree/sqlite-kit/3ka That is 100% managed code, full SQLite3 support, all platforms. No native dependencies.

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

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.

using System;
using System.Collections.Generic;
using Mono.Data.Sqlite;

public class SqliteWrapper
{
    private SqliteConnection db = null;

    public void OpenDatabase(string path)
    {
        db = new SqliteConnection("URI=file:" + path);
        db.Open();
    }

    public void CloseDatabase()
    {
        db.Close();
        db = null;
    }

    //ugly get/set query method - sigh, yes I did use that...
    public object[] QueryDatabase(string query, bool isReadQuery = false)
    {
        var dbcmd = db.CreateCommand();
        dbcmd.CommandText = query;
        var reader = dbcmd.ExecuteReader();

        object[] output = null;

        if (isReadQuery)
        {
            int current = 0;
            var values = new List<object>();
            while (reader.Read())
                values.Add(reader.GetValue(current++));

            output = values.ToArray();
        }

        return output;
    }
}

By the way, SQLite doesn't require a server of any kind, it really boils down to database file.