10-12-2012 03:18 AM
I'm fiddling around with HTML5 database.
In order to make my web service application faster, I would like to "cache" some data in a local database.
This SQLlite thing seems pretty nifty and I wanted to give it a go.
I'm using Ripple and it seems to retain data but then I don't understand where is the database physically stored.
I would like to prebuild a database so that users won't have to wait for the db to update the first time.
Solved! Go to Solution.
10-12-2012 01:21 PM
Rather than try to overwrite the ".db" database file on the device, it is far easier to save the CREATE TABLE and INSERT statements to a local file or embed them in a JavasScript file and load them the first time the application is run. Let me know if you need an example.
Packaging a .db WebSQL file with your application would be great, but due to local file access restrictions I don't think such a technqiue would be feasible on BlackBerry devices. However, if you want to look at where the physical database file is stored on PlayBook, you need to setup Blackberry-Connect. The databases on PlayBook should be in the folder: /accounts/1000/appdata/<appname>/data/data
10-14-2012 08:08 AM
Well, that's good enough... I would have liked it better if it had been possible to pack the database ready in the installation but I guess this will do.