Page 1 of 1

UniDAC vs pgDAC

Posted: Tue 13 Sep 2011 14:47
by gman
Hello,

First of all, a notice that when I try to submit a question your webpage link, I get an error....

Anyway, I am building an app which requires multi database connectivity. A this point, it is Oracle and postgres, but may include other DBS at a later pint in time. I currently have oracle connectivity via direct oracle access vcl components. I am looking at purchasing UniDAC or pgDAC. My concern is that it appears that pgDAC includes capability that UniDAC does not. Is this accurate? I am looking at the professional versions of both products.

Thanks
George S

Posted: Wed 14 Sep 2011 14:15
by AlexP
Hello,

PgDAC is designed to work with PostgreSQL, so it provides wider range of possibilities to work with specific data types, has more options for working with the PostgreSQL database. For example, you can open the Hierarchy Chart article in the PgDAC help and look at the list of objects inherited from TSharedObject (TPgLargeObject, TPgRefCursor, TPgCircle etc.). With the help of these objects you can get access to the PostgreSQL objects and types access to which is unavailable with UniDAC. If any new features are added to PostgreSQL in future, they will be supported by PgDAC in any case, and in UniDAC they will be supported only if they don't influence its universality.

So can I use BOTH pgDAC and UniDAC?

Posted: Mon 19 Sep 2011 15:06
by gman
I got an error when I tried to install both of them... I am overlooking something?
UniDAC should be a SUBSET of pgDAC (at least for Postgres functionality).

Thanks
GS

Posted: Tue 20 Sep 2011 09:02
by AlexP
Hello,

If you are trying to install both products onto the same IDE, the versions of these products should be compatible. The latest compatible versions are PgDAC 3.0.l and UniDAC 4.01. If the versions are not compatible, you will get an error message about product incompatibility when you try installing them.
UniDAC is a wrapper that unifies working with different databases and provides the same interface to them as the separate products do. However, the features that are specific for one database and cannot be unified are not included to UniDAC.