SQLite
Definition
Recent developments
forwardemail/sqlite-benchmarks. Comprehensive SQLite performance benchmarking suite testing PRAGMA settings, WAL mode, encryption. Results across Node.js v18-v26 with better-sqlite3 and better-sqlite3-multiple-ciphers. Sample: better-sqlite3 on Node v26 achieves ~30K inserts/sec, ~34K selects/sec, ~53K updates/sec, ~90K deletes/sec. Encrypted variant roughly 1/3 performance of plain. Per GitHub (forwardemail/sqlite-benchmarks) (2026-05-16).
WiseLibs/better-sqlite3 releases. v12.10.0, v12.9.1 (caution: Electron v39+ prebuilds failing). v12.8.0 updates SQLite to 3.51.3 (due to 3.52.0 withdrawal over WAL-reset bug). v12.7.1 rolls back to 3.51.2. Node.js v20+ required. Percentile functions enabled. Per GitHub (WiseLibs/better-sqlite3) (2026-03-13).
3.53.x line fixed a WAL-reset corruption bug and added several core features. 3.53.0 (April 9) shipped the WAL-reset fix plus ALTER TABLE support for adding/removing NOT NULL and CHECK constraints, REINDEX EXPRESSIONS syntax, a new Query Result Formatter (QRF) for the CLI,
json_array_insert()/jsonb_array_insert(), and a self-healing index feature; 3.53.2 (June 3) added a WASMopfs-wlVFS and dropped Windows RT support; 3.53.3 (June 26) added new C interfaces (sqlite3_str_truncate(),sqlite3_carray_bind_v2(),SQLITE_PREPARE_FROM_DDL,SQLITE_LIMIT_PARSER_DEPTH) and query-planner improvements for EXCEPT/INTERSECT/UNION, join order, and EXISTS-to-JOIN rewrites; floating-point-to-text conversion now defaults to 17 significant digits. Per SQLite's own release logs (3.53.0 through 3.53.3). Sources: GitHub (forwardemail/sqlite-benchmarks) · GitHub (WiseLibs/better-sqlite3)
Connections 1
Outbound 1
scoped_to1