Databases Intermediate

What is JSONB?

PostgreSQL's binary JSON data type that stores JSON documents with indexing, querying, and manipulation capabilities.

JSONB stores JSON in a decomposed binary format, enabling indexing and efficient querying. Operators include -> (get element), ->> (get as text), @> (contains), and ? (key exists). GIN indexes make JSONB queries fast.

JSONB bridges relational and document databases — store structured data in tables and flexible/dynamic data in JSONB columns. Use cases include user preferences, API responses, metadata, and schema-less data alongside structured tables.

Related Terms

A database object that automatically executes a specified function when certain events (INSERT, UPDATE, DELETE) occur on a table.

A PostgreSQL maintenance operation that reclaims storage from dead tuples and updates statistics for the query planner.

Window Function

An SQL function that performs calculations across a set of rows related to the current row without collapsing the result set.

Row-Level Security (RLS)

A database feature that restricts which rows a user can access in a table based on security policies.

A version-controlled change to a database schema that can be applied and reversed systematically.

ETL (Extract, Transform, Load)

A data pipeline process that extracts data from sources, transforms it into a suitable format, and loads it into a destination system.

View All Databases Terms →