JSPM – sqlite@1.0.0

Package Exports

sqlite
sqlite/legacy

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (sqlite) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

SQLite client library for Node.js applications

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

How to Install

$ npm install sqlite --save

How to Use

This module has the same API as the original SQLite3 library except that all its API methods return promises and do not accept callback arguments.

Below is an example of how to use it with Node.js/Express and Babel:

import express from 'express';
import Promise from 'bluebird';
import db from 'sqlite';

const app = express();
const port = process.env.PORT || 3000;

app.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);
  }
});

// Connect to the database before launching Node.js app
db.open('./database.sqlite', { verbose: true, Promise })
  .catch(err => console.error(err))
  .finally(() => {
    app.listen(port, () => {
      console.log(`Node.js app is running at http://localhost:${port}/`);
    });
  });

NOTE: For Node.js v5 and below use var db = require('sqlite/legacy'); instead.

React Starter Kit — Isomorphic web app boilerplate (Node.js/Express, React.js, GraphQL)
Babel Starter Kit — JavaScript library boilerplate (ES2015, Babel, Rollup)
Membership Database — SQL database boilerplate for web app users, roles and auth tokens

License

Made with ♥ by Konstantin Tarkus (@koistya) and contributors

sqlite