Built-in Database for Windows 8 Application

Question

Is there any embedded database for developing Windows 8 applications?

I was looking for something like Sqlite or etc that integrate with visual studio 11.

Answer 1

For JavaScript, you are probably best using HTML5 IndexedDB. Unfortunately, this is not available for other languages.

There is a second option: Windows has a built-in built-in database in the form of Extensible Storage Engine . This is a relatively simple ISAM database (without SQL, you need to query indexes directly). This is the white API for Metro apps. Using it with C ++ is simple - just #include <esent.h> and go. For C # you need to use P / Invoke. For JavaScript, you need to write a wrapper around the ESE API using C ++ / CX.

Another option is to take SQLite and make it compile (and pass an application certification check for forbidden APIs) for WinRT. You will need to make some changes to the code to make it work, but they are few.

Answer 2

Generic Object Storage Helper for WinRT and a WinRTFile-based database may come in handy.

---

Also, as @Pavel Minaev implied, Tim Heyer confirmed :

... Please note that while awesome, the SQLWinRT project on codeplex is a wrapper for communicating with the classic SQLite engine ... which uses APIs that will not pass validation checks at the moment.

So, if you want to go the SQLite path, you will have to make some changes to get it to pass the application store check.