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.
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 :-)
Después de agregar estas referencias, puede ser que el proyecto de tu aplicación no se compile o no se ejecute. Para corregirlo, en Visual Studio, en el menú Compilar, haz clic en Administrador de configuración. En el cuadro Plataforma de soluciones activas, haz clic en tu plataforma de destino específica, como ARM, x64 o x86. A continuación, haz clic en Cerrar.
Ya que la arquitectura del procesador del proyecto que se va a compilar "Any CPU" no es compatible con el SDK "SQLite.WinRT81, Version=3.8.2"