In a recent development, SQLite has released version 3.50 of its lightweight database management system. SQLite, designed as a connected library, is distributed as a public treasure in the form of open-source software, allowing users to utilize it without restrictions and free of charge for any purpose. The financial support for SQLite developers is managed by a consortium created specifically for this purpose.
The latest release of SQLite includes several key changes, such as the addition of new SQL functions. These include ‘unistr()’ and ‘unistr_quote()’, which are used for replacing shielded sequences like uxxx in Unicode symbols and vice versa. The command line interface has been updated to disable the direct output of control characters, while the ‘DUMP’ command now includes transformations using the ‘Unistr()’ function and improved formatting of partial indices with the ‘.Schema –indent’ command.
Furthermore, the utility ‘sqlite3_rsync’ for copying databases has been optimized with a synchronized protocol to reduce traffic when handling similar databases. Additionally, the synchronization of databases can now be done without enabling the ‘Wal’ (Write-ahead logging) mode. The performance of the JSONB_SET() and JSONB_REPLACE() functions has been enhanced for altering large JSON objects, and support for assembly using Cygwin, MinGW, and Termux has been improved.