SQLite for Windows Runtime

Free

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

(21) Review
Visual Studio
2015, 2013, 2012, 15
Download (223,582)
9/13/2016
3.14.2
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (21)
Q and A (22)
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
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 | Wed 9:47 AM

不错不错```

by AAKoken | September 03 2012

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


  • Using with C++ Universal app
    1 Posts | Last post August 24, 2016
    • Can we use this with C++ Universal app?
      I am not able to add reference to this SQLite component when developing a universal app with C++ .
      I am pretty new to windows but from what i have read, I would need a winmd build for it to work cross language. All the examples show how to use this with C#, any pointers to how can I use this with C++?
      
      Thanks for all the help !
  • Update Fails
    2 Posts | Last post August 17, 2016
    • Only option for product install is Global and it fails each time because of that.
      I currently have 2012, 2013 and 2015 installed
    • Please try uninstalling the previous version and then installing the new version.  I'm not sure why Visual Studio is raising this exception; however, several people have reported that this clears the issue.
  • Install Error : System.NotImplementedException
    3 Posts | Last post August 17, 2016
    • Updates to latest version and received following error on install:
      
      Install Error : System.NotImplementedException: The method or operation is not implemented.
         at VSIXInstaller.MemorySettingsManager.MemoryWritableSettingsStore.GetBoolean(String collectionPath, String propertyName, Boolean defaultValue)
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.IsCertCheckSkipped()
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.CheckCertificateBeforeUpgrade(InstallableExtensionImpl extension, IInstalledExtension installedVersion, Boolean enforceCertificateCheckForUpgrade)
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.InstallInternal(InstallableExtensionImpl extension, Boolean perMachine, Boolean isNestedExtension, IDictionary`2 extensionsInstalledSoFar, List`1 extensionsUninstalledSoFar, IInstalledExtensionList modifiedInstalledExtensionsList, AsyncOperation asyncOp, UInt64 totalBytesToWrite, UInt64& totalBytesWritten, Boolean enforceCertificateCheckForUpgrade)
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.BeginInstall(IInstallableExtension installableExtension, Boolean perMachine, AsyncOperation asyncOp, Boolean enforceCertificateCheckForUpgrade)
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.InstallWorker(IInstallableExtension extension, Boolean perMachine, AsyncOperation asyncOp, Boolean enforceCertificateCheckForUpgrade)
    • This is a joke, right?  Who releases code with this exception?
      
      08/16/2016 10:30:43 PM - Beginning to install extension to Global Location...
      08/16/2016 10:30:43 PM - Upgrading 'SQLite for Windows Runtime', version 3.13.0 to version 3.14.1.
      08/16/2016 10:30:43 PM - Install Error : System.NotImplementedException: The method or operation is not implemented.
         at VSIXInstaller.MemorySettingsManager.MemoryWritableSettingsStore.GetBoolean(String collectionPath, String propertyName, Boolean defaultValue)
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.IsCertCheckSkipped()
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.CheckCertificateBeforeUpgrade(InstallableExtensionImpl extension, IInstalledExtension installedVersion, Boolean enforceCertificateCheckForUpgrade)
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.InstallInternal(InstallableExtensionImpl extension, Boolean perMachine, Boolean isNestedExtension, IDictionary`2 extensionsInstalledSoFar, List`1 extensionsUninstalledSoFar, IInstalledExtensionList modifiedInstalledExtensionsList, AsyncOperation asyncOp, UInt64 totalBytesToWrite, UInt64& totalBytesWritten, Boolean enforceCertificateCheckForUpgrade)
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.BeginInstall(IInstallableExtension installableExtension, Boolean perMachine, AsyncOperation asyncOp, Boolean enforceCertificateCheckForUpgrade)
         at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.InstallWorker(IInstallableExtension extension, Boolean perMachine, AsyncOperation asyncOp, Boolean enforceCertificateCheckForUpgrade)
      
      
    • Please try uninstalling the previous version and then installing the new version.  I'm not sure why Visual Studio is raising this exception; however, several people have reported that this clears the issue.
  • Installed the extension, now what?
    1 Posts | Last post June 20, 2016
    • So I installed the extension in VS 2015. I can find no documentation on how to use it. There's no reference to it in any of the menus or windows. I don't see it listed in the add reference dialog. It's not available as an Import or Using statement. Do I have to browse for it? If so, how is this any better than installing it to a project via NuGet?  TONS of people have asked for documentation specific for using this extension in Visual Studio. PLEASE follow up and give us a "getting started" document for this Visual Studio extension!
  • How do I get older versions of the install package?
    2 Posts | Last post May 06, 2016
    • 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 3.8.8.1. 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.
    • hi kind sir, did you resolve this issue? i also need to downgrade my extension to 3.8.8.1
  • Support Windows 10 UWP
    2 Posts | Last post September 12, 2015
    • When available for Windows 10 UWP?
    • It works for me by example:
      http://igrali.com/2015/05/01/using-sqlite-in-windows-10-universal-apps/
  • 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)?
1 - 10 of 22 Items