Jquery read a Sqlite database that php created

Question

After reading a ton of other questions on the subject I feel as though I should preface this question with: This is not about phonegap or android development

A quick recap on how I have come to this headache.

• wrote a bash script to recursively read the contents of a dvd and write them to a .txt
• used this script to catalog about fifty thousand files (extensions, creation date etc.)
• used php/wamp server to parse the data and create a sqlite database
• followed a tutorial here to figure out how to (try to) read that database with jquery

using var db = openDatabase("catalog.db"); I expected jquery to be able to load this database since the js and the and the database are in the same directory.

it seems as though this function is meant for "Browser embedded" databases and not local databses.

How do I read a sqlite database file and not the browser's database?

Looking for a solution where multiple users are able to see the same response from an offline database. Distribution should be as simple as reading a folder from a flash drive without installing anything.

About to give up on this and just make it a cloud solution instead of an offline solution.

Answer 1

You can't read a sqlite database with javascript. The question What's the simplest way to import an SQLite SQL file into a WEB SQL Database has some answers on importing the database to the browsers database.