SQLite

Databases & Data

The most widely deployed database engine in the world, embedded everywhere.

Latest 3.53.4 · by SQLiteWebsiteRSS

Release activity

Release activity — 8 releases across 8 days since Mar 6, 2026. Each cell is one day; darker means more releases that day. Nothing is recorded before Mar 6, 2026. Older weeks are hidden at this screen width.
JunJulAugSep
SundayNo releases on May 24, 2026No releases on May 31, 2026No releases on Jun 7, 2026No releases on Jun 14, 2026No releases on Jun 21, 2026No releases on Jun 28, 2026No releases on Jul 5, 2026No releases on Jul 12, 2026No releases on Jul 19, 2026No releases on Jul 26, 2026No releases on Aug 2, 2026No releases on Aug 9, 2026No releases on Aug 16, 2026No releases on Aug 23, 2026No releases on Aug 30, 2026No releases on Sep 6, 2026
MondayNo releases on May 25, 2026No releases on Jun 1, 2026No releases on Jun 8, 2026No releases on Jun 15, 2026No releases on Jun 22, 2026No releases on Jun 29, 2026No releases on Jul 6, 2026No releases on Jul 13, 2026No releases on Jul 20, 2026No releases on Jul 27, 2026No releases on Aug 3, 2026No releases on Aug 10, 2026No releases on Aug 17, 2026No releases on Aug 24, 2026No releases on Aug 31, 2026No releases on Sep 7, 2026
TuesdayNo releases on May 26, 2026No releases on Jun 2, 2026No releases on Jun 9, 2026No releases on Jun 16, 2026No releases on Jun 23, 2026No releases on Jun 30, 2026No releases on Jul 7, 2026No releases on Jul 14, 2026No releases on Jul 21, 2026No releases on Jul 28, 2026No releases on Aug 4, 2026No releases on Aug 11, 2026No releases on Aug 18, 2026No releases on Aug 25, 2026No releases on Sep 1, 2026No releases on Sep 8, 2026
WednesdayNo releases on May 27, 20261 release on Jun 3, 2026No releases on Jun 10, 2026No releases on Jun 17, 2026No releases on Jun 24, 2026No releases on Jul 1, 2026No releases on Jul 8, 2026No releases on Jul 15, 2026No releases on Jul 22, 2026No releases on Jul 29, 2026No releases on Aug 5, 20261 release on Aug 12, 2026No releases on Aug 19, 2026No releases on Aug 26, 2026No releases on Sep 2, 2026No releases on Sep 9, 2026
ThursdayNo releases on May 28, 2026No releases on Jun 4, 2026No releases on Jun 11, 2026No releases on Jun 18, 2026No releases on Jun 25, 2026No releases on Jul 2, 2026No releases on Jul 9, 2026No releases on Jul 16, 2026No releases on Jul 23, 2026No releases on Jul 30, 2026No releases on Aug 6, 2026No releases on Aug 13, 2026No releases on Aug 20, 2026No releases on Aug 27, 2026No releases on Sep 3, 2026No releases on Sep 10, 2026
FridayNo releases on May 29, 2026No releases on Jun 5, 2026No releases on Jun 12, 2026No releases on Jun 19, 20261 release on Jun 26, 2026No releases on Jul 3, 2026No releases on Jul 10, 2026No releases on Jul 17, 20261 release on Jul 24, 2026No releases on Jul 31, 2026No releases on Aug 7, 2026No releases on Aug 14, 2026No releases on Aug 21, 2026No releases on Aug 28, 2026No releases on Sep 4, 2026No releases on Sep 11, 2026
SaturdayNo releases on May 30, 2026No releases on Jun 6, 2026No releases on Jun 13, 2026No releases on Jun 20, 2026No releases on Jun 27, 2026No releases on Jul 4, 2026No releases on Jul 11, 2026No releases on Jul 18, 2026No releases on Jul 25, 2026No releases on Aug 1, 2026No releases on Aug 8, 2026No releases on Aug 15, 2026No releases on Aug 22, 2026No releases on Aug 29, 2026No releases on Sep 5, 2026

8 releases since Mar 6, 2026

Changelog

bug-2026-08-12T09_26_04Z: Do not use the propagate-constant optimization on a constant that is

View originalPermalink
How bug-2026-08-12T09_26_04Z: Do not use the propagate-constant optimization on a constant that is went
3.53.4Latest

version-3.53.4: Version 3.53.4

Fixed 1
  • Fix problems in 3.53.0, 3.53.1, 3.53.2, and 3.53.3

From SQLite

  • Fixes for problems in 3.53.0 (and 3.53.1, 3.53.2, and 3.53.3) mostly coming from AIs. See the check-in timeline for details. Hashes:
  • SQLITE_SOURCE_ID: 2026-07-24 19:02:57 bf7c7f30031888f4e796e429ab3978879485813aaca6f641c7b33e4e09459bcc
  • SHA3-256 for sqlite3.c: 67f423e9ebbbdc473cbc4772c872ee6b89f31fde4ed0279a5c25d5f65c043a16
