Embedding DBI in C for PostgreSQL's SQL/MED

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 <[email protected]> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: [email protected]

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate