This is a migrated thread and some comments may be shown as answers.

Graphite Simulator Database Size Constraints ++

3 Answers 64 Views
AppBuilder Windows client
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Peter FIELD
Top achievements
Rank 1
Peter FIELD asked on 28 Mar 2013, 01:08 AM
I am seeing what appears to be a 5MB limitation "Error: there was not enough remaining storage space, or the storage quota was reached and the user declined to allow more space". I don't get this error on a device only the simulator.

Is there a way to increase the limit as this constraint makes testing in the simulator impossible for an enterprise application that requires a larger database capacity 25MB. Not being able to test in the simulator is tedious. If I could find the database maybe I could alter the quota.

This also raises the question about database location, specifying a path in the database name parameter of openDatabase is ignored in the simulator. I added a database in a folder called resources and tried to open it using Resources/TTCMobile2.db as name parameter but get an error calling method on NPObject.

Additionally pragma statements do not appear to be supported in the simulator.

3 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 28 Mar 2013, 04:44 PM
Hello Peter,

The 5MB limitation is for the built-in SQL (WebSQL). If you need to store data above this limit you can go with the SQlite plugin that we support as well (more information about the plugin here). However plug-ins do not work in the simulator, which seems to be your main concern.

According to this article, you might want to try running the simulator in Mist under Safari and check whether it would prompt you for database size increase. In the mean time, we would investigate whether we could increase the default 5MB database size out of the box (for subsequent version of Icenium).

Judging by this issue, websql does not support pragma, however sqlite does.

Regards,
Steve
the Telerik team

Share feedback and vote for features on our Feedback Portal.
Want some Kendo UI online training - head over to Pluralsight.
0
Peter FIELD
Top achievements
Rank 1
answered on 12 Apr 2013, 03:25 AM
Thanks Steve, I am happy to hear that you would investigate whether you could increase the default 5MB database size out of the box (for subsequent version of Icenium). I hope that means you will try and support the SQlite plugin in the simulator. 

My development team is finding it tedious under the current implementation. Apart from the size constraint my wish list would be to include support for managing the database location. At present we cannot find the simulator database to investigate it with SQlite tools nor can get the database from the device unless it has been rooted. Please let me know if that is not correct. Secondly I would think other developers would be interested in shipping a database with pre-configured static data, and given you do not appear to be able to set the file path it means your application has to load all its static data from a web service prior to being able to use the application rather than open a database you supplied as a resource. 

Off topic we will be paying to use Icenium in a few weeks, what support avenues will be provided?


0
Steve
Telerik team
answered on 12 Apr 2013, 07:43 AM
Hello Peter,

Investigating the possibility to Increase the size of the default WebSQL database is not equivalent to getting the SQLite plug-in running in the simulator, which would require significant effort from our side. Nevertheless we are currently working on adding support for any custom plugin in Icenium and we would not dismiss any possibility if this proves feasible.

About working with database with pre-configured data, take a look at the following thread for more information: Sqlite Prepopulated DB.

We're glad that you've already taken the decision to continue with Icenium after the free period is over. The support options would be similar to the Kendo UI support options i.e. we would offer plans without support, with limited support and with unlimited support.

All the best,
Steve
the Telerik team

Share feedback and vote for features on our Feedback Portal.
Want some Kendo UI online training - head over to Kendo UI Dojo.
Tags
AppBuilder Windows client
Asked by
Peter FIELD
Top achievements
Rank 1
Answers by
Steve
Telerik team
Peter FIELD
Top achievements
Rank 1
Share this question
or