Skip to main content

SQLite 3.45 Updates JSON Functions for JSONB Usage

SQLite 3.45 has been released, and it brings several improvements to the popular SQL database library. One major enhancement is the optimization of the SQLITE_DIRECT_OVERFLOW_READ feature, which is now enabled by default. This optimization can significantly improve the read performance for applications that heavily rely on SQLite and read large BLOBs or strings. Another, perhaps more exciting update in SQLite 3.45 is the rewriting of all JSON functions to utilize the JSONB format. The JSONB version of SQLite’s JSON functions offers several times better performance compared to the existing JSON support within SQLite.

JSONB is a new internal-use binary representation of JSON that is stored as an SQL BLOB. This format allows SQLite’s internal binary representation of JSON to be directly stored in the database, eliminating the overhead of parsing and rendering JSON when reading and updating JSON values. Furthermore, the JSONB format takes up slightly less disk space than text JSON.

Source: Phoronix.