JSONB has landed (sqlite.org)

Article summary

SQLite has introduced a new JSONB format, which is a binary representation of JSON data that can be stored and processed more efficiently than traditional JSON text. This format is designed to be used internally by SQLite and is not intended as an interchange format. The JSONB format is expected to provide a 3x performance improvement for JSON-intensive operations and is approximately 5-10% smaller than text JSON. Developers are encouraged to try out the new format and provide feedback.

Main themes

• JSONB format
• performance optimization
• binary representation
• interoperability
• database design
• SQLite development
• custom formats
• JSON parsing
• storage efficiency
• backwards compatibility

What commenters say

• The introduction of JSONB is a good addition to SQLite, but some question the decision to create a new format instead of using an existing one like CBOR or BSON.
• The use of a custom binary format allows for better performance and smaller storage size, but may limit interoperability with other systems.
• Some argue that the JSONB format is not necessary and that optimization of the existing JSON parser could have achieved similar performance gains.
• Others point out that the SQLite developers have a track record of making good technical decisions and that the JSONB format is a useful addition to the database.
• The stability and backwards compatibility of the JSONB format are important considerations, as it will be used in production environments.
• Some commenters are concerned about the potential for users to rely on the internal implementation details of the JSONB format, which could limit the ability to change or replace it in the future.
• The decision to keep the SQLite project closed to outside contributions is seen as both a strength and a weakness, allowing for a clear vision and direction but also limiting the potential for community involvement and innovation.