Releases
19 versions from Nov 14 to Nov 18, 2026. 2 MINOR releases and 16 PATCH releases came after the first release.
Each mark is one version, on a time axis in UTC. Select a mark to show its changes.
- MINOR: new features (before 1.0.0, also a change of the API)
- PATCH: fixes and small additions
- The first release
5 changes in 1 package. The changes with the most packages come first.
syncedTransaction(db, work, options)does the work in oneBEGIN IMMEDIATEtransaction whose commit is on the disk when the function ends.A call in a transaction in progress throws.
On a connection with
NORMAL, it setssynchronoustoFULLfor its commit, and sets the earlier value again at the end.The power-cut test has two new cases.
The type
SyncedTransactionDatabaseis the part of a connection that the function uses.
3 changes in 1 package. The changes with the most packages come first.
FULLandEXTRAkept each commit.The README has the section "What a power cut keeps".
The row
synchronousof the options table links to the section.
4 changes in 1 package. The changes with the most packages come first.
A test does a garbage collection after each 1000 events of a salvage of 50000 events.
On Node.js 22.13, a garbage collection during the read of the broken log can finalize the statement of the read.
The salvage reads the broken log in pages of 500 rows with
all().Then the salvage stops with the error
ERR_INVALID_STATE, andopenCheckedEventLogcannot recover the file.
10 changes in 1 package. The changes with the most packages come first.
listRecoveries(path)gives each recovery from the records in the quarantine folders, in the sequence ofatand then ofid.openCheckedEventLog(path, parse, options)opens a log in its own file after an integrity check.A broken file goes into quarantine, and a new file gets each readable event.
A folder with no record, or with a record that does not parse, gives an entry of the kind
no-read.A test stops the recovery after each step and opens the file again.
A WAL, SHM or journal file with no database file goes into quarantine.
Each step of the recovery can be done again.
The
idof an entry is the name of its quarantine folder.The result is a tagged union with the kinds
created,opened,recoveredandorphan-journal.The types
CheckedEventLogOptions,RecoveryCause,RecoveryEntryandSalvageCountsare new.
3 changes in 1 package. The changes with the most packages come first.
confineToFiletakes aDatabaseSyncof each version of@types/node.The parameter type is
DatabaseSync | ConfinableDatabase.The typecheck of the package also examines the source and a type test with
@types/node22 (tsconfig.node22.json).
9 changes in 1 package. The changes with the most packages come first.
confineToFile(db)keeps the SQL of anode:sqliteconnection on its file.eachStatement(db, sql)gives each statement of a SQL text in order.eachStatementcompiles the next statement after the run of the statement before it.Each other statement runs as before.
The guard does not limit the time or the size of the work of a caller.
The guard is the authorizer of SQLite, so it sees the statement after the parse.
The guard needs
setAuthorizerof Node.js 24.10 or later.The type
ConfinableDatabaseis the part of a connection that the guard uses.The types
SourcedStatementandStatementSourceare the parts of a statement and a connection thateachStatementuses.
5 changes in 1 package. The changes with the most packages come first.
eventLogandsalvageEventLogkeep a reference to the statement of a read.sqlJsConnectioncompiles a statement for each call and frees it after the call.transaction,readTransaction,checkpoint,clearDatabaseandeventLogread the transaction state through one function.The
enginesfield asks for Node.js 22.13, not 22.16.The tests do not use
isOpenor FTS5, because Node.js 22.13 has neither.
9 changes in 1 package. The changes with the most packages come first.
checkpointrunsPRAGMA wal_checkpointand gives its counts.clearDatabasedrops each view and each table, and setsuser_versionto 0, for a cache that makes its tables again.openDatabaseandsalvageEventLoguse the classDatabaseofnode:sqlitewhen it is there.openDatabasetakesreadOnly: the connection reads an existing file and does not change it.sqlJsConnectiongives aSqlConnectionover a database of sql.js.transactiontakescommit: false: a dry run.A Node.js before 22.16 has no
isTransaction.Both entries export the new functions and types.
One suite of tests runs the portable entry on
node:sqlite, SQLite in WebAssembly and sql.js.
4 changes in 1 package. The changes with the most packages come first.
readTransactiondoes a work on one snapshot of the file.The commit, the rollback, the synchronous work and the option
nestedare the same as intransaction.The type
ReadTransactionDatabaseis new.The work cannot write:
PRAGMA query_onlyis on during the work.
3 changes in 1 package. The changes with the most packages come first.
The
parseofeventLog,openEventLogandsalvageEventLogis a function or a validator of the Standard Schema, for example a schema of zod 4.The types
Parse,StandardSchema,StandardResultandStandardIssueare new.When the schema refuses a stored value, the read throws, and its
causeis the newSchemaErrorwith each problem.
4 changes in 1 package. The changes with the most packages come first.
wasmConnectiongives aSqlConnectionover a database of@sqlite.org/sqlite-wasm.In the entry
/portable, the default type ofMigrationandProjectionOptionsisSqlConnection, notDatabaseSync.In the main entry, the default stays
DatabaseSync.The test of the entry
/portablealso follows eachimport type.
5 changes in 1 package. The changes with the most packages come first.
migrate,schemaVersion,userVersion,tableColumns,addMissingColumns,ensureProjection,eventLogandtransactiontake aSqlConnection.MigrationandProjectionOptionstake the type of the connection as a parameter.A test follows the imports of the new entry, and fails when its JavaScript gets to a module out of the package.
The new entry has the migrations, the projections, the write transaction and the event log.
The types
SqlConnection,SqlStatement,SqlValueandSqlChangesare new.
3 changes in 1 package. The changes with the most packages come first.
The option
newerofmigratetells what a file or a part of a newer schema version does.The type
Neweris new.With
newer: "keep",migratedoes no step on a newer file and gives{ from, to: from }.
5 changes in 1 package. The changes with the most packages come first.
ensureProjectionmakes the schema of a projection, for example an index or a cache.The option
checktells if a file of the correct version has the projection.The types
ProjectedandProjectionOptionsare new.With
foreign_keyson, a rebuild setsdefer_foreign_keys, and the checks of the foreign keys wait for the commit.Without a part, the projection owns the whole file.
4 changes in 1 package. The changes with the most packages come first.
addMissingColumnsadds each column that a table does not have, and gives the names of the added columns.tableColumnsgives the columns of a table in their order.The README has a recipe: a first step with
CREATE TABLE IF NOT EXISTSandaddMissingColumnsadopts a file atuser_version0.The type
ColumnDefinitionsis new.
3 changes in 1 package. The changes with the most packages come first.
eventLoghas the optionnested.transactionhas the optionnested.The type
Nestedis new.
5 changes in 1 package. The changes with the most packages come first.
checkIntegritydoes the integrity check of SQLite and gives the problems.openOrQuarantineopens a file, and moves a broken file into quarantine before a second open.quarantinemoves a file and its WAL, SHM and journal files into a new folder.salvageEventLogreads the readable events of a broken log into a new log, and counts the lost positions.snapshotwrites a consistent copy of an open database withVACUUM INTO.
10 changes in 1 package. The changes with the most packages come first.
appendgives one result:added,duplicate,conflictorrefused.entries,getandheadare new, andreadhas the optionsafter,typesandlimit.EVENT_LOG_SCHEMA_VERSIONis 2: the second step adds an index on the type.eventLogopens a log in a table of a connection of the caller.migratehas the optionpart: each part of a file has its own version in the tableschema_versions.sqliteFaultgives the kind of an error of SQLite and the action that it needs:retry,quarantine,operatororbug.A broken log throws a
BrokenLogError.An event with an id that the log has does not throw and does not break the log.
The argument
acceptis optional.The new option
equalsets the equality of two events.
5 changes in 1 package. The changes with the most packages come first.
migrateanduserVersiondo the steps of a schema byuser_version.openDatabaseopens a connection with WAL, the pragmasynchronousand a busy timeout.openEventLogopens a typed append-only event log, withrecoverafter a failed write.transactiondoes a work in oneBEGIN IMMEDIATEtransaction.The entry
./warningremoves the experimental warning ofnode:sqlite.
Source: the CHANGELOG.md files, the git tags, the GitHub releases and npm, read when the site was built.