JSON vs JSONB differences in PostgreSQL - Quick Revision & Key Differences

Recall & Review

beginner

What is the main difference between JSON and JSONB data types in PostgreSQL?

JSON stores data as plain text, while JSONB stores data in a binary format that is faster to process and query.

beginner

Which data type, JSON or JSONB, supports indexing for faster queries in PostgreSQL?

JSONB supports indexing, which makes queries faster. JSON does not support indexing.

intermediate

Does JSONB preserve the order of object keys in PostgreSQL?

No, JSONB does not preserve the order of object keys. JSON preserves the exact text including order.

intermediate

Which data type is generally faster to insert: JSON or JSONB?

JSON is faster to insert because it stores data as plain text without extra processing. JSONB requires parsing and converting to binary format.

advanced

Can JSONB store duplicate keys in objects like JSON can?

No, JSONB does not allow duplicate keys in objects. JSON can store duplicate keys as it stores raw text.

Which PostgreSQL data type stores JSON data in a binary format?

A TEXT

B JSONB

C JSON

D XML

JSONB stores JSON data in a binary format for faster processing.

Which data type preserves the exact text and order of keys in JSON objects?

A JSON

B JSONB

C XML

D ARRAY

JSON preserves the exact text including whitespace and key order.

Which data type allows indexing to speed up queries?

A JSON

B VARCHAR

C TEXT

D JSONB

JSONB supports indexing, JSON does not.

Which data type is faster to insert when you don't need to query the data often?

A INTEGER

B JSONB

C JSON

D BOOLEAN

JSON is faster to insert because it stores raw text without extra processing.

Can JSONB store duplicate keys in the same JSON object?

A No

B Yes

C Only if keys are numeric

D Only if keys are strings

JSONB does not allow duplicate keys; it enforces unique keys.

Explain the key differences between JSON and JSONB in PostgreSQL.

Think about storage format, performance, and indexing.

When would you choose JSON over JSONB in PostgreSQL and why?

Consider use cases focused on data storage vs querying.