{"id":168285,"date":"2026-04-10T11:12:04","date_gmt":"2026-04-10T09:12:04","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-53"},"modified":"2026-04-10T11:12:04","modified_gmt":"2026-04-10T09:12:04","slug":"vypusk-subd-sqlite-3-53","status":"publish","type":"post","link":"https:\/\/prohoster.info\/en\/blog\/news\/vypusk-subd-sqlite-3-53","title":{"rendered":"Release of SQLite DB 3.53","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
SQLite 3.53 has been released, a lightweight DBMS available as a dynamic library. Version 3.52 has been canceled. SQLite code is distributed as public domain, meaning it can be used without restrictions and free of charge for any purpose. The financial support for SQLite developers is provided by a specially created consortium. <\/p>\n
Key Changes: <\/p>\n
\n
A bug that led to database corruption has been fixed. This problem has existed since version 3.7.0 (2010), affecting databases in WAL (Write-Ahead Logging) mode and manifesting due to a race condition when two or more connections to the database, which attempted to write or commit transactions to the same database instance, were opened simultaneously. It is claimed that the circumstances leading to the failure are extremely rare and could only be reproduced in a specially crafted test scenario.\n
In the «ALTER TABLE» command, it is allowed to remove «NOT NULL» and «CHECK» constraints.\n
The «REINDEX EXPRESSIONS» command has been added to rebuild indexes based on expressions where a function or operations on columns is used as an index element. This command can be used to recover stale indexes.\n
Inside temporary triggers created by the «CREATE TEMP TRIGGER» command and applied to tables in other databases, it is allowed to modify tables or query data from tables.\n
In the «VACUUM INTO» command, when specifying a target file via a URL, the «reserve=N» parameter is implemented to define the number of database backups created.\n
New SQL functions json_array_insert() and jsonb_array_insert() have been implemented for inserting elements into JSON arrays.\n
A QRF (Query Result Formatter) library has been added and utilized in the command-line utility for formatting the results of SQL query executions into a readable format.\n
Changes in the command-line utility:\n
\n
The «.mode» command has been significantly expanded.\n
Output formatting has been improved, for example, border rendering is now enabled by default, and numerical values are right-aligned in tabulated output.\n
It is now ensured that the «;» symbols are ignored after commands.\n
The content of files specified in the command line with extensions *.sql and *.txt is now read and interpreted as sets of SQL expressions and dot commands.\n
The «.timer» command has added support for the «once» value to apply the timer only to the next SQL statement.\n
An option «—timeout S» has been added to the «.progress» command for forcibly terminating the SQL statement after the timeout expires.\n
The behavior of templates in the «.indexes» command has been changed, and they now apply to index names instead of indexed table names. <\/ul>\n
Optimizations have been made to the query scheduler, speeding up table merging and operations like EXCEPT, INTERSECT, and UNION.\n
The performance of functions for converting floating-point numbers to text representation has been improved.\n
The implementation compiled to WebAssembly intermediate code has added VFS «opfs-wl», identical to VFS «opfs», but using the Web Locks API to handle locks.\n
An option «-p|—port» has been added to the sqlite3_rsync utility.\n
Support for the Windows RT platform has been discontinued. <\/ul>\n