Case Study: Use of JSONB in PostgreSQL

  • Ines Panker
  • April 2017

Abstract

Recently PostgreSQL introduced the JSON and JSONB data types. At first, we ignored this news, we could not see how the JSON types could be of use to us. But then we used it once and then twice and then we almost went overboard with JSONs. This prompted us to stop, take a step back and analyze when a JSON type is useful and when it causes unnecessary hassle.

What will the audience get from this talk: How and when to use the JSON types. What the advantages and disadvantages are. And how to avoid falling into a JSON mania.