SQLite for Windows Runtime (Windows 8.1)

Free

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

(8) Review
Visual Studio
2015, 2013, 15
Download (113,146)
9/13/2016
3.14.2
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (8)
Q and A (17)
Sign in to write a review
Sort by:

by nol__b | May 13 2016

This has worked out really well for me. One trick that made all the difference was using the method described in the below thread. I agree with others that the documentation could be better but because how well sqlite performs for my app, I am still giving it 5 stars.

http://stackoverflow.com/questions/30056631/calling-sqlite3-setdirectory-gives-a-system-accessviolationexception-on-windows/30711403#30711403

by ClumzyPilot | September 04 2015

Appalling documentation
For those wondering what the hell is this file, installing it is equivalent to getting it from "Extensions in updates" outlined in this video. You also need to restart visual studio for changes to take effect;
https://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Using-SQLite-in-Windows-Store-Apps

by BatRocchia | January 29 2015

Unable to find the extension in the reference list for a windows 8.1 project

by HaimingXu | November 17 2014

Hope it will work fine

by Darrell Norton | February 06 2014

Please update the Supports to include Visual Studio 2013. This plugin does not show up from within Visual Studio since the project does not explicitly say it supports Visual Studio 2013.

by PeterSmith-Shipwreck | January 04 2014

