Sqlite for Windows Phone 7.1 and Windows Phone 8

Question

SQLite

I'm developing applications for Windows Phone 7.1(7.5) - 8 (should work under all except 7.0) which needs a database This application is already made for Iphone and Android so I have to use their db files so that the structure is the same for all applications. Sqlite is used as a database. All Sqlite clients for Windows Phone are deprecated and not supported:
- dotnetslackers.com/articles/silverlight/Windows-Phone-7-Native-Database-Programming-via-Sqlite-Client-for-Windows-Phone.aspx
- wp7sqlite.codeplex .com/
- www.wirebear.com/blog/2010/11/12/using-sqlite-in-your-wp7-app/
- sqlitewindowsphone.codeplex.com/releases

The official client is only for windows phone 8www.sqlite.org/download.html and won't work for windows phone 7.1 and above

Is there a working client that will work on both 7.1 and 8? what are the ways out of this situation?
I know that there is SQL CE, but the client wants exactly SQLite - since he already has a ready-made database on it and he doesn’t really want to port, especially since Windows RT does not support SQL CE and this adds even more drama to this situation.

Answer 1

What does obsolete mean? Previously, people worked with SQLite, which means that now it will not be much different. What does not develop, so they, in theory, do not need it. The OS is already outdated and will live out its 2-3 years. The purpose of the library is to develop. And in the context of SQLite, what kind of development are we talking about? Is there something missing in the existing solutions?

Answer 2

>The official client is only for windows phone 8 www.sqlite.org/download.html and will not work for windows phone 7.1 and above
I don't know which official client you are talking about, but System.Data.Sqlite system.data.sqlite. org/ works for me both under 7.1 and under 7.5.

Answer 3

I have used sqlite in my app for windows phone 7 as described in the dotnetslackers link and its working fine in WP 8 ( I tested in WP8 emulator).
I don't see any point for saying "All Sqlite Clients for Windows Phone are out of date and not supported any more". Did you try yourself?
Also this link says "SQLite is now supported on Windows RT, Windows 8 Metro Apps and will be supported on Windows Phone 8 for local application storage."
And here is one more link, which I didn't test.
I suggest you to try the dotnetslackers link and post here if you face any problem. good luck!!
Note that SQL Server Compact 4.0 does not have a release for Windows Mobile, Windows Phone or for Windows CE devices -Windows Phone Application Development . technet.microsoft.com/en-us/library/gg592946.aspx
You can use SQL Server Compact 3.5 on WP 7.5, but I'm not sure if this version works on WP8.