Skip to content

Latest commit

 

History

History
30 lines (27 loc) · 1.14 KB

README.md

File metadata and controls

30 lines (27 loc) · 1.14 KB

database-js-sqlite

Build Status

SQLite wrapper for database-js

About

Database-js-mysql is a wrapper around the node-sqlite3 package. It is intended to be used with the database-js package.

Usage

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');