Be flexible and consistent: JSON comes to CockroachDB

CockroachDB's upcoming 2.0 release introduces support for JSONB, allowing for the integration of structured and semi-structured data within the same database, enhancing flexibility without compromising on ACID guarantees or scalability. Implemented based on the Postgres design, JSONB offers optimized binary storage for quicker operations compared to traditional JSON, making it particularly effective for frequently read but infrequently written data. The new feature includes inverted indices, enabling efficient querying of unpredictable data structures without the need for predefined indexing. This release, developed with community involvement, addresses the challenges of managing heterogeneous data and aims to simplify data modeling by leveraging JSONB's capabilities for rapid prototyping and flexible data management. CockroachDB invites users to explore this feature in the 2.0 Beta and anticipates further exploration of JSONB use cases for enhanced data management.