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!

September Meeting Recap + Upcoming Events

Last week’s meeting will go down in PDXPUG history alongside such classics as Normalization Puppet Theater and the ever-popular Relational Algebra Cocktail Parties.

I’d just returned from PgOpen[1], where I’d attended Andrew Dunstan’s talk about JSON in 9.3, which included an overview of the fun and very useful functions now available in Pg 9.3. Andrew Kreps’ talk for PDXPUG featured an app he’d whipped up using the Instagram API, specifically to show off those functions. The app is either the ultimate Photobomb-assist, or ultimate Presentation Karaoke feed. We’re still deciding how to use it, but the real takeaway for me was that there are probably a lot of people very unaware of the type of information they’re making publicly available via Instagram. Also, approximately half of the photos taken in Portland are of food, and probably 70% of those are Voodoo Doughnuts-related [2].

Upcoming events:
PgConf.EU 29 Oct – 1 Nov 2013 in Dublin, Ireland
SQLSaturday 16 Nov 2013 in Portland, OR
CodeCamp 11 Jan 2014 in Portland, OR
SCALE 21-23 Feb 2014 in LA

1 – one of the lucky few to escape ORD on time
2 – these numbers are just SWAGs at this time; we’re waiting on the final statistical analysis.