18 au 20 février 2015
Montréal, 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.

Voir les 141 présentations

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

Montréal 2015 sponsored by