examples/defaults-v24.mjs
GitHub// @node-skills {"added":["v26.3.0","v24.18.0"]}
// Defaults already changed on v24 LTS: Buffer.poolSize 8192 -> 65536 (v26.3.0, v24.18.0);
// SQLite `defensive` on by default (v25.5.0, v24.14.0).
import assert from 'node:assert/strict';
import { DatabaseSync } from 'node:sqlite';
assert.equal(Buffer.poolSize, 65536);
const pragma = (db) => { db.exec('PRAGMA writable_schema = ON'); return db.prepare('PRAGMA writable_schema').get().writable_schema; };
assert.equal(pragma(new DatabaseSync(':memory:')), 0); // defensive: ignored
assert.equal(pragma(new DatabaseSync(':memory:', { defensive: false })), 1); // opt out explicitly