Re: Embedding DBI in C for PostgreSQL's SQL/MED

On Fri, 30 Jan 2009 10:26:28 -0800, David Fetter <[email protected]>
wrote:

> 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.

Maybe a bit (just a bit) off-topic, I think this *is* interesting, and
I would like to see a presentation on YAPC::Europe :)
The past two year we had DBD micro-hackathons. This might 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?

-- 
H.Merijn Brand  http://tux.nl      Perl Monger  http://amsterdam.pm.org/
using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00,
11.11, 11.23, and 11.31, SuSE 10.1, 10.3, and 11.0, AIX 5.2, and Cygwin.
http://mirrors.develooper.com/hpux/           http://www.test-smoke.org/
http://qa.perl.org      http://www.goldmark.org/jeff/stupid-disclaimers/