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.
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
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.
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.
As a temporary solution you can download a "work on his machine" Vsix installer for "SQLite for Windows Runtime (Windows Phone 8.1)" made by Tim Heuer.
See his post: http://timheuer.com/blog/archive/2014/04/17/universal-windows-apps-nuget-sdk-references-sqlite.aspx
I've tried it and it works also on my machine :-)