*** DRAFT ***

SQLite Release 3.48.0 On 2025-01-01

  1. Refactor the "configure" script used to help build SQLite from sources. Fix bugs, make it faster and easier to use, and make it more maintainable long-term.
  2. Add the SQLITE_IOCAP_SUBPAGE_READ property to the xDeviceCharacteristics method of the sqlite3_io_methods object.
  3. Improved EXPLAIN QUERY PLAN output for covering indexes.
  4. Allow a two-argument version of the iif() SQL function. Also allow if() as an alternative spelling for iif().

    Hashes:

  5. SQLITE_SOURCE_ID: pending
  6. 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 ***