SQLite for Windows Runtime

Free

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

(18) Review
Visual Studio
2012
Download (93,559)
6/4/2014
3.8.5
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (18)
Q and A (16)
Sign in to write a review
Sort by:

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

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

by Tim Heuer | August 10 2012

A solid, reliable embedded database that is efficient and flexible to any app's needs!

Sign in to start a discussion


  • 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.
      https://dev.windowsphone.com/en-us/downloadsdk
      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.
      
      http://blogs.windows.com/windows_phone/b/wpdev/archive/2013/03/12/using-the-sqlite-database-engine-with-windows-phone-8-apps.aspx
    • 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";
          else
              result = "Echec";
      
          return result;
      }
      db.CreateTable<Survey>();
      
      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)";
      command1.ExecuteNonQuery();
      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.
  • Provide SQLite for WinRT as a NuGet Package
    1 Posts | Last post June 14, 2013
    • 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?
  • Relational SQLite
    2 Posts | Last post May 20, 2013
    • Hello, 
      
      does SQLite for WinRT support Foreign Key relations between tables? If yes, can you please demonstrate how to use them?
    • I'm also having the same problem. can anyone help on this?
1 - 10 of 16 Items