NodeJS: Save SQLite in-memory database to a file

Milos Vuckovic — Sat, 20 Apr 2024 18:10:48 +0000

One may use VACUUM SQL statement to save SQLite in-memory database to a file. This is a working example:

import { Database } from 'sqlite3';
import { promisify } from 'util';

const filepath = "C:\\temp\\db";

const createContactsTableSql = `
  CREATE TABLE contacts (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name VARCHAR(30) NOT NULL,
    email VARCHAR(30) NOT NULL
  )
`;

const insertContactsSql = `
  INSERT INTO
    contacts (name, email)
  VALUES
    ('John Smith', 'john.smith@example.com'),
    ('Jane Doe', 'jane.doe@example.com')
`;

const vacuumSql = `VACUUM MAIN INTO "${filepath}"`;

(async function main() {
  const db = new Database(':memory:');
  const exec = promisify(db.exec.bind(db));
  await exec(createContactsTableSql);
  await exec(insertContactsSql);
  await exec(vacuumSql);
})();

Angular: Table with resizable columns

Milos Vuckovic — Fri, 16 Dec 2022 10:16:46 +0000

Implementation of a table with resizable columns in Angular using directive:

https://stackblitz.com/edit/angular-ivy-uwmjup

DEV Community: Milos Vuckovic

NodeJS: Save SQLite in-memory database to a file

Angular: Table with resizable columns