Web and WebWorks Development

[zantoro]

Hello,

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.

Any idea?

Thanks,

Roberto.

[jamesgibbons · Accepted solution]

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/database/local_0/

Cheers,

James

[zantoro]

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.

Thanks,

Roberto.