In this section, we are going to discuss FireDAC, the data access library shipped with Delphi. We'll discuss the general architecture as well as some key points that make this library very effective for every Delphi developer.
There are many things I love about FireDAC, and they are as follows:
- It is a well-designed library, with a neat separation across functions, classes, and component layers; given this separation and another kind of separation, across functionalities, you can pick what you need and leave the rest out of your applications.
- The base concept of this DAC library is to provide access to a wide variety of database servers through the same programming interface, with a non-limiting approach that enables cross-database system programming as well as direct access to each system's peculiar features.
- It enables high-level features (such as in-memory datasets, filters, grouping, local SQL, persistence, macros, array DML, fetching...