Postgres & JSON: NoSQL in SQL?

  • 30 minute talk

A look at the Postgres 9.3 JSON data type and how it can give you the flexibility of a NoSQL document store right there inside your relational database.

  1. The JSON data type and its functions
  2. Creating and querying on computed indexes
  3. Joining with regular tables
  4. Performance comparison with normalized SQL
  5. Performance comparison with MongoDB


Nick has been working in Open Source for 20 years now, self-employed for almost half of that and has worked in programming, research, standardization, teaching and systems administration.

Currently, he's mostly working at introducing Open Source and Open Standards into the Enterprise environment, for fun and profit.

The OSDC 2014 team is dedicated to providing a friendly, safe and welcoming conference environment for everyone. We have a code of conduct to clearly outline our expectations. Our goal is to create a safe and harassment-free conference experience for all involved, regardless of gender, sexual orientation, disability, ethnicity, religion, preferred operating system, programming language or text editor.