Re: Using a C++ library in PostgreSQL

Lists: pgsql-hackers
From: Xin Wang <andywx(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Using a C++ library in PostgreSQL
Date: 2009-07-19 14:13:35
Message-ID: 231be6140907190713n56c20117m711a2b6bae490b45@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi all,
My research project is based on PostgreSQL. I want to get the
Post-Schema-Validation-Infoset (PSVI)
of an XML document being stored. However, the current libxml2 library does
not support PSVI at all. So
I have to use the Xerces C++ library in PostgreSQL. But I wonder if it is
possible to call a C++ API in
a C code base.
Could anyone here give me some guidelines to do it? Can the recently
discussed "Mostly Harmless C++"
patch be helpful to what I want to do?

Thank you in advance!
Xin Wang


From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Using a C++ library in PostgreSQL
Date: 2009-07-19 16:57:24
Message-ID: 20090719165724.GH5407@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Sun, Jul 19, 2009 at 10:13:35PM +0800, Xin Wang wrote:
> My research project is based on PostgreSQL. I want to get the
> Post-Schema-Validation-Infoset (PSVI) of an XML document being
> stored. However, the current libxml2 library does not support PSVI at
> all. So I have to use the Xerces C++ library in PostgreSQL.

I've never had to do anything like this before, so these will just be
general recommendations that I believe I've seen made before on this
list.

> But I wonder if it is possible to call a C++ API in a C code base.

In most common cases, yes this is perfectly possible. Just make sure
that you catch all exceptions and have all functions that have to be
callable from normal C code declared as 'extern "C"'.

I have a feeling that PG does things that interact badly with the way
C++ handles exceptions. As far as I can tell[1], this only applies when
you're calling back into Postgres' C code from C++. There are various
other annoyances (i.e. the sort of thing you always get when trying
to get code talking together that wasn't expecting to be) to do with
Postgres, like things in the headers using names that are reserved in
C++ and not in C.

> Could anyone here give me some guidelines to do it? Can the recently
> discussed "Mostly Harmless C++" patch be helpful to what I want to do?

Isolate all your C++ code away in one part of your code and have some C
code in the middle to do the translations between the two worlds. As
far as PG should be concerned it will just be calling C code.

If you can't get that to work and performance doesn't matter too much;
put your C++ code into a separate program and have the C code run said
program when needed.

--
Sam http://samason.me.uk/

[1] http://wiki.postgresql.org/wiki/C++_Compatibility