How do I use Sqlite in a Cordova application?

Question

Gentlemen, I have a hybrid application that I built in HTML, CSS and Javascript (Jquery Mobile) using Cordova, and now I would like to access the device’s database. Unfortunately I don’t know where to start, because in the searches I did most of the material is in English (Google Dale Translate). I would like a simple example of CRUD to follow and tips for initiation like:

1. I have to give permission to access the application to access the bank?

2. The saved information remained permanently on the device?

Answer 1

There is a native sqlite interface in Cordova/Phonegap

cordova plugin add https://github.com/litehelpers/Cordova-sqlite-storage.git

Example:

module.controller('MyCtrl', function($scope, $cordovaSQLite) {

      var db = $cordovaSQLite.openDB({ name: "my.db" });

      // for opening a background db:
      var db = $cordovaSQLite.openDB({ name: "my.db", bgType: 1 });

      $scope.execute = function() {
        var query = "INSERT INTO test_table (data, data_num) VALUES (?,?)";
        $cordovaSQLite.execute(db, query, ["test", 100]).then(function(res) {
          console.log("insertId: " + res.insertId);
        }, function (err) {
          console.error(err);
        });
      };

    });

http://ngcordova.com/docs/plugins/sqlite/