René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite: `enableDefensive()` is lost after `close()`/`open()`","articleBody":"### Version\n\nmain\n\n### Platform\n\n```text\nmacOS 26.7.0\n```\n\n### Subsystem\n\nsqlite\n\n### What steps will reproduce the bug?\n\n```js\nimport { Database } from 'node:sqlite';\n\nconst db = new Database(':memory:', { defensive: false });\ndb.enableDefensive(true);\ndb.close();\ndb.open();\ndb.exec('PRAGMA writable_schema=ON');\ndb.exec(\"UPDATE sqlite_schema SET sql='x'\"); // succeeds; defensive is off again\nconsole.log('UPDATE succeeded');\n```\n\n### How often does it reproduce? Is there a required condition?\n\nAlways\n\n### What is the expected behavior? Why is that the expected behavior?\n\nWith defensive mode on, SQLite ignores `PRAGMA writable_schema=ON` ([`SQLITE_DBCONFIG_DEFENSIVE`](https://www.sqlite.org/c3ref/c_dbconfig_defensive.html)), so the `UPDATE` should fail with `table sqlite_master may not be modified`, as it does without the reopen.\n\n### What do you see instead?\n\n```console\nUPDATE succeeded\n```\n\n### Additional information\n\n_No response_","author":{"url":"https://github.com/trivikr","@type":"Person","name":"trivikr"},"datePublished":"2026-09-30T06:08:41Z","url":"https://github.com/nodejs/node/issues/66403"}