February 18-20, 2015
Montreal, Canada

Schemaless Meets Relational - JSONB in PostgreSQL 9.4

Traditional relational databases have a rigid schema, and most NoSQL databases are completely schemaless. But reality often demands something in between, and this is why PostgreSQL 9.4 ships with new and enhanced JSON support that allows the best of both worlds.

In this talk we'll look at the new "jsonb" datatype, it's flexible and performant indexes, and how to use those to get a "dynamic schema" architecture.

View all 141 sessions

Magnus Hagander

Redpill Linpro

Magnus Hagander is a member of the PostgreSQL Core Team and a developer and code committer in the PostgreSQL Global Development Group.

He mostly works on different parts of the PostgreSQL backend, recently with a focus on security features such as authentication and encryption, and backup/availability.

To pay the bills, he is an open source software consultant, primarily on PostgreSQL and Varnish at Redpill Linpro in Stockholm, Sweden, where he works with consulting, support and training.

Read More

Montreal 2015 sponsored by