Cordova SQLite plugin with a straightforward low-level API.

To use a SQLite database from a Cordova app, there is the cordova-sqlite-storage plugin. It is a good choice if you like the WebSQL API but in case you don't, there are not many options.

What's wrong with the WebSQL API? It is simply the worst API ever created throughout the history of computing. Jokes aside, in my opinion there is something fundamentally wrong: when we are in the middle of a transaction, there is no way to run something asynchronously.

This is why I created this module, I extracted all the good part (the native code) from cordova-sqlite-storage and replaced the less good part (the JavaScript code implementing the WebSQL API) by a much simpler low-level API.

You can use this module directly but I would rather recommend to go with the AnySQL module which is a slightly higher level API.

With Cordova CLI tool:

cordova plugin add cordova-sqlite-plugin

var SQLite = window.cordova.require('cordova-sqlite-plugin.SQLite');

var sqlite = new SQLite('example');

sqlite.open(function(err) {
  if (err) throw err;
  sqlite.query('SELECT ? + ? AS solution', [2, 3], function(err, res) {
    if (err) throw err;
    console.log(res.rows[0].solution);
  });
});

Create an instance of the SQLite database with the specified name.

var SQLite = window.cordova.require('cordova-sqlite-plugin.SQLite');

var sqlite = new SQLite('example');

Open the SQLite database.

sqlite.open(function(err) {
  if (err) throw err;
  // ...
});

Query the SQLite database.

sqlite.query('SELECT ? + ? AS solution', [2, 3], function(err, res) {
  if (err) throw err;
  console.log(res.rows[0].solution); // => 5
});

A string containing the SQL query.

An optional array of values matching the ? placeholders in the SQL query.

A function with the following parameters:

• error: an instance of Error in case something wrong happens during the query.
• result: an object with the following properties:
  • rows: the rows returned by the query.
  • affectedRows: the number of affected rows by the query.
  • insertId: the auto-generated id by an INSERT query.

Close the SQLite database.

sqlite.close(function(err) {
  if (err) throw err;
});

Delete the SQLite database with the specified name.

SQLite.deleteDatabase('example', function(err) {
  if (err) throw err;
});

MIT