View originalPermalink
How 3.53.4 went
3.53.3

version-3.53.3: Version 3.53.3

Fixed 1
  • Fix problems from version 3.53.0 and subsequent releases

From SQLite

  • Fixes for problems in 3.53.0 (and 3.53.1 and 3.53.2) mostly coming from AIs. See the check-in timeline for details. Hashes:
  • SQLITE_SOURCE_ID: 2026-06-26 20:14:12 d4c0e51e4aeb96955b99185ab9cde75c339e2c29c3f3f12428d364a10d782c62
  • SHA3-256 for sqlite3.c: 28e484abdaa43630e34040ef6ed92be973a1ad54107803d8af5145b889c23ed7
View originalPermalink
How 3.53.3 went
3.53.2

version-3.53.2: Version 3.53.2

Fixed 1
  • Fixes for problems in 3.53.0 reported by users

From SQLite

  • Fixes for problems in 3.53.0 reported by users. See the check-in timeline for details. Hashes:
  • SQLITE_SOURCE_ID: 2026-06-03 19:12:13 d6e03d8c777cfa2d35e3b60d8ec3e0187f3e9f99d8e2ee9cac695fd6fcdf1a24
  • SHA3-256 for sqlite3.c: 44fd61b9f93b4155105cb2d80c957ae6c64a8b5bd6ed51a4992f0dbd438e4e11
View originalPermalink
How 3.53.2 went
3.53.1

version-3.53.1: Version 3.53.1

Fixed 1
  • Fix problems in 3.53.1 reported by users

From SQLite

  • Fixes for problems in 3.53.1 reported by users. See the check-in timeline for details. Hashes:
  • SQLITE_SOURCE_ID: 2026-05-05 10:34:17 c88b22011a54b4f6fbd149e9f8e4de77658ce58143a1af0e3785e4e6475127e9
  • SHA3-256 for sqlite3.c: 414432ae5719f6cdc485f3927e12c7ad107e2b8c6b434e5df2eadb5312bfabb5
View originalPermalink
How 3.53.1 went
3.53.0

version-3.53.0: Version 3.53.0

Added 17
  • Add the Query Result Formatter (QRF) library for formatting the results of SQL queries for human readability on a fixed-pitch font screen
  • Add the format method to the TCL Interface so that QRF is accessible from TCL
  • Add the REINDEX EXPRESSIONS statement to rebuild expression indexes
  • Add the json_array_insert() SQL function
  • Add the jsonb_array_insert() SQL function
  • Add the --timeout S option to the .progress dot-command to interrupt SQL statements after S seconds
Changed 19
  • Use QRF for result formatting in the CLI, resulting in improved display capabilities
  • Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints
  • Allow the body of TEMP triggers to modify and query tables in the main schema
  • Enhance VACUUM INTO so that a reserve=N query parameter on the target URI sets the reserve amount for the generated database copy
  • Make major enhancements to the .mode command
  • Improve result formatting in the CLI with numeric values now right-justified by default in tabular output modes
Fixed 2
  • Fix the WAL-reset database corruption bug
  • Fix the .testcase and .check commands so that they actually work
Removed 1
  • Discontinue support for Windows RT

