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 want to perform a lot o

JSON is important for many backend devs. But sometimes playing with it can be confusing. Being a backend dev or full stack dev you might have written APIs for your Web or Mobile application and I’m sure you might have come across json.dumps() and json.loads(). Let’s understand the difference between json.dumps() and json.loads() with an example. json.dumps() import json user_details_dict = { "first_name": "Chandan", "last_name": "Rajpurohit" } user_details_string = """{ "fi