SQLite for Windows Runtime

Hello, 

does SQLite for WinRT support Foreign Key relations between tables? If yes, can you please demonstrate how to use them?

I just downloaded this project.. it seems to be missing SQLite.cs and SQLiteAsync.cs?

Hi all,

I'm a beginner, in 'real' programming languages ​​such as .NET, C++ and Apps I just be familiar to housewife Programming with VB6, PHP and JS. I'm trying a JS app for Win RT/8 to write. With inclusion of SQLite I have a problem: 

If I proceed as described under GitHub - starts the SQLite3JS.jsproj-demo-app, but there are 22 failing and stops on: 
expectEvent function (eventName, rowId, callback) {

with:
db. addEventListener (eventName function, listener (event) {

unfortunately I have absolutely no idea what this methods and functions works and find no listings or simple tutorial for beginners. 

For Android and Androidbrowser I have something simple (for everybody understandable)usual:

Simply use:
window.openDatabase

and with init:
            var shortName = 'testDb';
            var version = '1.0';
            var displayName = 'test db';
            var maxSize = 1048576; // in bytes
            mydb = window.openDatabase(shortName, version, displayName, maxSize);

and just simply SQL:
mydb.transaction(
               function(transaction) {
                  transaction.executeSql('CREATE TABLE IF NOT EXISTS person(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, first_name VARCHAR NOT NULL, last_name VARCHAR NOT NULL);', [], nullDataHandler, errorHandler);
});

and so on - just SQL.

So, I don't understand things like 'it' 'then' 'waitsFor' '?' in JS. Perhabs somebody can help me with a realy simple tutorial or tell me how to use the simple Code 'window.openDatabase()' in VS2012?

Many Greetings from Bavaria (Germany)
ralphi

Hi SQLite Development Team,

I've try this extension on Windows RT (WOA) and it works just fine.

My question is since MS strongly suggest Windows Store App developer NOT to use Win32 API subset on Windows RT, and sqlite source (at least branch 3.7.15) seems not going to change to Windows Runtime API. Will these Win32 APIs used in sqlite lib get any impact on Store APP review or publish?

Did you already integrate the RTREE module?

I scanned the sqlite3.dll compiled for ARM platforms and one of the exported functions is sqlite3_rtree_geometry_callback.

This would save me recompiling sqlite for all the target plattforms :).

For some reason, I don't see this package from 'Extensions and Updates...' under Tools menu in Visual Studio 2012.

I don't see any .dll in Program Files; there are no new file references - where do you begin? Even if I found the .dll somewhere, I can't find any C# code samples. Anyone have any ideas here?

When using C#, you will probably want to utilize a managed wrapper, such as the one provided here:

http://sqlwinrt.codeplex.com/

See Tim Heuer's blog for more information:

http://timheuer.com/blog/

If it's for Windows Runtime, it should include winmd file, so it is usable in any programming language that has a winrt projection.

In order to more easily work with SQLite, I suggest you get some wrapper code to help you out so you don’t have to PInvoke unmanaged SQLite functions yourself.  Your best bet is to right-click on References and select Manage NuGet Packages.  In the Manage NuGet Packages dialog, expand Online and then search for SQLite.  Your search results will include a lot wrappers, but I need to steer you in the direction of libraries that support x86, x64, and ARM while not depending on ADO.NET.  Select the LINQ-friendly sqlite-net library created by Frank Krueger, click Install and then close the dialog to add it to your solution