Skip to main content

SQLite Introduces JSONB for Improved JSON Function Performance

SQLite, the leading open-source embedded database solution, has recently introduced JSONB, a rewrite of its JSON functions that promises to be “several times faster” than the previous implementation. The JSONB rewrite brings significant performance improvements by changing the internal binary representation of JSON into a contiguous byte array that can be read or written as an SQL BLOB. This optimization helps to reduce the overhead of parsing JSON text and representing JSON for storage. Despite the changes, JSONB maintains all the legacy functionality of the previous JSON functions. In fact, all JSON functions can also accept JSONB binary contents, ensuring compatibility with existing code and workflows.

Source: Phoronix.