Difference between json and jsonb in PostgreSQL

PostgreSQL allows to store JSON data in json and jsonb datatype. Let’s understand the difference between json and jsonb.

json	jsonb
json datatype was first introduced with Postgres 9.2.	jsonb datatype was introduced in Postgres 9.4.
json data type stores an exact copy of the input text.	jsonb stores data in a decomposed binay format.
json does not support indexing	jsonb supports indexing [GIN (Generalized Inverted Index)]

When to use json data type

1. want to perform a lot of INSERT operations.

2. no complex queries are expected on JSON data.

3. you want to preserve the original JSON data indentation and format

   
   

When to use jsonb data type

1. want to store configuration data.

2. data is highly nested data (the structure is expected to change over time).

   
   

In general, jsonb is faster than json while accessing data but can be a bit slow while insertion.

Additionally, for someone working in Django. Django ORM JSONField sets the datatype to jsonb by default in PostgreSQL.

Thank you for reading this article, I appreciate it. If you have any questions, feel free to leave a comment.

https://www.chandanrajpurohit.in/post/difference-between-json-dumps-and-json-loads