Using database in phone gap

Question

I'm about to dive into a new mobile project, to be more specific a mobile TCG (Trading Card Game) Deckbuilder app. As it's about to be my first mobile app, I've done some research and came across Phonegap. I've done a couple of node-based web apps, so it seems right down my alley.

I started searching for how to store any data on a phone and found out there are 3 possibilities:

MemoryStore (SQLLite?)
LocalStorageStore
WebSqlStore

LocalStorageStore, seems out of the question for the complexity of my app. So it's between MemoryStore and WebSqlStore.

What would suit my project? And how complex could you go?

So the idea is to have a "big" json file with all existing cards:

{
  id: xx,
  name: 'name'
  manacost: xx,
  attack: xx,
  defence: xx,
  effects: [
    'lorem ipsum',
    'lorem ipsum'
  ],
  image: '/img/cards/xx.png'
}

So to save a deck I suppose I could go for:

deckname
array of cards (wondering whether I save them with {id, amount} or count them.
created & updated

Wouldn't this be too heavy on the memory? And yet again, what database system would be suited for this?

Pankaj Zade Pankaj Zade · Accepted Answer · 2016-08-30T09:50:04

you can use SQLite to save your data. It's very proper way to save your data in table format so that you can get required data using sql query. When you are using huge data at that time, sometimes it's difficult to handle this with session or localStorage. So I suggest you to use SQLite. As I mention below example, you will get an idea for creating DB.

 <!DOCTYPE HTML>
<html>

   <head>

      <script type="text/javascript">

         var db = openDatabase('mydatabase', '1.0', 'My DB', 2 * 1024 * 1024);

         db.transaction(function (tx) {
            tx.executeSql('CREATE TABLE IF NOT EXISTS USER (id unique, name)');
            tx.executeSql('INSERT INTO USER (id, name) VALUES (1, "Ram")');
            tx.executeSql('INSERT INTO USER (id, name) VALUES (2, "Amay")');

         });

         db.transaction(function (tx) {
            tx.executeSql('SELECT * FROM USER WHERE id=?', [1], function (tx, results) {
               var len = results.rows.length, i;

               for (i = 0; i < len; i++){
                  var data = "<p><b>" + results.rows.item(i).name + "</b></p>";
                  document.querySelector('#custName').innerHTML +=  data;
               }
            }, null);
         });

      </script>

   </head>

   <body>
      <div id="custName">USER NAME</div>
   </body>

</html>

Using database in phone gap

2 Answers