Using SQLite With WinRT, Metro, Windows 8 Mobile

As pre recent news at http://www.sqlite.org/news.html on 2012-June-11 - Release 3.7.13

“SQLite version 3.7.13 adds support for WinRT and metro style applications for Microsoft Windows 8. The 3.7.13 release is coming sooner than is usual after the previous release in order to get this new capability into the hands of developers. To use SQLite in a metro style application, compile with the -DSQLITE_OS_WINRT flag. Because of the increased application security and safety requirements of WinRT, all database filenames should be full pathnames. Note that SQLite is not capable of accessing databases outside the installation directory and application data directory. This restriction is another security and safety feature of WinRT. Apart from these restrictions, SQLite should work exactly the same on WinRT as it does on every other system. “

Below are few links on tutorials regarding how SQLite can be used with metro apps.:

By Tim Hueur

• Using SQLite in a Metro style app
• HOW TO: Use SQLite in C# Metro style app
• Seeding your Metro style app with a SQLite database
• UPDATED HOWTO: SQLite with Windows 8 apps

By Matteo Pagani

• Using SQLite in your Windows 8 Metro style applications