[Solved] Why does PostgreSQL offer both JSON and JSONB data types, and when is JSONB preferred? — Ans: JSONB stores data in binary format for faster querying and indexing; preferred... | PostgreSQL

PostgreSQL - JSON and JSONB

Why does PostgreSQL offer both JSON and JSONB data types, and when is JSONB preferred?

AJSON stores data in binary; JSONB stores plain text for readability.

BJSONB stores data in binary format for faster querying and indexing; preferred for frequent reads.

CJSONB is deprecated; JSON is the modern standard.

DJSONB disables indexing; JSON enables indexing.

Step-by-Step Solution

Solution:

Step 1: Understand JSON vs JSONB
JSON stores exact text; JSONB stores binary parsed data for efficiency.
Step 2: Identify use case for JSONB
JSONB supports indexing and faster queries, preferred for frequent access.
Final Answer:
JSONB stores data in binary format for faster querying and indexing; preferred for frequent reads. -> Option B
Quick Check:
JSONB = binary, faster, indexable [OK]

Quick Trick: Use JSONB for faster queries and indexing [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does PostgreSQL offer both JSON and JSONB data types, and when is JSONB preferred?