busta117 / sqliteunitykit Goto Github PK

This repo is good for us for connecting to sqlite database. But how can we connect to an encryption sqlite database with password

DataTable.Rows [0]["ColumName"] not returning expected value.

Is there a way to use it with Unity WebPlayer? I don't care if the db is hosted on a server or is added in the bundle.

The problem is that WebPlayer doesn't have permissions to write files, so when it's loaded it can't copy the file. Then sqlite3_open needs the local path, and fails if url is passed.

How can I do it?

Thank you for this awesome library!

Hi, how can i get the boolean value in my database column?

SqliteDatabase sqlDB = new SqliteDatabase ("config.db");
string query = "SELECT bookName ,read " + "FROM Books";
var data = sqlDB.ExecuteQuery (query);
bool boolData = data.Rows[0]["read"];

Currently it returns data.Rows[0]["read"] as object so it gives me an error:
Cannot implicitly convert type object' tobool'. An explicit conversion exists (are you missing a cast?)

Hello! First of all great work in developing this kit. When building for WP ou WSA there were some compilation errors though. In respect to function "GetLastWriteTimeUtc(System.String)" which is stated as unsupported by target framework. Any workaround? Thanks in advance for all the help you can give.

Ed

I don't know which compiler options were used to compile SQLite in here to work with Android so I can't repeat it myself at the moment. But I want to suggest to recompile it with adding SQLcipher extension (http://sqlcipher.net/). It supports full db encryption which may be very useful for many users.

nice framework,and i adapt it to my work.
but in my use,i found when i change the db file,it can't occur.
because in the line 100 of SqliteDatabase.cs,
it only check the exist of the DB file,
can you consider the modify of the DB file?
my solution is pick the "check the db exist code" to other place.
because it is not the responsibility of SqliteDatabase to keep the db file synch.

I didnt see this in the Readme. Does this library require Unity Pro to connect ?

I'm using update query "UPDATE Upgrade SET level=2 WHERE id=1" and nothing happend