Cordova SQLite plugin with a straightforward low-level API.
Why this module?
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.
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 = windowcordova;var sqlite = 'example';sqlite;
Create an instance of the SQLite database with the specified name.
var SQLite = windowcordova;var sqlite = 'example';
Open the SQLite database.
sqlite.query(sql, [values], callback)
Query the SQLite database.
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
Errorin 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.
Delete the SQLite database with the specified name.