sqlite

SQLite client for Node.js applications

This is just a wrapper library that adds ES6 promises to sqlite3 (docs).

  • Node.js v5 or higher
  • Babel JavaScript compiler (optional, but highly recommended)
import express from 'express';
import Promise from 'bluebird';
import db from 'sqlite';
 
const server = express();
const port = process.env.PORT || 3000;
 
server.get('/', async (req, res, next) => {
  try {
    const row = await db.get(`SELECT * FROM tableName WHERE id = ?`, 123);
    res.send(`Hello, ${row.columnName}!`);
  } catch (err) {
    next(err);
  }
});
 
db.open('./db.sqlite', { verbose: true, Promise })
  .catch(err => console.error(err))
  .finally(() => {
    server.listen(port, () => {
      console.log(`Node.js app is running at http://localhost:${port}/`);
    });
  });

The MIT License © 2015 Kriasoft, LLC. All rights reserved.


Made with ♥ by Konstantin Tarkus (@koistya)