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.

I also am stuck on this concept of 'loading' an existing Sqlite database (say it's called employees.db) into the browser. Html pages are served from the webserver to the browser. Can I not also use Javascript to load a *.db file from the web server into the browser? Any examples I have seen start with an empty canvas...using Javascript (so it's all client-side work). They create an in-browser database, create tables and INSERT data....Is this the only way? Am I missing something ? I would like to pull this employees.db file from a webserver using Javascript. — barneymc
– barneymc, Commented Aug 25, 2013 at 10:38

CL. · Accepted Answer · 2013-03-25 11:30:41Z

2

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.)

answered Mar 25, 2013 at 11:30

CL.

182k18 gold badges241 silver badges282 bronze badges

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

1 Comment

11684 Over a year ago

Web apps are not allowed to access arbitrary files on the computer. Not entirely true. There is (limited) support for that, via the File API. Still, +1!

sadhasivam · Accepted Answer · 2013-04-22 11:38:30Z

0

for Safari browser:

create dummy database in your HTML5.

after that copy database file name from mentioned location.

\Application Data\Apple Computer\Safari\Databases{your domain name}{database File name}

replace your database file name from newer one. and paste into the above mentioned location.

open your HTML5 page i hope it's work's good.

answered Apr 22, 2013 at 11:38

sadhasivam

1

1 Comment

11684 Over a year ago

Not really a solution I would give an end user.

Collectives™ on Stack Overflow

How to use an existing sqlite database in html5

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related