Is it possible to open a Sqlite database using Javascript and not use anything but HTML5?

Question

I am trying to create an application that works on any mobile device but does not require internet. I want to have a Sqlite database that I can query. I found a script, but it creates a WebSQL database in the browser. I want to request a flatfile file. Is it possible?

Here is my code:

function createDatabase() { try{ if (window.openDatabase) { var db; var shortName = 'configurator.sqlite'; var version = '1.0'; var displayName = 'configurator'; var maxSize = 65335; db = openDatabase(shortName, version, displayName, maxSize); } else { console.log('failure'); } } catch(e) { alert(e); } } 

Answer 1

Yes it is possible. Try the following links.

• http://benpoole.com/weblog/201106222227
• https://gist.github.com/1041277
• http://www.tutorialspoint.com/html5/html5_web_sql.htm
• https://developer.apple.com/library/safari/#documentation/iphone/conceptual/safarijsdatabaseguide/UsingtheJavascriptDatabase/UsingtheJavascriptDatabase.html

Answer 2

The question is to ask someone who can provide a tutorial for querying FlatFile DB, not the web db embedded in the browser. All of your links provide a web database tutorial that clearly emphasizes the question.

I think you should research SQL.JS on Github to get a solution of what you want. It is somewhat dependent on Node.js, but you will achieve your goal just fine.