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.

Unix explained by its creators

 Most of computers now run or use some variant of Unix.

Here is clear explanation why it was crated 50+ years ago

Ken Thompson and Dennis Ritchie Explain UNIX (Bell Labs) - YouTube


Pushing the Limits of Technology: The Ken Thompson and Dennis Ritchie Story - YouTube