PostgreSQL Foreign Data Wrappers

https://www.kentik.com/postgresql-foreign-data-wrappers/?utm_source=postgresweekly&utm_medium=email

by onderkalaci • 11 years ago

48 6 11 years ago

danr4• 11 years ago

Unrelated but important: I wish sites realized that blocking Adobe Typekit (and it's tracking) totally breaks their site. In this particular one I don't see any text. Why the hell is there no fallback for crappy fonts or whatever?

qooleot• 11 years ago

Hey I thought I'd reply here on the topic of the blog's usability to not hijack the whole thread....but I still wanted to help the author out with a quick fix:

This text's link doesn't work:

(see http://www.whitedb.org).

simonpantzare• 11 years ago

http://multicorn.org/ is a PostgreSQL extension meant to make FDW development easier. It lets you write them in Python.

mason55• 11 years ago

Just be careful with FDWs. They run outside of many of the normal checks within the PG server and so a badly written FDW can actually cause the whole server to crash. We've experienced a number of issues with the MongoDB FDW from Citus where we do benign things like comparing an integer to a string and the entire Postgres server goes down. Another issues we've run into is that the query planning cache seems to get confused by FDWs, and if we try to query an FDW from within a stored procedure it just never returns or it crashes the DB. Instead we have to construct the query with dynamic SQL inside the stored proc which is both a pain in the ass and way increases the chances for bugs.

We're still on 9.1 so maybe some of this has been fixed by now but people seem to push FDWs as this panacea where you get all the guarantees & safety of running within Postgres and that's just not the case.

avifreedman• 11 years ago

Good advice...

In our case (@kentik), we're mainly focused on having a Dremel-like system accessible via FDW. Primarily we're using Postgres as the "API" to it, so if it dies as a result of an FDW bug it'd be a primary operational problem for us.

brightball• 11 years ago

Heroku's implemented a streamlined version that they support called Data Links. https://blog.codeship.com/heroku-data-links-postgres-redis/

PostgreSQL Foreign Data Wrappers

Related Stories