I agree that there is a total lack of documentation however a quick google search for "sqlite for windows runtime tutorial" pulls up a number of good tutorials to get you started. Would of giving it five stars if there was some documentation.
What kind of JOKE is this?? There is absolutely no documentation on how to use this with Visual Studio! All roads lead to the SQLite main web site, that is fine, but where is the documentation that says, if you are using Visual Studio, here is how to get started??
I'm sure this is a great database, it seems to have a great reputation, but it still stinks.
I'm not done, I've come to sqlite web site for a couple of years now because it is touted as an alternative, but STILL there is nothing to get started.
It is obvious that sqlite comes from a linux background, but hek, if you are advertising this for Windows Phone, Windows Runtime, then you should at least have a working recipe to get a basic sample working. Even something as simple as pre-made visual studio solution!!!
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 trying to figure out a problem with our application. It seems like this may be related to the updated version of SQLite since our older release source seem to inherit this problem when we update to 126.96.36.199. I can't figure out how to get the 3.8.6 version of the VSIX package to test if this is part of the issue or not.
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.