How to use SQLite within a WinRT DLL?

Question

I am trying to develop a WinRT DLL which uses SQLite to write database. But it seems like some win32 APIs in SQLite source code are not supported by metro, such as, LoadLibraryW, GetTempPathA.

Is there any way to compile SQLite source code or use SQLite with WinRT DLL?

Answer 1

Well you could always link sqlite3 statically and define new functions for accessing files etc via sqlite3_vfs.

Answer 2

In VS2012 there is an extension now called SQLite for Windows Runtime. You can download and install this via Visual Studio (requires a restart of the IDE). Then, go to your WinRT project, Add a Reference, under "Windows" choose "Extensions" and you should see it.

Answer 3

There's a winrt branch of SQLite now that only uses supported API. On top of that, we implemented SQLite3-WinRT, a WinRT component that allows using SQLite in any of the WinRT languages.