How to use WebSql with ionic?


#1

As per in the given document https://ionicframework.com/docs/storage/ " When running in a native app context, Storage will prioritize using SQLite, as it’s one of the most stable and widely used file-based databases, and avoids some of the pitfalls of things like localstorage and IndexedDB, such as the OS deciding to clear out such data in low disk-space situations.

When running in the web or as a Progressive Web App, Storage will attempt to use IndexedDB, WebSQL, and localstorage, in that order.".

The SQLite plugin is working fine in the device but during the ionic serve I expected the table should be formed in websql. but to my suprise it is not formed and the data is inserted and I am not seeing any error in my console regarding. Kindly correct me if my understandings are wrong.


#2

IndexedDB makes a sad face, because you didn’t think it was up to the task.


#3

What do you mean with “formed”?

Are you using a cordova plugin to access sqlite? Or the Ionic Storage API?
Can you post some code?


#4

I like to have a relational database in my application. So I thought of websql.


#5

I’m confused. Didn’t we start out with you talking about the ionic-storage documentation? That’s not relational.