Is it possible to open an Sqlite database with Javascript and not using anything but HTML5?

Question

I'm trying to create an application that works on any mobile device, but doesn't require internet. I want to have an Sqlite database that I can query. I found a script, but it creates a WebSQL database in the browser. I want to query the flatfile. Is that even 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);
    }
}

WebSQL has been deprecated. I want to use something else. Is Indexed DB my only choice? I want to work with the SQLite file. — sehummel
– sehummel, Commented Oct 15, 2012 at 20:06
as you stated WebSQL, the implementation of SQLite in Web Browser, is deprecated, so if you really need to use that format i can only suggest to use this SQL.js — user757095
– user757095, Commented Oct 15, 2012 at 20:18

Cœur · Accepted Answer · 2019-03-24 07:28:44Z

2

Yes, Its possible. Try the following links

edited Mar 24, 2019 at 7:28

Cœur

39k25 gold badges207 silver badges282 bronze badges

answered Oct 15, 2012 at 20:05

Tariqulazam

4,5831 gold badge38 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

sehummel Over a year ago

Those are WebSQL, which has been deprecated.

Tariqulazam Over a year ago

Is HTML5 localStorage a solution for you?

sehummel Over a year ago

I wanted something where it was relational, and I don't believe HTML5 localStorage is.

Tariqulazam Over a year ago

Yes, you are right. localStorage is not relational just a key-value pair. I doubt there is any other solution that will work in all browser at that moment. You can think of IndexedDB but I think its supported only in FF and Chrome.

Peter Bob Ukonu · Accepted Answer · 2014-05-08 15:56:10Z

2

The question is asking for someone who can provide a tutorial to query a FlatFile DB and not a web db embedded within the browser. All your links are providing tutorial on Web DB which the question clearly highlights.

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

answered May 8, 2014 at 15:56

Peter Bob Ukonu

653 bronze badges

1 Comment

Werner Over a year ago

This is better-suited as a comment, since it doesn't provide a concrete answer.

Collectives™ on Stack Overflow

Is it possible to open an Sqlite database with Javascript and not using anything but HTML5?

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related