Open a SQLite file and read it with `openDatabase`

Question

Open a SQLite file and read it with `openDatabase`

I tried to open a new database like that :

localFileName = 'open-streets-dc.mbtiles';
db = window.openDatabase(localFileName, '1', 'my', 1024 * 1024 * 100);

It will create a new db in Web SQL and I can browse on it with chrome. In my case, I have to read an exisiting SQLite file but I did not found the solution.

I tried sql.js but I need to make it works with an Android, with ionic and it does not work as you can see in this issue.

Do you have an idea of solution?

javascript
android
sqlite
cordova
ionic-framework

Answer 1

var db = window.openDatabase("Database", "1.0", "MyDB", 200000);
    if(db) {
        console.log("database created / opened");
        //div.innerHTML = div.innerHTML + "<hr>database created / opened";
    }

Answer 2

if you want access the database from chrome it's mean the database is in web server right? my be this is can help you https://fahmirahman.wordpress.com/2011/04/21/connection-between-php-server-and-android-client-using-http-and-json/ glad to hepl you

Answer 3

I use this plugin for accessing databases with cordova. In the README you can find some helpful code.

Cordova-SQLitePlugin

Regards,