JSONB in SQL

Difficulty: Intermediate

Question

What is JSONB and why use it in Postgres?

Answer

JSONB stores JSON in a binary format that can be indexed. It's great for storing semi-structured data while keeping the power of an ACID-compliant relational DB.

Concepts covered

PostgreSQL, Flexible Schema