Bend Postgres to Your Pythonic Will

11:00 AM - 11:45 AM on August 16, 2014, Room 702

Wes Chow

Audience level:

intermediate

Description

Python + Multicorn allows us to define simple data backends for Postgres via its Foreign Data Wrapper interface. This opens up a slew of interesting applications for applying SQL to arbitrary data backends.

Abstract

The Postgres Foreign Data Wrapper API allows programmers a simple mechanism to define arbitrary backends. In this talk, Wes will go over Multicorn, the Python API for plugging into FDW, and provide a few simple but powerful use cases. You'll see how SQL can make log analysis a breeze, how to build a small but effective columnar data store, and even look at querying backends that transiently exist over the network.