This is the presentation for the talk on the conference PgConf 2017.

The slides can be accessed online at furstenheim.github.io/jsonb-tutorial

Summing jsons: jsonb_deep_sum

Validate json schema: is_jsonb_valid

To serve the slides on localhost go to the presentation folder

cd presentation yarn install yarn start

Download postgres source code (version 11) from official website https://www.postgresql.org/ftp/source/v11.3/ And follow installation guide For ease of postgres development use http://big-elephants.com/2015-10/writing-postgres-extensions-part-iii/ as well

/usr/local/pgsql/bin/initdb -D ~/data-dir-presentation
/usr/local/pgsql/bin/pg_ctl -D ~/data-dir-presentation -l logfile start

Once postgres is all set up. You can install and execute the tests from within an example:

cd example_1_barebone
make install ## install
make installcheck ## run test