Database on device

8 posts, 0 answers
  1. Nick
    Nick avatar
    1 posts
    Member since:
    Nov 2012

    Posted 09 Nov 2012 Link to this post

    is there any support for a local sqlite database for data storage?
  2. Jordan
    Admin
    Jordan avatar
    197 posts

    Posted 12 Nov 2012 Link to this post

    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.
  3. Gurpreet
    Gurpreet avatar
    3 posts
    Member since:
    Jul 2012

    Posted 08 Feb 2013 Link to this post

    hi,
    I just want to ask that if we want to store details permanently. Is there any alternate.
  4. Yavor Georgiev
    Admin
    Yavor Georgiev avatar
    982 posts

    Posted 09 Feb 2013 Link to this post

    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.
  5. Idan
    Idan avatar
    76 posts
    Member since:
    Oct 2012

    Posted 23 Oct 2013 Link to this post

    How do I install the sqlite plugin  in an existing project?
  6. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 24 Oct 2013 Link to this post

    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.
  7. Warren
    Warren avatar
    61 posts
    Member since:
    Aug 2013

    Posted 25 Oct 2013 Link to this post

    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
  8. Ivan
    Admin
    Ivan avatar
    111 posts

    Posted 28 Oct 2013 Link to this post

    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.
Back to Top