Small. Fast. Reliable.
Choose any three.
SQLite Release 3.33.0 On 2020-08-14
- Support for UPDATE FROM following the PostgreSQL syntax.
- Increase the maximum size of database files to 281 TB.
- Extended the PRAGMA integrity_check statement so that it can optionally be
limited to verifying just a single table and its indexes, rather than the
entire database file.
- Added the decimal extension for doing arbitrary-precision decimal arithmetic.
- Enhancements to the ieee754 extension for working with IEEE 754 binary64 numbers.
- CLI enhancements:
- Added four new output modes: "box", "json", "markdown",
- The "column" output mode automatically expands columns to
contain the longest output row and automatically turns
".header" on if it has not been previously set.
- The "quote" output mode honors ".separator"
- The decimal extension and the ieee754 extension are built-in to the CLI
- Query planner improvements:
- Add the ability to find a
full-index-scan query plan for queries using INDEXED BY
which previously would fail with "no query solution".
- Do a better job of
detecting missing, incomplete, and/or dodgy sqlite_stat1
data and generates good query plans in spite of the
- Improved performance of queries like "SELECT min(x) FROM t WHERE y IN (?,?,?)"
assuming an index on t(x,y).
- In WAL mode, if a writer crashes and leaves the shm file in an inconsistent
state, subsequent transactions are now able to recover the shm file even if
there are active read transactions. Before this enhancement, shm file recovery
that scenario would result in an SQLITE_PROTOCOL error.
- SQLITE_SOURCE_ID: 2020-08-14 13:23:32 fca8dc8b578f215a969cd899336378966156154710873e68b3d9ac5881b0ff3f
- SHA3-256 for sqlite3.c: d00b7fffa6d33af2303430eaf394321da2960604d25a4471c7af566344f2abf9
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.