What SQLite to use with nodejs

Alternatively, you could use a javascript embedded database. This way you just need to declare the database as a dependency in your package.json and require() it in your application.

Check out NeDB (which I wrote) or nStore for example.

For my architecture synchronous better-sqlite3 appeared to be better:

https://www.npmjs.com/package/better-sqlite3

• Full transaction support
• Geared for performance, efficiency, and safety
• Easy-to-use synchronous API (faster than an asynchronous API)
• Custom SQL function support
• 64-bit integer support (invisible until you need it)

SQLite Client for Node.js Apps /w built-in SQL-based migrations API

import express from 'express';
import db from 'sqlite';                                       // <=
import Promise from 'bluebird';

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

app.get('/posts', async (req, res, next) => {
  try {
    const posts = await db.all('SELECT * FROM Post LIMIT 10'); // <=
    res.send(posts);
  } catch (err) {
    next(err);
  }
});

Promise.resolve()
  // First, try to open the database
  .then(() => db.open('./database.sqlite', { Promise })        // <=
  // Update db schema to the latest version using SQL-based migrations
  .then(() => db.migrate({ force: 'last' })                    // <=
  // Display error message if something went wrong
  .catch((err) => console.error(err.stack))
  // Finally, launch the Node.js app
  .finally(() => app.listen(port));

NOTE: The example above only works with Node.js v6 and newer (assuming that import and async/await language features used in the code are transpalied with Babel). For earlier versions of Node.js use var db = require('sqlite/legacy');.

I have switched from https://github.com/mapbox/node-sqlite3 to https://github.com/JoshuaWise/better-sqlite3. One of reasons is better-sqlites author gave me a thorough answer, https://github.com/JoshuaWise/better-sqlite3/issues/181, about why https://github.com/JoshuaWise/better-sqlite3#why-should-i-use-this-instead-of-node-sqlite3

Grumdrig's module seems to be the one referenced the most on Stack Overflow, and on other sites as well.

Also, the documentation is pretty good: http://github.grumdrig.com/node-sqlite/

I have rather little experience with Node SQLite, but the community seems to have chosen.