SQLite for Windows Runtime


SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

(21) Review
Visual Studio
2015, 2013, 2012
Download (178,404)
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Reviews (21)
Q and A (18)
Sign in to write a review
Sort by:

by Jon Hoffman123 | September 14 2015

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.

by Guinea-Pig | September 07 2015

There is - still - no documentation.

by Jose1966 | September 23 2014

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!!!

Please keep up the good work!!

by PeterSmith-Shipwreck | January 15 2014

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

by Panthera_uncia | December 02 2013

Exactly what I was looking for , Wonderful tool

by Adam Kašpar | September 06 2013

Excelent - thanks a lot to authors

by Scott B. Arbeit | September 04 2013

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.

by Dave Sexton | August 16 2013

by Denis Voituron [Trasys] | July 30 2013

by RogpFreck | May 15 2013

Excellent - small, fast and easily integrated in VS

by Gorzoch Mariusz | May 15 2013

by John Sheridan (Dublin) | May 11 2013

Using it in multiple C++/CX projects. Easy to integrate and use. Very reliable. Performance is very good. Thanks!

by Carsten Siemens | May 02 2013

A good database for single user applications: fast and small.

by putriafebriana93 | February 07 2013

easy to use :D

by e22pii | January 10 2013

by Willy Laroche | January 10 2013

Very good database for Modern UI styles and very easy to use

by WhiteWhisker | October 30 2012

Very helpful when porting an app from iOS/Android, can now share the same database logic across all apps.

by 禅.China | September 26 2012


by AAKoken | September 03 2012

1 - 20 of 21 Items   
Sign in to start a discussion

  • Support Windows 10 UWP
    2 Posts | Last post September 12, 2015
    • When available for Windows 10 UWP?
    • It works for me by example:
  • How do I get older versions of the install package?
    1 Posts | Last post February 05, 2015
    • 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 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.
  • Can I use sqlite in windows phone 8.1 project on VS2013?
    3 Posts | Last post April 15, 2014
    • 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 got the some problem, do you solve it?
    • I try to add sqlite to a Universal app project, but have same problem as mentioned above.
  • Insert
    1 Posts | Last post April 08, 2014
    • Hey Guys,
      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 ^.^
  • Spatialite
    1 Posts | Last post November 14, 2013
    • Does Spatialite work with SQLite in Windows Runtime?
  • Running in Background Task
    1 Posts | Last post October 04, 2013
    • Is there a solution to running SQLite in a background task (from a winmd class)?
  • Support for Visual Studio 2013
    2 Posts | Last post September 03, 2013
    • When it is going to be available to VS 2013.
    • Pre-release is available http://www.sqlite.org/download.html
  • 3.8.0 update
    2 Posts | Last post August 31, 2013
    • What exactly has been added/changed? Where can I view the release notes for this release? 
      Also how can I contact the "SQLite Development Team" whoever they may be?
    • 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
  • Does it support DateTimeOffset?
    1 Posts | Last post August 27, 2013
    • If it doesn't I think it should.
  • Cascade Delete
    1 Posts | Last post June 26, 2013
    • administration. i tried delete cascade but it work only in sqlite manager not in C# code :
      My function
      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";
          return result;
      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.
1 - 10 of 18 Items