Is it possible to access an SQLite database from JavaScript?

javascript html database sqlite
Pal Szasz picture Pal Szasz · Nov 2, 2012 · Viewed 230.2k times · Source

I have a set of HTML files and a SQLite database, which I would like to access from the browser, using the file:// scheme. Is it possible to access the database and create queries (and tables) using JavaScript?

Answer

Minko Gechev picture Minko Gechev · Nov 2, 2012

Actually the answer is yes. Here is an example how you can do this: http://html5doctor.com/introducing-web-sql-databases/

The bad thing is that it's with very limited support by the browsers.

More information here HTML5 IndexedDB, Web SQL Database and browser wars

PS: As @Christoph said Web SQL is no longer in active maintenance and the Web Applications Working Group does not intend to maintain it further so look here https://developer.mozilla.org/en-US/docs/IndexedDB.

SQL.js

EDIT

As @clentfort said, you can access SQLite database with client-side JavaScript by using SQL.js.

Related questions

How to make a local offline database

I'm making a to-do list application with HTML, CSS, and JavaScript, and I think the best way for me to store the data would be a local database. I know how to use localStorage and sessionStorage, and I also know …

Read More
Websql Insert Query

I am new websql.i cannot insert primary key in websql. Create Query db.transaction(function (tx) { var sql = "CREATE TABLE vehicles ( "+ "id integer primary key autoincrement,"+ "vehicle_ref_no VARCHAR(255),"+ "vehicle_plate_no VARCHAR(255),"+ )"; tx.executeSql(sql); }); Insert Query …

Read More
HTML 5 Web SQL Database Transaction commit or rollback when refreshing page

As written in the Safari Client-Side Storage and Offline Applications Programming Guide, rolling back a HTML 5 Web SQL Database transaction is done by returning true in the callback function provided as an error callback to a transaction the executeSql method: …

Read More