2016-04-24 12:30-2016-04-24 13:30

Experience level


Session Track


The JSON-driven Schema

Over the last few releases, Postgres has added and expanded support
for storing and querying JSON documents. While the simplicity and
flexibility of storing free-form data can be appealing, frequently
what's stored is actually fairly structured. In this talk, we'll
explore how to incrementally discover the schema of the data you have.

Using data from the GitHub Archive, Jason will show how easy it is to
load JSON data into Postgres, demonstrate some of the tools Postgres
has to work with JSON data, and then use those tools to perform some
fairly mechanical schema refactorings to extract structure from JSON
data and create normalized tables.

Slides are available, as is the source behind them.