Metro Apps - SQLite vs Indexed Db

Question

I am about to start working on a metro app using JavaScript/HTML which will store data locally, when no internet connection is there and also planning to port the same on other platform's later.

What would be the right choice for database - SQLite or Indexed db ?

http://stackoverflow.com/questions/11707891/optimal-database-to-be-used-for-metro-apps — Farhan Ghumra, Apr 17 '13 at 10:31
what type of data access do you need? if relational is important, you'd perhaps trend to SQLite. IndexedDB though as 'built-in' to HTML5 may be easier - fewer moving parts. — Jim O'Neil, Apr 17 '13 at 16:31
@Xyroid http://www.nitrix-reloaded.com/2012/12/18/html5-bye-bye-websqlsqlite-welcome-indexeddb/ http://www.w3.org/TR/webdatabase/ — Hemant Bhatt, Apr 18 '13 at 04:24
The link you gave me is for Web App developer not for Windows 8 Developer, though I am C#/XAML developer so I am using SQLite not idea about HTML/WinJS — Farhan Ghumra, Apr 18 '13 at 05:54

score 1 · Answer 1 · answered Apr 17 '13 at 23:45

I would have to say that IndexedDB is a much better option than SQLite for Windows 8 applications because:

It's built into the browser, so the code you're writing has skill portability to web applications
There are several good libraries out there to simplify working with it (pouchdb, db.js, jQuery IndexedDB, and many more)
The API is designed to work with JavaScript objects, particularly when it comes to querying, unlike SQLite which you (generally speaking) will have to create SQL statements as strings

Metro Apps - SQLite vs Indexed Db

1 Answers1