Folks, In the upcoming version of PostgreSQL, there is a thing called a "foreign data wrapper," this being part of SQL/MED, which is an ISO standard for how relational database management systems can talk to external data sources. As DBI is the winner and champion of "external data sources," I thought this would make an excellent fit.
The hooks I'd like to use were first committed here <http://git.postgresql.org/?p=postgresql.git;a=commit;h=fef8719c30fd2e5dfdcfed283e129c2603c26ab0> and haven't changed significantly since. The task ahead is to create the appropriate stuff in, say, src/backend/foreign/perl_dbi/, then hook all that stuff into the foreign data wrapper interface. I'm picturing some way to embed a very restricted perl interpreter whose only exposed APIs would be through the interfaces specified in SQL/MED, so this is totally different from PostgreSQL's built-in PL/Perl interpreter. Where can I find some example C code that properly embeds just enough Perl to use DBI? As my C skills are, to put it generously, minimal, is anybody here interested in helping do this? Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
