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.
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.
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.
Montreal 2015 sponsored by
