IBDAC vs. UniDAC with Firebird-Database

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
AsterixBT
Posts: 11
Joined: Fri 17 Mar 2017 09:50

IBDAC vs. UniDAC with Firebird-Database

Post by AsterixBT » Fri 04 Feb 2022 13:40

Hello!

We have been using IBDAC for our Firebird application for many years. Only later interfaces to foreign SQL databases (MS-SQL, Oracle, etc.) were added. For these functions we use UniDAC in parallel.

Now my questions

Can anyone tell me if IBDAC is better than UniDAC in terms of functionality and speed?

The change to Firebird 4.0 is imminent. According to some internet statements IBDAC will not fully support Firebird 4 regarding functions. Is UniDAC better than IBDAC in this case?

Thanks for your answers and tips
Gerd
Germany / Bavaria

frickler
Posts: 37
Joined: Wed 04 Apr 2018 08:30

Re: IBDAC vs. UniDAC with Firebird-Database

Post by frickler » Tue 08 Feb 2022 14:36

Can anyone tell me if IBDAC is better than UniDAC in terms of functionality and speed?
As not all of the functions of IBDAC are included in UniDAC - yes. For example none of the management components (backup, restore, ...) are included in UniDAC.

pavelpd
Devart Team
Posts: 109
Joined: Thu 06 Jan 2022 14:16

Re: IBDAC vs. UniDAC with Firebird-Database

Post by pavelpd » Tue 08 Feb 2022 17:00

Kindly note that IBDAC allows you to work only with InterBase (Firebird). You can use UniDAC, which is a universal product for accessing various databases.
UniDAC is a universal set of components that provides a transparent server-independent interface for working with different databases (for example InterBase, PostgreSQL, SQL Server, Oracle and others).
However, IBDAC has access to more server-specific features such as administration services, extended transaction support and so on you can learn more about IBDAC features here: http://devart.com/ibdac/features.html and about UniDAC features here: http://devart.com/unidac/features.html.
So, if you want to use server-specific functionality of each database server, it's better to use specific DAC components. If you are not interested in using server-specific features, you can use UniDAC.
UniDAC uses each DAC components functionality, so you will have almost the same performance with UniDAC and specific DAC components.

Please clarify what you mean by some internet statements IBDAC will not fully support Firebird 4 regarding functions.

If some support for Firebird 4 is specific only to Firebird, then it will definitely be in IBDAC and it may not be in UniDAC.

Post Reply