SQLite On WinRT, Metro, Windows 8 Mobile

SQLite 3.7.13 adds support for Windows RT and Windows 8 Metro-style apps, and Microsoft says Windows 8 mobile will also support SQLite. For actual use in .NET or JavaScript apps, the engine must be wrapped as a WinRT component or accessed through a library that does that work.

.NET developers can use sqlite-net for a LINQ wrapper. JavaScript developers can use SQLite3-WinRT, and C++ developers can work with sqlite.h without worrying about WinRT wrappers. The announcement also mentions some restrictions, but otherwise SQLite should work like it does on other systems.

Reading notes

#

• SQLite is supported on Windows RT, Windows 8 Metro apps, and will be supported on Windows Phone 8 for local application storage.
• SQLite 3.7.13 adds support for WinRT and Metro style applications for Windows 8.
• Windows 8 mobile will also support SQLite, according to Microsoft.
• Only the engine is available; .NET or JavaScript apps need a WinRT component wrapper or a library that provides one.
• .NET developers can use sqlite-net, which provides a LINQ wrapper for SQLite.
• JavaScript developers can use SQLite3-WinRT.
• C++ developers can use the sqlite.h header file without WinRT wrappers.
• The SQLite announcement mentions a few restrictions, but says it should otherwise work like on other systems.