Thread: Performance test of Oracle and PostgreSQL using same binary

Performance test of Oracle and PostgreSQL using same binary

From
Divakar Singh
Date:
Hello all,
I am trying to do comparative study of PostgreSQL and Oracle.
Has anybody tried to use same binary for connecting to oracle as well as PostgreSQL at the same time?
I mean the program should be able to create 1 connection to oracle and 1 connection to postgreSQL at the same time.
The problem I can foresee may be symbol clash etc (it is a C program using libpq and OCI).

Has anyone been successful in loading and using both libraries in the program at the same time without symbol clash?
 
Best Regards,
Divakar


Re: Performance test of Oracle and PostgreSQL using same binary

From
Jeff Janes
Date:
On Tue, Jan 11, 2011 at 10:54 PM, Divakar Singh <dpsmails@yahoo.com> wrote:
> Hello all,
> I am trying to do comparative study of PostgreSQL and Oracle.
> Has anybody tried to use same binary for connecting to oracle as well as
> PostgreSQL at the same time?
> I mean the program should be able to create 1 connection to oracle and 1
> connection to postgreSQL at the same time.
> The problem I can foresee may be symbol clash etc (it is a C program using
> libpq and OCI).
>
> Has anyone been successful in loading and using both libraries in the
> program at the same time without symbol clash?

I've done this from Perl using DBI, DBD::Oracle, and DBD::Pg.  As perl
is written in C, that should be a good sign for you.

Cheers,

Jeff