SQLite 3.50 has been released, a lightweight DBMS designed as a shared library. SQLite code is released into the 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.
Key Changes:
- New SQL functions unistr() and unistr_quote() have been added to replace escaped sequences (\uXXXX) with Unicode characters and vice versa.
- In the command-line interface, the direct output of control characters has been disabled. The output of the '.dump' command now converts special characters using the unistr() function. The formatting of partial indexes in the output of the '.schema --indent' command has been improved.
- In sqlite3_rsync, the utility for copying databases between systems, the synchronization protocol has been optimized to reduce traffic when transferring similar databases. It is now possible to synchronize databases without enabling WAL (Write-Ahead Logging) mode.
- The performance of the jsonb_set() and jsonb_replace() functions when modifying large JSON objects has been optimized.
- Support for building with Cygwin, MinGW, and Termux has been improved.
Source: opennet.ru
