Small. Fast. Reliable.
Choose any three.
SQLite Release 3.32.1 On 2020-05-25
Changes in version 3.32.0 (2020-05-22):
- Added support for approximate ANALYZE using the
PRAGMA analysis_limit command.
- Added the bytecode virtual table.
- Add the checksum VFS shim to the set of run-time loadable
extensions included in the source tree.
- Added the iif() SQL function.
- INSERT and UPDATE statements now always apply column affinity
before computing CHECK constraints. This bug fix could, in
theory, cause problems for legacy databases with unorthodox
CHECK constraints the require the input type for an INSERT
is different from the declared column type. See ticket
for more information.
- Added the sqlite3_create_filename(), sqlite3_free_filename(),
interfaces to better support of VFS shim implementations.
- Increase the default upper bound
on the number of parameters from 999 to 32766.
- Added code for the UINT collating sequence as an optional
- Enhancements to the CLI:
- Add options to the .import command: --csv, --ascii, --skip
- The .dump command now accepts multiple LIKE-pattern arguments
and outputs the union of all matching tables.
- Add the .oom command in debugging builds
- Add the --bom option to the .excel, .output, and .once
- Enhance the .filectrl command to support the --schema option.
- The UINT collating sequence extension is automatically loaded
- The ESCAPE clause of a LIKE operator now overrides wildcard
characters, so that the behavior matches what PostgreSQL does.
Additional changes in version 3.32.1:
- Fix two long-standing bugs that allow malicious SQL statements
to crash the process that is running SQLite. These bugs were announced
by a third-party approximately 24 hours after the 3.32.0 release but are
not specific to the 3.32.0 release.
- Other minor compiler-warning fixes and whatnot.
- SQLITE_SOURCE_ID: 2020-05-25 16:19:56 0c1fcf4711a2e66c813aed38cf41cd3e2123ee8eb6db98118086764c4ba83350
- SHA3-256 for sqlite3.c: f695ae21abf045e4ee77980a67ab2c6e03275009e593ee860a2eabf840482372
A complete list of SQLite releases
in a single page and a chronology are both also available.
A detailed history of every
check-in is available at
SQLite version control site.