*** DRAFT ***

SQLite Release 3.46.0 On 2024-07-01

  1. Enhance PRAGMA optimize in multiple ways, to make it simpler to use:
    1. PRAGMA optimize automatically implements a temporary analysis limit to prevent excess runtime on large databases.
    2. Added the new 0x10000 bitmask option to check for updates on all tables.
    3. Automatically re-analyze tables that do not have sqlite_stat1 entries.
  2. Enhance the strftime() SQL function to support %G, %g, %U, and %V.
  3. Add support for underscore ("_") characters between digits in numeric literals.
  4. Allocate additional memory from the heap for the SQL parser stack if that stack overflows, rather than reporting a "parser stack overflow" error.
  5. Allow the use of an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records.
  6. Allow ASCII control characters within JSON5 string literals.
  7. Allow large hexadecimal literals to be used as the DEFAULT value to a table column.


  8. SQLITE_SOURCE_ID: pending
  9. SHA3-256 for sqlite3.c: pending

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.

*** DRAFT ***