JSON Processing in the Database using PostgreSQL

Talk Synopsis

Ryan Harvey is back to give us a dive into the JSON data format and PostgreSQL's features in the newly released version 9.4 to manipulate JSON formatted data. After an intro to the features of each, Ryan will show how to build a script that creates an analysis table directly from API calls.

Bio

Ryan Harvey is a local coder, datahead, project manager, wonk and dad. For work, he manages several government web apps at the Office of Management and Budget, in addition to doing data science, software architecture and application and database engineering for Kitchology, Inc. on the side. He's also a former PhD candidate (all-but-dissertation) in the Applied Mathematics, Applied Statistics and Scientific Computing program at the University of Maryland's Norbert Wiener Center for Harmonic Analysis and Applications. Ryan lives in Lanham, MD, with his wife and two children and several pets.

Schedule

6:30pm: Empanadas and chit chat

7:00pm: Intro

7:10pm: Ryan talks awesome

9:00pm: Data drinks at Tonic