SQLite for Windows Phone 8.1

Free

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

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

by TheBlueSky | August 23 2016

I have the previous version and was upgrading.
I tries upgrading from inside Visual Studio (2015 Enterprise) and outside with no luck. I keep getting the following error in the logs:

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()
... etc

by RoshanShrestha | June 21 2016

Error: Exception thrown: 'SQLitePCL.SQLiteException' in SQLitePCL.DLL got error in windows phone 8.1 while creating sqlite database

Please help

by Sai Manoj Kumar Y | April 16 2016

There is a bug which prevents the usage of Columns with AutoIncrement. The bug is due to lack of a space while generating the query for creating the table. To fix it add a space in "autoincrement" to change it to
"auto increment" on line 1851 in SQLite.cs file.

Edit: This should not be done, if the column is a primary key. And it should be a primary key for auto increment to work. So, it makes the above statement invalid

SQLite Development Team April 19 2016
| Edit |
Delete

This issue is fixed in SQLite 3.12.2.

by Jerôme Giacomini | May 21 2015

Very good library. :)

by HendrickxJonas | May 11 2015

Works like a charm, very easy to use! Don't forget to install the nugget package 'SQLite-net'

by bPlaTyPuS8 | April 13 2015

What is this shit? Was not even able to set the connection... why can we not only pass a simple string to specify the name of the DB?

by chao cui | March 23 2015

this blog on how to use SQLite may help.
http://blog.tpcware.com/2014/04/universal-app-with-sqlite-part-1/

by 王洪旭 | October 13 2014

求文档

by Den Osipov | August 16 2014

Very happy with this pack! ;)

by agens47 | July 30 2014

I had to jump through hoops to get this thing working. Apparently it doesn't add any menu item to VS2013 even though the title says "for Windows Phone 8.1". And the "more information" option for this plugin in the extensions and updates panel directs you to the sqlite.org website where there is absolutely 0 additional info.

I tested it in a C++ XAML project. It's a pity that 3rd party sources give help for C# only. +1 star for sqlite3.h which I had to hunt for in the Microsoft SDKs directory.

by Ricky_Brundritt | June 30 2014

by Lander Verhack | June 03 2014

Works for me, Thanks

by Artem | May 13 2014

VS 2013 work excellent in universal apps. I described problem with store certification but Tim Heuer told that this is certification bug and it will be fixed in a few days.

by Arafat Tehsin | May 13 2014

Does it really work Visual Studio 2012?

