SQLite wrapper for database-js
Database-js-mysql is a wrapper around the node-sqlite3 package. It is intended to be used with the database-js package.
var Database = require('database-js2').Connection;
(async () => {
let connection, statement, rows;
connection = new Database('sqlite:///test.sqlite');
try {
statement = await connection.prepareStatement("SELECT * FROM tablea WHERE user_name = ?");
rows = await statement.query('not_so_secret_user');
console.log(rows);
} catch (error) {
console.log(error);
} finally {
await connection.close();
}
})();The original sql.js package can still be used as well. Pass "driver=sql.js" in the connection parameter string. e.g.
connection = new Database('sqlite:///test.sqlite?driver=sql.js');