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.

PDXPUG: September meeting in two weeks – JSON

When: 7-9pm Thu Sep 19, 2013
Where: Iovation
Who: Andrew Kreps
What: JSON

This month we return to our regular meeting location at Iovation. Andrew Kreps will be giving a JSON demo.

Topics:
– A brief definition of JSON for those who may not have a lot of experience with it
– Why the storage of JSON as JSON is important
– Working with the operators, selecting data, etc
– A practical example, probably using the Instagram API.

Andrew’s a Portland-based software engineer who digests APIs for breakfast. After stumbling through the worlds of Oracle and Mysql for many years, he’s found PostgreSQL to do things they way they should have always been done.

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!

Building security will close access to the floor at 7:30.