Link parkin’: PostgreSQL Foreign Data Wrappers.
When this link first started kicking around, I thought it was just a gimmicky way to pull data into Postgres (PGSQL), destined to be slow and finicky. Boy was I wrong! Turns out Foreign Data Wrappers (FDW) are an SQL standard that the latest version of Postgres, 9.1, heavily supports. Turns out there are all sorts of interesting uses for FDWs. Turns out that Multicorn makes writing the wrappers in Python relatively straightforward.
At work, I’ve got some hairy data ingest challenges for Postgres. Maybe FDWs can help solve them.
Hat tip, Ben Lorica’s Big Data Twitter stream