sqlite.js

const fastify = require("fastify");
const sqlite3 = require("sqlite3");
const { nanoid } = require("nanoid");

const app = fastify();
const db = new sqlite3.Database(":memory:");

db.serialize();
db.run(`
CREATE TABLE data (
  id    INTEGER PRIMARY KEY AUTOINCREMENT,
  value TEXT NOT NULL
);
`);

for (let i = 0; i < 1000; i++) {
  db.run(`INSERT INTO data (value) VALUES (?)`, nanoid());
}

db.parallelize();

app.get("/", (req, res) => {
  db.all("SELECT * FROM data", (_, rows) => {
    res.send(rows);
  });
});

app.listen(9999);

console.log("");
console.log("Running on http://127.0.0.1:9999/");
console.log("Ctrl-c to stop");
console.log("");