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 (104,622)
5/18/2016
3.13.0
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (8)
Q and A (15)
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


  • 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
  • Enable FTS4 unicode61 Tokenizer
    2 Posts | Last post February 19, 2015
    • Is it possible to get a winrt 8.1 build with unicode61 tokenizer for FTS4. That  is compiling with option SQLITE_ENABLE_FTS4_UNICODE61. I am not confident enough to build sqlite to distribute with an app.
      
      Regards,
      Sony Arouje
    • Hi Sony. I have the same request. As i understand FTS4 is not enabled at all at this version? I wonder if you managed it to work.
      
      Thanks.
  • Enable FTS4
    1 Posts | Last post February 19, 2015
    • Is it possible to have another version with SQLITE_ENABLE_FTS4 option?
      
      Thanks.
1 - 10 of 15 Items