How to see SQLite database in ionic?

ionic-v1
1

I have used the cordovaSQLite plugin for using DB in ionic framework. Do we have any UI for the same where I can see the database and see the tables and its entries.?

I have used the SQLite app for native android development but nothing I can find for ionic (Cordova) yet. Any Help?

2 Likes
2

if you want to test in chrome than you can use window.openDatabase instead of window.sqlitePlugin.openDatabase and you will have Web SQL Database with same syntax and you can see your database in the resource panel in chrome https://developer.chrome.com/devtools/docs/resource-panel#web-sql .

Here is where chrome saves the db so you can open it with an other tool :

Web SQL locations by system for Google Chrome:

Windows Vista or 7

\Users_username_\AppData\Local\Google\Chrome\User Data\Default\databases

Windows XP

\Documents and Settings_username_\Local Settings\Application Data\Google\Chrome\User Data\Default\databases

Mac OS X

~/Library/Application Support/Google/Chrome/Default/databases

Linux

~/.config/google-chrome/Default/databases

or https://developer.chrome.com/devtools/docs/remote-debugging#debugging-webviews

2 Likes
3

Who knows how to work with existing sqlite database and debug it in chrome tools?
For example if i put my db(which has a tables and data) in path( Windows Vista or 7)

\Users_username_\AppData\Local\Google\Chrome\User Data\Default\databases and after that do next:

var db_name='my.db'
db =  window.openDatabase(db_name, "1.0", "Cordova Test",900000);

I see that chrome make new db - not open my db. Why?

1 Like