SQLite 3.51 has been released, a lightweight DBMS designed as a plug-in library. The SQLite code is distributed as a public domain, meaning it can be used without restrictions and free of charge for any purpose. Financial support for SQLite developers is provided by a specially created consortium.
Main changes in this release include the addition of new JSON functions like jsonb_each() and jsonb_tree(), which differ from previously available functions by returning a JSONB value for array or object data. Extension code carray and percentile have been moved to the base file “sqlite3.c” with SQLite embed code. The interface has been improved for using SQLite in Tcl scripts, with the addition of new features.
Changes in the Command Line Interface include increased precision, support for double-width characters, read-only imposter tables, and more. Performance optimizations have been made to reduce CPU load, improve detection of JOIN operations, and speed up window functions.
Additionally, new pragmas like PRAGMA wal_checkpoint=NOOP and API functions like sqlite3_set_errmsg() and sqlite3_db_status64() have been added to the SQLite 3.51 release. For more details on the changes, you can visit the release log.