Decent enough, but totally spoiled by a complete and utter lack of reasonable documentation.
Example: I copied a SQLite-using project to a new machine. And then the fun began! Where is "this"? Can't find "that"! Need to install "something else".
If there was a simple list of the steps needed to actually make this work, my life would be easier. As it is, just getting it to work is painful enough that I'm seriously considering just making my own binary file format. It's work, but at least I'm not at the mercy of a long chain of "can't find X problems!
It's small, it's fast, it's absolutely wonderful inside of a Windows Store app. I could build my own local storage, or just do settings and key/value, but SQLite is so much nicer. The only nuisance is that you can't do an "Any CPU" compile with it (so if you want to support x86, x64, and ARM you have to include three versions of your app in your submission), but that little bit of extra work to create a good MSBuild input is so worth it.
I am developing some windows phone 8.1 app with the WP8.1 SDK.
But I cannot use sqlite at all.
I cannot find sqilte extension on the vs2013 extensions.
( VS2013 > TOOLS > Extensions and Updates > Online )
Is it not prepared yet?
I used sqilte very well in my W8 tablet project on vs2012.
So I think that I can use same manner.
I have a Problem when i insert an object and will get the autoincremented Primary key i get only the id "1" it is flaggt as autoincremented,unique and Primary key in my objects but the function gives me all time the id"1" back. hope you know what i mean my english isnt really good ^.^
The release notes can be seen here: https://www.sqlite.org/changes.html
The SQLite Development Team can be contacted via the support page on the official web site, here: https://www.sqlite.org/support.html
administration. i tried delete cascade but it work only in sqlite manager not in C# code :
public async Task<string> DeleteSurvey(int SurveyID)
string result = string.Empty;
var db = new SQLite.SQLiteAsyncConnection(App.DBPath);
var survey = await GetSurvey(SurveyID);
var res = await db.DeleteAsync(survey);
if (res > 0)
result = "Success";
result = "Echec";
SQLiteCommand command1 = new SQLiteCommand(db);
command1.CommandText = "create table if not exists SurveyItemGroup";
command1.CommandText += "(ID integer primary key autoincrement not null, IDSurvey integer,";
command1.CommandText += "Number integer, Name varchar(50), FOREIGN KEY(IDSurvey) REFERENCES Survey(ID) ON DELETE CASCADE ON UPDATE CASCADE)";
In C# code it only delete survey table not both (Survey and SurveyItemGroup)
PS: I have the same problem with pragma (pragma foreign_keys=ON;) it works only if i do it sqlite manager.
I am using SQLite for WinRT and it is a fantastic library. However, I have discovered that I cannot build using the TFS cloud build service because it can't find the SQLite SDK. The solution from the TFS team is to create a local directory in the solution and add the appropriate dll's, but this seems really awkward and prone to version problems as the SDK updates.
NuGet provides a mechanism for automatically loading packages that aren't on the build server, and this works for the SQLite wrapper (which is a NuGet package). Is there any plan for releasing this SDK as a NuGet package?