Sign in to start a discussion


  • Problem
    1 Posts | Last post August 06, 2016
    • I have this error:
      
      this project cannot be viewed in the object browser because it is unavailable or not yet built.
      
      
      I'm using VS2015 Community. please helpme
  • SQLITE not working after deployment
    1 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.
  • Does this project have a changelog?
    1 Posts | Last post November 12, 2015
    • I would like to understand what is changing before upgrading to the latest version.
  • CreateDatabaseBackup always returns null
    1 Posts | Last post August 10, 2015
    • I'm having an issue using this in a Windows Phone Silverlight 8.1 application.  
      
      I can create the connection and access the database correctly, but if I initiate CreateDatabaseBackup on the connection, it always returns null (but no error).  I'm running similar code on Android and it correctly creates the backup and returns the path.
      
      Here is how I create the connection.  This works.
      
             private static SQLiteConnectionWithLock lockconn;
             public SQLiteConnectionWithLock GetConnection()
              {
                  if (lockconn == null)
                  {
                      var sqliteFilename = "Mydb.sqlite";
                      string path = Path.Combine(Globals.DbPath, sqliteFilename);
      
      
                      lockconn = new SQLiteConnectionWithLock(new SQLite.Net.Platform.WindowsPhone8.SQLitePlatformWP8(), new SQLiteConnectionString(path, true));
                      lockconn.BusyTimeout = TimeSpan.FromSeconds(30);
                  }
                  return lockconn;
              }
      
      
      Here is the method for creating the backup.  This doesn't error, but always returns null.
      
              public string CreateDatabaseBackup()
              {
                  return lockconn.CreateDatabaseBackup(new SQLite.Net.Platform.WindowsPhone8.SQLitePlatformWP8());
              }
      
      Is the source code of SQLite for Windows Phone 8.1 available?  I have no idea how to troubleshoot this without the source.
      
      Thanks.
  • Character encoding not working
    1 Posts | Last post May 11, 2015
    • I am trying to store special characters in an SQLite database on Windows Phone. However, the characters appear as question marks in the database. Since the CommandText of the SQLiteCommand contains the correct characters, my presumption is that somewhere in the C++ code things go wrong. Can you have a look at it, or tell me how to store special characters in the SQLite database on Windows Phone 8.1?
  • CreateTable Error
    1 Posts | Last post January 11, 2015
    • Howdy!
      
      I am trying to use SQLite in my Windows Phone app and I am running into a bit of an issue ...
      
      I am using the latest version of this extension and reference in the project.
      
      I am also using the latest NuGet packages for SQLite PCL & SQLite PCL Provider for Windows Phone 8.
      
      Any ideas? Many thanks!!
      
      Code: connection.CreateTable<Answers>();
      Message: near ")": syntax error
      Stack Trace:
         at SQLite.Net.Platform.WindowsPhone8.SQLiteApiWP8.Prepare2(IDbHandle db, String query)
         at SQLite.Net.SQLiteCommand.Prepare()
         at SQLite.Net.SQLiteCommand.ExecuteNonQuery()
         at SQLite.Net.SQLiteConnection.Execute(String query, Object[] args)
         at SQLite.Net.SQLiteConnection.CreateTable(Type ty, CreateFlags createFlags)
         at SQLite.Net.SQLiteConnection.CreateTable[T](CreateFlags createFlags)
         at MyApp.SqliteDataProvider.ResetDatabase()
         at MyApp.Views.RootView.<CheckPayload>d__0.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
         at KosEducation.Palatine.Xui.Views.RootView.<InitializeComponent>d__17.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<ThrowAsync>b__3(Object state)
  • how to pull sqlite file from phone
    1 Posts | Last post December 03, 2014
    • Hi!
      We want to deliver our app with a pre populated database. To get the database, we first built in with the app, which is the easiest way, since the whole backend infrastructure that delivers the database data depends on using the app.
      
      After this initial database build we'd like to pull the sqlite file from the debug phone to include it in our project. Unfortunately we were not able to find out how to pull the .sqlite file. We haven't even found out where it gets stored.
      
      Is there a way to reach this file and pull it from the phone?
      
      br
  • How to restore sqlite.db fill
    1 Posts | Last post October 18, 2014
    • Hi I am working on WP 8.1, I have taken the backup of my current application which contains come data, I found my db file in app/LocalFolder.
      Now I want to restore the same file to my application. is there any way to restore the data in SQLite ?. 
      Thanks in advance.
  • Wrapper for use with C#?
    4 Posts | Last post October 06, 2014
    • I cannot find any wrapper that will allow me to access this from C#.  I found a Microsoft tutorial (http://channel9.msdn.com/Series/Building-Apps-for-Windows-Phone-8-1/19) that talks about using various wrappers with this extension - SQLite-NET, SQLite-WinRT, SQLitePCL - but none of them appear to be available yet for windows phone 8.1.   Even in the tutorial they had to *cheat* (they created a Silverlight app instead of a windows phone 8.1 app), but that was recorded a month ago.  So, for now, I seem dead in the water trying to use this extension from my Windows Phone 8.1 C# app.  
      
      Am I missing something?  Is there any way to use this from C# at the moment?  If not, what other database options do I have for my Windows Phone 8.1 app?
    • I am also searching for the wrapper. I tried "Install-Package SQLite-net". I think the wrapper for windows store 8.1 should work and it compiles, but I did not yet test it.
    • @Beth I have used sqlite-net wrapper for windows phone 8.1 app and it works absolutely fine on emulator as well as phone. You can install it from package manager console using "Install-Package SQLite-net" as mentioned above.
    • Hi.
      I'm using SQLite with WP 8.1 without any problems.
      Please, see this tutorial:
      
      http://developer.nokia.com/community/wiki/index.php?title=How_to_use_SQLite_in_Windows_Phone&oldid=187499
  • Upgrading from SQLite WP 8
    1 Posts | Last post October 01, 2014
    • Hey guys - I'm trying to understand from an app development perspective and budget, if I had an app that was previously using SQLite SDK 8 and it now needed to use SQLite WP 8.1, how complex would it be to do so and is it very time consuming.  I know there are a lot of variables involved but generally speaking, should it take over 5 business days to make the transition?
      
      Thanks! 
1 - 10 of 18 Items