Andrea Gnemmi covers a pair of data types to manage one thing:
We have all encountered the need to store non-structured or semi-structured data in an RDBMS; XML or JSON data in particular. This can be complicated, especially in the past with limited technical options, and even more complicated if we want to query this data efficiently.
Read on to learn more about the differences between JSON and JSONB, as well as mechanisms you can use to query subsets of the data.