How to use an existing sqlite database in html5

Question

I have created an sqlite database file using sqlite browser.I have a file "sample.sqlite", now i wanted to know how to import this file in javascript and use the data in the sqlite file.I have been using this below mentioned script

var db;

try {
    if (window.openDatabase) {
        db = openDatabase("sample.sqlite", "1.0", "HTML5 Database API example", 200000);
        if (!db)
            alert("Error Failed to open the database, check version");
    } else
        alert("Error Not supported? Not gonna happen");
} catch(err) {}

By using this code i am not able to get the data from sqlite file.Please suggest me how to proceed.i have seen some sites where steps have been mentioned to create table,insert data by writing code in java script itself.But i don't know to do it that way i want to import the existing sqlite file.

Answer 1

Web apps are not allowed to access arbitrary files on the computer.

You could download some data from the same server where your JavaScript code comes from, but it would be easier and faster to embed the SQL commands to create your database in your code. (Use the .dump command of the sqlite3 command-line tool to get these SQL commands.)