Charity  Ferry

Charity Ferry


SQL and NoSQL in PostgreSQL

Have you ever started a project and asked - “should I use a SQL or NoSQL database?”
It’s a big decision. There are multiple horror stories of developers [choosing a NoSQL database and later regretting it]
But now you can get the best of both worlds with JSON in PostgreSQL.

Table of Contents

  • [SQL vs NoSQL]
  • [JSON Basics.]
  • [Evolution of JSON in PostgreSQL.]
  • [Creating a JSON table]
  • [How to query JSON data]
  • [JSONPath: advanced JSON syntax]
  • [Indexing for faster retrieval]
  • [JSON anti-patterns.]
  • [JSON vs NoSQL Databases.]
  • [Closing thoughts.]


SQL and NoSQL  in PostgreSQL