Up to now, our
SynDB database classes were handling
ODBC, OleDB providers and direct Oracle or
We have added a
DB.pas based layer, ready to be used with
UniDAC, NexusDB, or the BDE.
TDataset based component is ready to be interfaced,
including UIB, AnyDAC or DBExpress.
The ZEOS library (in its latest 7.0.3
stable version, which works from Delphi 7 up to XE3) has also been
interfaced, but without the
SynDBZEOS.pas unit calls the ZDBC layer, which is not
DB.pas nor its RAD components, and is therefore
faster. By the way, it will work also with the Starter edition of
Delphi (which does not include the DB components) - just like the other
This is a work in progress, any testing and feedback is welcome!
We had to circumvent some particularities of the libraries, but I guess we have
A dedicated "SynDBDataset" sub-folder has been created in the repository, to contain all
SynDBDataset.pas-based database providers.
SynDBNexusDB.pas unit has been moved within this sub-folder,
SynDBBDE.pas units have
SynDBZeos.pas has a direct access to the ZDBC layer, so
is not part of the "SynDBDataset" sub-folder.
Here is some benchmark, mainly about Oracle and
SQlite3 database access.
Of course, our direct
layers are the fastest around, and we can see that ZDBC layer is sometimes more
efficient than the