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

Database Constraint

Rules enforced by the database to maintain data integrity, including NOT NULL, UNIQUE, CHECK, PRIMARY KEY, and FOREIGN KEY.

An advanced open-source relational database known for its reliability, feature richness, and standards compliance.

Query Optimization

The process of improving database query performance through indexing, query rewriting, and schema design techniques.

A data structure that improves the speed of data retrieval operations on database tables at the cost of additional storage.

A technique of dividing large database tables into smaller, more manageable segments while maintaining a single logical table.

A query that transforms rows into columns, creating a pivot table view of aggregated data.

View All Databases Terms →