/postgres-incremental-schema

Presentation on exploring JSON data using PostgreSQL

Primary LanguageCSSOtherNOASSERTION

The JSON-Driven Schema

These are the slides for the talk "The JSON-Driven Schema".

It uses reveal.js to render (mostly) markdown files into a slideshow. The slides contain code, and that code is intended to be executed as part of the talk.

To run this slideshow locally, you need to serve the contents of this repo from some kind of httpd. The simplest way I've found to do that is to run this command from the root of this repo:

$ python -m SimpleHTTPServer

This will start a server at http://localhost:8000.

Table of Contents

The slides are split into separate markdown files, which are intended to be viewed in this order:

  1. Introduction
  2. JSON and PostgreSQL
  3. GitHub API overview
  4. Loading JSON into PostgreSQL
  5. Looking at JSON objects
  6. Flattening JSON objects
  7. Converting scalar data types
  8. Normalizing
  9. Polymorphic payload
  10. Extracting a link table (optional)
  11. Measuring normalization

License

cc-by-sa The presentation content is available under the Creative Commons Attribution-ShareAlike 4.0 International License.

reveal.js is Copyright (C) 2016 Hakim El Hattab, http://hakim.se.