Wednesday, July 24, 2024

node:sqlite: node.js embedded sqlite

 lib,src,test,doc: add node:sqlite module by cjihrig · Pull Request #53752 · nodejs/node

import { DatabaseSync } from 'node:sqlite';
const database = new DatabaseSync(':memory:');

// Execute SQL statements from strings.
database.exec(`
  CREATE TABLE data(
    key INTEGER PRIMARY KEY,
    value TEXT
  ) STRICT
`);

Node.js v22.5.0 (Current) Released – But Don't Install It! — A notable release for three reasons: first, the WebSocket feature in node:http is now exposed. Second, remember how Node is embedding SQLite? node:sqlite is now included and ready to play with. Third, however, v22.5.0 introduced a nasty bug, so you'll want to try v22.5.1 instead.

No comments: