Small. Fast. Reliable.
Choose any three.

SQLite Release 3.31.0 On 2020-01-31

  1. Add support for generated columns.
  2. Add the sqlite3_hard_heap_limit64() interface and the corresponding PRAGMA hard_heap_limit command.
  3. Add the aggregated mode feature to the DBSTAT virtual table.
  4. Add the SQLITE_OPEN_NOFOLLOW option to sqlite3_open_v2() that prevents SQLite from opening symbolic links.
  5. Added the "#-N" array notation for JSON function path arguments.
  6. Faster response to sqlite3_interrupt().
  7. Added the uuid.c extension module implementing functions for processing RFC-4122 UUIDs.
  8. The legacy_file_format pragma is deactivated. It is now a no-op. In its place, the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config() is provided. The legacy_file_format pragma is deactivated because (1) it is rarely useful and (2) it is incompatible with VACUUM in schemas that have tables with both generated columns and descending indexes. Ticket 6484e6ce678fffab

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.