PostgreSQL (JSONB)

JSONB is a PostgreSQL data type for storing JSON documents in a binary format, enabling efficient storage, indexing, and querying of semi-structured data within a relational database. Unlike the earlier JSON type, which stores data as text requiring reparsing on each operation, JSONB decomposes…

Key facts

First appeared: 2014
Category: technology
Problem solved: Storing and querying semi-structured JSON data efficiently in a relational database without reparsing on every operation, while enabling indexing, type-specific operations, and validation that text-based JSON lacked.
Platforms: PostgreSQL (9.4+)

Related technologies

GIN indexes
Hibernate
SQL/JSON path queries
PostgreSQL

Notable users

Companies using PostgreSQL (e.g., Apple, Netflix, Instagram)
Web applications with semi-structured data