NodeJS: Save SQLite in-memory database to a file

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', '[e-mail]'),
    ('Jane Doe', '[e-mail]')
`;

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);
})();