01-31-2013 03:33 AM
Hello!
I'm developing an application for BB10; I have a .sqlite file generated by a software and I want to make some queries on it.
I've read that I can't rely on the HTML5 Database because it doesn't allows you to operate on an arbitrary .sqlite file, but only on the ones integrated in webworks. Is that correct?
Is there any way to read data from my .sqlite file in WebWorks ?
Solved! Go to Solution.
01-31-2013 09:55 AM
Yes, this is not a WebWorks restriction so much as a security restriction itself imposed by Browser based environments. The webview will not allow you to load an arbritray sqlite. Or at least AFAIK.
Simplest method may be to do the following:
1. Bundle or load the database as a database drop of SQL commands.
2. Loop over the loaded file and execute the commands against the WebSQLite database inserting and creating all tables that you need at load/runtime.
3. Execute any queries that you would like to have to get at your data.