Sessions at OSCON 2012 with link on Thursday 19th July

View as grid

• Unlocking Proprietary Data with PostgreSQL Foreign Data Wrappers

  by Pat Patterson

  PostgreSQL 9.1 introduced ‘Foreign Data Wrappers’ (FDW) – a partial implementation of the SQL/MED standard for handling access to remote data sources. FDW allows PostgreSQL to expose remote data as foreign tables which then behave similarly to native PostgreSQL tables, in particular, allowing remote data to be queried with SQL statements.

  This session provides an overview of Foreign Data Wrappers, looks at the native interface for writing FDWs in C, and contrasts this with Multicorn, an open source framework that allows FDWs to be developed in Python. We will show a real-world Python FDW that retrieves business data from salesforce.com, with a sample client application that demonstrates how foreign data can be combined with data held in native PostgreSQL tables using a simple SQL JOIN.

  • PostgreSQL
  • Python

  At 5:00pm to 5:40pm, Thursday 19th July

  In Portland 252, Oregon Convention Center

  Coverage link slide deck