An OK database (I mean -- how interesting is a database? It's some tables, and I can do SQL with them). However, they've spoiled all of the work they did (making a nice VSIX package, making it work with runtime, getting into this site, etc) by the appalling documentation.

Seriously. I've been looking and looking at the sqlite.org site (the "get more information!" link), and there's seemingly no windows documentation at all. What I expected was at least a "five minute into" that would explain little things like: what is a VSIX file? where do I find the thing it's installed? How do I use it from C#?.

At this point, even though I've used Sqlite in the past, and I've set up my project to use an existing Sqlite database file which I've already created and filled with data, I'm seriously wondering if creating my own binary formated file would be faster to create than trying to figure out how to use this package. And that's just plain sad.

A few hours of work creating a how to, and making that how-to findable, would turn this package into something I could recommend.

by Aerinai | December 28 2013

This... is... simply... amazing. With only minimal tweaks (very easy to do!) this is by far the most comprehensive and simplest way to hook up a SQLite DB to a Windows 8 App EVER... Great job guys!

by TNJMAN | September 03 2013

Thanks for this pre-release. I have been toying with this. I look forward to the final stable release. Please keep us posted!

Sign in to start a discussion


  • CannotOpen exception if database attached with special characters in the path
    1 Posts | Last post September 19, 2016
    • The SqliteException "CannotOpen" is thrown if I want to attach second database and if the path contains special characters (e.g. 'š'). Windows store app local folder contains username that is why special characters can occur very often in a path of database file.
      
      I suppose the problem is based on different encoding (UTF-8 in SQLite, UTF-16 in .Net) but I haven't managed to resolve it. Sqlite contains methods for opening database in UTF 16 (sqlite3_open16). But there is no such a method for SQL statements.
      
      string dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "sqlite1.db");
      string dbPath2 = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "sqlite2.db");
      
      using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLitePlatformWinRT(), dbPath))
      {                
          var cmd = conn.CreateCommand("ATTACH '" + dbPath2 + "' AS second;");
          cmd.ExecuteNonQuery();   // -> it throws "CannotOpen" exception if dbPath2 contains special characters
      }
  • Anniversary Edition
    5 Posts | Last post August 24, 2016
    • Hi
      
      Getting the following error for all 3 SQLite package I have installed (Windwos 8.1/Universal Windows Platform and Windows Phone)
      
      09-Aug-16 13:54:09 - Microsoft VSIX Installer
      09-Aug-16 13:54:09 - -------------------------------------------
      09-Aug-16 13:54:09 - Initializing Install...
      09-Aug-16 13:54:09 - Extension Details...
      09-Aug-16 13:54:09 - 	Identifier         : SQLite.UWP.2015
      09-Aug-16 13:54:09 - 	Name               : SQLite for Universal Windows Platform
      09-Aug-16 13:54:09 - 	Author             : SQLite Development Team
      09-Aug-16 13:54:09 - 	Version            : 3.14.0
      09-Aug-16 13:54:09 - 	Description        : SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
      09-Aug-16 13:54:09 - 	Locale             : en-US
      09-Aug-16 13:54:09 - 	MoreInfoURL        : http://www.sqlite.org/
      09-Aug-16 13:54:09 - 	InstalledByMSI     : False
      09-Aug-16 13:54:09 - 	SupportedFrameworkVersionRange : [0.0,2147483647.2147483647]
      09-Aug-16 13:54:09 - 
      09-Aug-16 13:54:09 - 	SignatureState     : Unsigned
      09-Aug-16 13:54:09 - 	Supported Products : 
      09-Aug-16 13:54:09 - 		Microsoft.ExtensionSDK
      09-Aug-16 13:54:09 - 			Version : 
      09-Aug-16 13:54:09 - 
      09-Aug-16 13:54:09 - 	References         : 
      09-Aug-16 13:54:09 - Signature Details...
      09-Aug-16 13:54:09 - 	Extension is not signed.
      09-Aug-16 13:54:09 - 
      09-Aug-16 13:54:09 - Searching for applicable products...
      09-Aug-16 13:54:09 - Found installed product - Microsoft Visual Studio Community 2015
      09-Aug-16 13:54:09 - Found installed product - Microsoft Visual Studio 2015 Shell (Integrated)
      09-Aug-16 13:54:09 - Found installed product - Global Location
      09-Aug-16 13:54:10 - The extension will be upgraded from version 3.13.0.
      09-Aug-16 13:54:11 - The following target products have been selected...
      09-Aug-16 13:54:11 - 	Global Location
    • 9-Aug-16 13:54:11 - Beginning to install extension to Global Location...
      09-Aug-16 13:54:11 - Upgrading 'SQLite for Universal Windows Platform', version 3.13.0 to version 3.14.0.
      09-Aug-16 13:54:11 - 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)
      
    • Same here.
    • With version 3.14.1 still the same problem...
    • Same here for 3.14.1 of both WP 8.1 and WinRT.
  • SEE Extension
    1 Posts | Last post April 18, 2016
    • Hi, 
      
      I tried to compile sqlite with the SEE extension, described here
      https://www.sqlite.org/see/doc/trunk/www/win8phone.wiki
      But the docu seems to be outdated, as it is for 8.0 not 8.1 and when I try it, I get errors like
      Microsoft (R) Program Maintenance Utility Version 11.00.60610.1
      Copyright (C) Microsoft Corporation.  All rights reserved.
      
              link.exe /DEBUG  /NOLOGO /APPCONTAINER  /DLL /DEF:sqlite3.def /OUT:sqlite3.dll sqlite3.lo
         Creating library sqlite3.lib and object sqlite3.exp
      sqlite3.lo : error LNK2019: unresolved external symbol _sqlite3_key_v2 referenced in function _openDatabase
      sqlite3.lo : error LNK2019: unresolved external symbol _sqlite3_rekey_v2 referenced in function _sqlite3Pragma
      sqlite3.lo : error LNK2019: unresolved external symbol _sqlite3_activate_see referenced in function _sqlite3Pragma
      sqlite3.lo : error LNK2019: unresolved external symbol _sqlite3CodecAttach referenced in function _attachFunc
      sqlite3.lo : error LNK2019: unresolved external symbol _sqlite3CodecGetKey referenced in function _attachFunc
      sqlite3.dll : fatal error LNK1120: 5 unresolved externals
      
      could anybody help?
      
      regards
      Markus
  • SQLite WinRT 3.10.1 - System.AccessViolationException
    1 Posts | Last post January 22, 2016
    • I am using SQLite WInRT 3.10.1 in my Windows Store App. 
      
      A timer keeps updating & reading the sqlite using SQLiteAsyncConnection. 
      Also, upon clicking a button & successful server communication, sqlite is updated using SQLiteConnection. 
      
      So, SQLite is updated/read in parallel and also with 2 different SQLiteAsyncConnection & SQLiteConnection. 
      
      Under this scenario, the following System.AccessViolationException is thrown: 
      
      Exception Info: System.AccessViolationException 
      Stack: 
      at SQLite.SQLite3.Changes(IntPtr) 
      at SQLite.SQLiteCommand.ExecuteNonQuery() 
      at SQLite.SQLiteConnection.Execute(System.String, System.Object[]) 
      at SQLite.SQLiteAsyncConnection+<>c__DisplayClass1d.<ExecuteAsync>b__1c() 
      at System.Threading.Tasks.Task`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].InnerInvoke() 
      at System.Threading.Tasks.Task.Execute() 
      at System.Threading.Tasks.Task.ExecutionContextCallback(System.Object) 
      at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) 
      at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) 
      at System.Threading.Tasks.Task.ExecuteWithThreadLocal(System.Threading.Tasks.Task ByRef) 
      at System.Threading.Tasks.Task.ExecuteEntry(Boolean) 
      at System.Threading.Tasks.Task.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() 
      at System.Threading.ThreadPoolWorkQueue.Dispatch() 
      at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback() 
      
      How to resolve this ? 
      
      Grateful Thanks in Advance..
      
  • SQLITE not working after deployment
    2 Posts | Last post November 13, 2015
    • Hi! My application and sqlite runs perfectly when i debug it using visual studio however after publishing the app on store my application is not working due to sqlite failure. SQLITE is not working after deployment. Please help.
      
    • Is there a specific error message?  Perhaps somebody on the SQLite mailing list can answer better?  Please see "https://www.sqlite.org/support.html" for more information.
  • Where do I find older versions of this extension
    2 Posts | Last post July 10, 2015
    • I have other nugget packages that are looking for 3.8.5.  Where can I find the older extension that is linked to that?
    • You can download it from the official site https://www.sqlite.org/download.html. They have a naming convention, so based on the version you want your link should be: https://www.sqlite.org/2014/sqlite-winrt81-3080500.vsix
  • Windows Phone 8.1 UAP
    1 Posts | Last post June 13, 2015
    • I take it this still dont work in UAP on Windows ten tried to install and still nothing showing up under extensions to select??/
  • x86 support
    2 Posts | Last post June 01, 2015
    • When I run App in x86 It crases with BadImageFormatExceptio, The ext. Is only working in x64 mode.
      
      How can I fix it?
    • Hi Juan, i'm having the same issue with this extension for x86. Did you find a workaround for it?
      
      Thanks 
  • Win 10 UAP?
    3 Posts | Last post May 14, 2015
    • Will there be a version for Win 10 UAP soon? Even an unsupported build that would unblock me would be super helpful.
    • I also interest when pack for Windows 10 UWP will be available?
    • SQLite for UAP available here https://visualstudiogallery.msdn.microsoft.com/4913e7d5-96c9-4dde-a1a1-69820d615936
  • Viewing Database Physically
    1 Posts | Last post April 02, 2015
    • Hey all,
      
      I am working on a windows phone 8.1 project with SQLite PCL. My Database is working perfectly.
      
      But I am having trouble displaying it physically.
      Can anyone of you please guide me with proper steps.
      
      Regards,
      Abdul Rehman
1 - 10 of 17 Items