local database

Thread is closed for posting
2 posts, 0 answers
  1. Kevin
    Kevin avatar
    2 posts
    Member since:
    Jan 2017

    Posted 18 Jan 2017 Link to this post

    hello

    the kendo ui mobile

    Is it possible to manage a database stored in the memory of the mobile device or in the memory card of the mobile device?
    Is it possible to execute sqlite queries in this database and create a list with at least ten thousand elements?
    Is it possible to implement distributed database?

     

    Thanks.

  2. Martin
    Admin
    Martin avatar
    104 posts

    Posted 23 Jan 2017 Link to this post

    Hi Kevin,

    Straight to your questions.

    1. Yes, it possible to store a database in the device memory. One of the most popular ways is to use SQLite plugin (the plugin on GitHub). 
    2. DB file location - DB location depends on the app location. When the app calls sqlitePlugin.openDatabase(), the plugin will create the database file if it does not exist, or read the database file if it does exist. For each platform, the database file should be in the same path (relative to your app) regardless whether you are running it on an emulator or on a real device.
      There is an option (createFromLocation) that copies the database file from the app's www directory if it is not already present (used to pre-populate database).
    3. You can store thousands of elements using SQLite queries - still, you are limited on space available on the device and should also test the performance with a larger database as devices vary on computing power.
    4. Distributed database - I am not aware this approach to be available when using a mobile database. Could you please share some more information about your use case in order to be able to provide more information on possible approaches?

    Further, you may review this blog post as well as our sample SQLite demo app.

    I hope this has helped.

    Regards,

    Martin
    Telerik by Progress
     

    Visit the Telerik Verified Plugins Marketplace and get the custom Cordova plugin you need, already tweaked to work seamlessly with AppBuilder.

     
Back to Top