PDXPUG - February meeting in two weeks

When: 6-8pm Thursday Feb 18, 2016
Where: Iovation
Who: Jason Owen
What: Incremental Schema Discovery via JSON Wrangling

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. Using data from the GitHub Archive, Jason will
show how easy it is to load JSON into Postgres, demonstrate some fairly
mechanical schema refactorings to extract structure from JSON data, and
then compare the resulting normalized tables with the original, with the
documentation, and with the data set loaded into Google BigQuery.

Jason has been using Postgres in earnest for two years now. While he's worn
the DBA hat as a full stack engineer from time to time, he is primarily a
developer. He works at Tripwire and is an alumnus of Portland State
University. Sometimes he says things online as @jasonaowen.

--
If you have a job posting or event you would like me to announce at the
meeting, please send it along. The deadline for inclusion is 5pm the day
before the meeting.
--

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp
Tower at 111 SW 5th (5th & Oak). It's right on the Green & Yellow Max
lines. Underground bike parking is available in the parking garage;
outdoors all around the block in the usual spots. No bikes in the office,
sorry!

Elevators open at 5:45 and building security closes access to the floor at
6:30.

When you arrive at the Iovation office, please sign in on the iPad at the
reception desk.

See you there!