Web and WebWorks Development

[jmace]

If I package a sqlite database to be installed with my widget , how to I access that data in the widget? I've been reading the gears documentation and the "attach" and "Detach" commands are both disabled?

[tneil · Accepted solution]

You will not be able to distribute a SQLite pre-packaged database with your application.  All Gears databases are encrypted on the device and cannot be replaced.

You will have to build your database via JavaScript.  For your default data, you could embed XML files in your widget and then loop through them to populate your database in a worker thread.

[jmace]

Thanks Tim.

Would it be possible to at least save the schema of my database and import that?

just trying to see where I can cut corners and speed things up.