JSON in PostgreSQL - Learning with a case study
Up until fairly recently, you had to make that difficult decision up-front when modeling your JSON data: document or relational database? Yes, you could use two separate databases, using each tool for what they’re best at. Alternatively, if you have an existing PostgreSQL workload and want to extend this to support JSON use cases, this session is for you! Postgres has had JSON support for a while but with recent versions, Postgres now handles JSON really well. In this session, I cover the benefits of using JSON, anti-patterns to avoid, and an example of how to use JSON in Postgres.