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

An SQL operation that combines rows from two or more tables based on a related column between them.

The process of organizing database tables to reduce data redundancy and improve data integrity.

Database Connection Pooling

A technique that maintains a cache of database connections for reuse, reducing the overhead of creating new connections.

Database Backup

The process of creating copies of database data to protect against data loss from failures, corruption, or human error.

The default index type in most databases that organizes data in a balanced tree structure for efficient searching, sorting, and range queries.

CTE (Common Table Expression)

A temporary named result set defined within a SQL statement using the WITH clause, improving query readability and enabling recursion.

View All Databases Terms →