JSONJSONB

JSONJSONB is a hypothetical data type proposed to unify the advantages of textual JSON with the performance characteristics of binary JSON. In a system that supports JSONJSONB, a value is stored in two representations: a human-readable JSON text and a compact binary form. The binary representation enables fast parsing, efficient indexing, and compact storage, while the text form remains suitable for debugging, logs, and exchange with external systems that prefer readable JSON.

Queries and manipulations are designed to operate on the binary form, using the same JSON operators and path expressions familiar from JSONB. The textual form is kept in sync to preserve readability and interoperability, and applications can choose to access either representation depending on needs. An implementation may provide index support on the binary representation to accelerate containment, existence, and path queries, and may offer functions to extract or reconstruct the textual JSON for display.

Storage and update semantics are a key design consideration: every write must update both representations, raising concerns about write amplification and potential consistency issues. Practical deployments would trade off extra storage for dual access paths and could rely on append-only or incremental synchronization to mitigate costs.

JSONJSONB is not an established standard, but it is discussed as a conceptual bridge between JSON-like text storage and binary JSON performance. It offers a theoretical path for applications requiring both human-readable data and high-speed query processing. See also JSON, JSONB, PostgreSQL, and binary JSON.