Jsonb
JSONB is PostgreSQL's binary JSON data type, storing JSON values in decomposed form for efficient processing and indexing.
Just Use Postgres!
jsonb is PostgreSQL's binary JSON data type that stores JSON values in a decomposed form for efficient processing and indexing.
- How it is used
- Deploys JSON storage for database-level field queries, nested filtering, manipulation, and indexing in PostgreSQL applications.
- How deep it goes
- Explains binary storage, trade-offs, operators, array traversal, updates, and GIN indexing, but defers detailed index implementations.
- Examples
- Uses pizza orders, nested toppings arrays, sausage-key searches, and gluten-free containment reports.
- What you can do after
- Apply it via PostgreSQL SQL to store, inspect, filter, update, remove, and index JSON structures.
PostgreSQL Mistakes and How to Avoid Them
JSONB is PostgreSQL's binary JSON data type for storing structured data in a decomposed representation that supports indexing and efficient processing.
- How it is used
- Supports indexable storage for genuinely variable or sparse structured attributes, especially during data ingestion.
- How deep it goes
- Explains the relational JSON anti-pattern through document tables and extraction-heavy join queries, without detailing JSONB storage internals.
- Examples
- Uses JSONB customer accounts and sales documents joined through extracted account IDs and filtered through casts and nested fields.
- What you can do after
- Evaluate/understand when flexible JSONB storage fits sparse ingestion and when relational modeling avoids complex retrieval.
Read how PostgreSQL Mistakes and How to Avoid Them explains jsonb →
Related concepts
- @> operatorused by · The PostgreSQL JSON @> operator tests whether one JSON value contains another JSON value.
- JSONalternative to · JSON is a standardized, language-independent text format for representing structured data using objects, arrays, strings, numbers, Boolean values, and null.
- xmlalternative to · XML is a text-based markup language for encoding structured documents and data using elements, attributes, and nested relationships.
- GIN indexuses · A GIN index is a PostgreSQL generalized inverted index that maps components of composite values to rows containing them.
- PostgreSQLused by · PostgreSQL is an open-source object-relational database management system that implements SQL and supports transactional data storage and extensibility.
- GiST indexuses · A GiST index is a PostgreSQL extensible index structure that supports generalized searches over diverse data types and predicates.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.