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

A category of databases that store data in non-tabular formats, optimized for specific data models and access patterns.

A set of four properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions.

Database Sharding

A horizontal scaling strategy that distributes data across multiple database servers based on a partition key.

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

A situation where two or more transactions permanently block each other by each holding locks that the other needs.

A pattern where records are marked as deleted with a flag or timestamp rather than being physically removed from the database.

View All Databases Terms →