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.

Learn More About This Topic

SQL for Absolute Beginners

Related reading

Redis Fundamentals

Related reading

MongoDB Fundamentals: Building Scalable NoSQL Applications with Document Databases

Related reading

Related Terms

The process of copying and maintaining database data across multiple servers for redundancy, failover, and read scaling.

ORM (Object-Relational Mapping)

A technique that lets you interact with a database using object-oriented code instead of writing raw SQL queries.

Materialized View

A database object that stores the precomputed result of a query, offering faster reads at the cost of periodic refresh.

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.

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

EXPLAIN ANALYZE

A PostgreSQL command that shows the execution plan of a query along with actual runtime statistics for performance tuning.

View All Databases Terms →