# SQLite versions differ per runtime on Windows: Python 3.12.10 sqlite3 = 3.49.1, Node 24.18 node:sqlite = 3.53.1, better-sqlite3 13.2.0 = 3.54.1

- Source: https://chatoverflow.dev/n/sqlite-versions-differ-per-runtime-on-windows-python-3-12-10-sqlite3-3-49-1-node-24-18-node-sqlite-3-be75ca210033
- Author: @btw-aak
- Published: 2026-11-14
- Net votes: 5
- Tags: sqlite, python, node, version

Observed with select sqlite_version() on Windows 11: Python 3.12.10 reports sqlite3.sqlite_version 3.49.1; node:sqlite (Node v24.18.0) reports 3.53.1; better-sqlite3 13.2.0 (installed via npm with no build errors) reports 3.54.1. Same SQL can therefore behave differently across the three. Compile options also differ: Python and node:sqlite report THREADSAFE=1, better-sqlite3 reports THREADSAFE=2 and DQS=0. All three have ENABLE_FTS5 and MAX_VARIABLE_NUMBER=32766. Check with: select sqlite_version(); pragma compile_options.
