Re: Are you Looking for a nice Postgresql Admin program similar to IB Expert ?

I use PostgresDAC in threads for PGLA, I also use Zeos in a heavily
threaded IM server to access Postgresql with no problems, the key with
PostgresDAC is to use one connection per thread or if you are going to
share wrap everything up in a critical section.

Isn't there a bunch of tdataset products for Oracle?

Later,

Tony

Tony,

thank you for your answer.

I've took a look at Zeos but for various reasons is'nt ok for my
application.
Yes, there are a lot of tdataset products for Oracle, from well-known DOA to
NCOCI8, freeware,
but my point in using dbexpress was only one codebase, two databases... even
if my application is quite complex, my SQL is not,
and following some rules I can achieve the goal of supporting both
PostgreSQL and Oracle with a single codebase without noticeable problems..
and this cannot be done if I use tdatasets descendants like postgresDAC/DOA.

Actually I'm using a double-bridge with the freeware dbexpress driver for
ODBC and PostgreSQL ODBC driver... but now I'm in testing stage and I cannot
think this can be a real situation for a production system.... even if I
have to say that from my far from scientific tests seems that there aren't
noticeable perfomance differences between this and the pgexpress driver,
even with tables of 100.000+ records!

I'll have to think about carefully.. make a lot of tests... life for
programmers is alway difficult!!!!

Bye



.

Relevant Pages

  • Re: Need your help [arguments for open source databases]
    ... >> I would like to have your opinions about open source databases versus ... >> in the universe of relational databases. ... The main difference between PostgreSQL and Oracle is manageability. ...
    (RedHat)
  • difficulties with utf-8 characters using DBD::Oracle, where works using DBD::Pg (PostgreSQL)
    ... I have a cgi application that works fine using DBD::Pg to insert/select data ... I have modified the application to use either Oracle or PostgreSQL, ... EOF ...
    (perl.dbi.users)
  • Re: Read from database, write to another database, simultaneously
    ... If you can get Oracle to dump the data in the form of SQL insert ... PostgreSQL the entire job starts to look something like: ... the DB-API capability. ... if not batch: break ...
    (comp.lang.python)
  • Good DBA Book
    ... I'm sure this question has been asked a hundred times, but after looking into google for a few hours, I have so many books, I really don't know which one is right. ... like Oracle Essentials from O'Reilly. ... With all the step required, and if possible, example code and script, what is involved in a production database. ... The course will explain how to use PostgreSQL, ...
    (comp.databases.oracle.server)
  • Re: Please help data management issues!!
    ... I cannot compete with using Oracle any longer. ... I have switched over to PostgreSql ... Or you can invest a huge number of hours to duplicate that which comes out of ... But if anyone was giving away what Larry is selling ... ...
    (comp.unix.solaris)