From SQLite

  • Fix the WAL-reset database corruption bug.
  • Add the Query Result Formatter (QRF) library for formatting the results of SQL queries for human readability on a fixed-pitch font screen.
  • Add the format method to the TCL Interface so that QRF is accessible from TCL.
  • QRF is used for result formatting in the CLI, resulting in improved display capabilities.
  • New SQL language features:
  • Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints.
  • The REINDEX EXPRESSIONS statement rebuilds expression indexes. (Useful to repair stale expression indexes.)
  • The body of TEMP triggers may now modify and/or query tables in the main schema.
  • Enhance VACUUM INTO so that if a URI filename is used as the target and that filename has a reserve=N query parameter with N between 0 and 255, then the reserve amount for the generated database copy is set to N.
  • New SQL functions:
  • json_array_insert()
  • jsonb_array_insert()
  • Renovations to the CLI:
  • Major enhancements to the .mode command.
  • Improved result formatting, due to the addition of the QRF extension. For example, numeric values are now right-justified by default in tabular output modes.
  • The default output mode for interactive CLI sessions now uses QRF to display query results in boxes formed using Unicode box-drawing characters, for improved legibility. Batch CLI sessions use the legacy output format for compatibility.
  • Bare (unquoted) semicolons at the end of dot-commands are silently ignored.  ← Potential incompatibility!
  • Fix the .testcase and .check commands so that they actually work, and use those commands in scripts that are part of the standard SQLite test suite included with the source tree.
  • Command-line arguments that match *.sql or *.txt and are the names of non-empty files are read and interpreted as scripts of SQL statements and/or dot-commands.
  • The argument to the ".timer" command can now be "once", to run the timer on only the next SQL statement.
  • The new "--timeout S" option to the ".progress" dot-command causes SQL statements to interrupt after S seconds.
  • The ".indexes" command was changed so that the PATTERN argument matches the name of the index, not the name of the table being indexed (thus making the PATTERN argument actually useful). And, several new options were added to ".indexes".
  • New C-language interfaces:
  • sqlite3_str_truncate()
  • sqlite3_str_free()
  • sqlite3_carray_bind_v2()
  • Add the SQLITE_PREPARE_FROM_DDL option to sqlite3_prepare_v3() which permits virtual table implementations to safely prepare SQL statements that are derived from the database schema.
  • Added the SQLITE_UTF8_ZT constant which can be used as the encoding parameter to sqlite3_result_text64() or sqlite3_bind_text64() to indicate that the value is UTF-8 encoded and zero terminated.
  • The SQLITE_LIMIT_PARSER_DEPTH option is added to sqlite3_limit().
  • The SQLITE_DBCONFIG_FP_DIGITS option is added to sqlite3_db_config(). See also item 9b below.
  • Query planner improvements:
  • Always use a sort-and-merge algorithm for EXCEPT, INTERSECT, and UNION, since this is almost always faster than using a hash table.
  • Improvements to join order selection in large multi-way joins on a star schema.
  • Enhance the EXISTS-to-JOIN optimization so that the inserted JOIN terms are not required to be on the inner-most loops, as long as all dependencies for the EXISTS-to-JOIN loops are in outer loops.
  • Enhance the omit-noop-join optimization so that it is able to omit a chain of joins that do not affect the output.
  • Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2 are identical apart from ASC/DESC sort-orders to be optimized using a single index.
  • Allow virtual tables to optimize DISTINCT in cases where the result-set of a query does not exactly match the ORDER BY clause.
  • Add new interfaces to the session extension that enable an application to add changes one at a time to the sqlite3_changegroup object:
  • sqlite3changegroup_change_begin()
  • sqlite3changegroup_change_blob()
  • sqlite3changegroup_change_double()
  • sqlite3changegroup_change_int64()
  • sqlite3changegroup_change_null()
  • sqlite3changegroup_change_text()
  • sqlite3changegroup_change_finish()
  • sqlite3changegroup_config()
  • Improvements to floating-point ↔ text conversions.
  • Reimplemented to improve performance.
  • Rounding is now done by default to 17 significant digits, instead of 15, as was the case for all prior versions. The sqlite3_db_config(SQLITE_DBCONFIG_FP_DIGITS) API (item 6g above) can change this, if desired.
  • Added the self-healing index feature to deal with the stale expression index problem.
  • Add the "-p|--port" option to sqlite3_rsync.
  • Discontinue support for Windows RT.
  • JavaScript/WASM
  • Add the "opfs-wl" VFS, functionally identical to the "opfs" VFS but using Web Locks for locking, which can promise fairer lock sharing than the "opfs" bespoke protocol can. "opfs-wl" requires Atomics.waitAsync(), so requires newer browsers than "opfs" does. Hashes:
  • SQLITE_SOURCE_ID: 2026-04-09 11:41:38 4525003a53a7fc63ca75c59b22c79608659ca12f0131f52c18637f829977f20b
  • SHA3-256 for sqlite3.c: bb317fbbd2b3bc53233ddd5894bf4d2dc6f533445f350d4235dbcc86f65af4ec
View originalPermalink
How 3.53.0 went
3.51.3

version-3.51.3: Version 3.51.3

Fixed 2
  • Fix the WAL-reset database corruption bug
  • Other minor bug fixes

From SQLite

  • Fix the WAL-reset database corruption bug.
  • Other minor bug fixes.
  • SQLITE_SOURCE_ID: 2026-03-13 10:38:09 737ae4a34738ffa0c3ff7f9bb18df914dd1cad163f28fd6b6e114a344fe6d618
  • SHA3-256 for sqlite3.c: 32d5424f97e0a7fc5ed2f6335afbb58be4e0298bd7117a34e39d345ff13d859e
View originalPermalink
How 3.51.3 went
3.52.0

version-3.52.0: Version 3.52.0

Withdrawn All of the features that were originally scheduled for the 3.52.0 release have been moved forward into version 3.53.0.

View originalPermalink
How 3.52.0 went

More in Databases & Data

View all
Elasticsearch

The distributed search and analytics engine.

Elastic
Redis

In-memory data store used as a database, cache, and message broker.

Redis
Supabase

The open-source Firebase alternative.

Supabase
DBeaver

DBeaver release notes.

DBeaver Corp
NocoDB

An open-source Airtable alternative that turns any database into a smart spreadsheet.

NocoDB
sqlmap

Automatic SQL injection and database takeover tool

sqlmapproject

Discussion