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

Database on device

7 Answers 209 Views
General Discussion
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Nick
Top achievements
Rank 1
Nick asked on 09 Nov 2012, 06:30 PM
is there any support for a local sqlite database for data storage?

7 Answers, 1 is accepted

Sort by
0
Jordan
Telerik team
answered on 12 Nov 2012, 08:55 AM
Hello Nick,

good starting point on storing data in HTML application is this page. There is list of supported browsers with mobile as well.

At the moment Web SQL is most supported on mobiles (unfortunately it is officially depreciated in favor of IndexedDB).

Be aware that  storage limitations may vary between different devices I recall something  from 5MB to 50MB.

The other option Web Storage (simple key/value store) do not scale well if you store more than few values and is usually used as alternative to cookies.

Kind regards,
Jordan
the Telerik team

Share feedback and vote for features on our Feedback Portal.
Want some Kendo UI online training - head over to Pluralsight.
0
Gurpreet
Top achievements
Rank 1
answered on 08 Feb 2013, 11:38 AM
hi,
I just want to ask that if we want to store details permanently. Is there any alternate.
0
Yavor Georgiev
Telerik team
answered on 09 Feb 2013, 11:03 PM
Hi Gurpreet,

 Icenium 1.2 comes with support for the SQLite Cordova plugin. You can use it to create, update and query a native sqlite database that is stored on the device's filesystem and is permanent until you delete it or the user uninstalls your app.

 You can see a sample app with the SQLite plugin here.

Regards,
Yavor Georgiev
the Telerik team

Share feedback and vote for features on our Feedback Portal.
Want some Kendo UI online training - head over to Pluralsight.
0
Idan
Top achievements
Rank 1
answered on 23 Oct 2013, 04:46 PM
How do I install the sqlite plugin  in an existing project?
0
Steve
Telerik team
answered on 24 Oct 2013, 07:20 AM
Hello Idan,

Refer to our documentation: Enable and Configure Integrated Plugins for information on how to add built-in plugin.

Regards,
Steve
Telerik
You've missed the Icenium Visual Studio Integration keynote? It has been recorded and posted here.
Looking for tips & tricks directly from the Icenium team? Check out our blog!
Share feedback and vote for features on our Feedback Portal.
0
Warren
Top achievements
Rank 1
answered on 25 Oct 2013, 07:10 PM
I love SQLite! I first create my database on my PC with Visual Studio and then place the file in my mobile app project and go from there. The tables and call can be created at the beginning but I needed to start my app with existing data for what I was doing.

Warren
0
Ivan
Telerik team
answered on 28 Oct 2013, 02:17 PM
Hello,

A similar question have already been answered in our forums. Please, check the following forum thread: Pre populated database for distribution.

Regards,
Ivan
Telerik
You've missed the Icenium Visual Studio Integration keynote? It has been recorded and posted here.
Looking for tips & tricks directly from the Icenium team? Check out our blog!
Share feedback and vote for features on our Feedback Portal.
Tags
General Discussion
Asked by
Nick
Top achievements
Rank 1
Answers by
Jordan
Telerik team
Gurpreet
Top achievements
Rank 1
Yavor Georgiev
Telerik team
Idan
Top achievements
Rank 1
Steve
Telerik team
Warren
Top achievements
Rank 1
Ivan
Telerik team
Share this question
or