Querying SQLite database from file using Javascript

Question

I am building a web app with offline database browser. I've got a .db3 file, but can't open it directly using sql.js or html5sql.js. What kind of loader do I need?

Answer 1

I don't think there is a cross-browser way for opening db3 files. It could be that mobile Safari has a trick up its sleeve, but I'm no expert in that area.

You can create a similar database in Mobile Safari using a so-called Web SQL database. You'd have to re-create your table structure and re-insert the data, but after that you can fire pretty regular SQL queries against the local database.

Note that the Web SQL specification has been abandoned on favor of a simpler local database standard. But it works in current mobile Safari versions, which may be good enough for your needs.