Setting up access to tables and queries

Connecting to databases from Delphi is very straightforward. We mentioned FireDAC in Chapter 6, All About LiveBindings, when we showed you how to hook up controls to live data, but now, let's give it a proper introduction.

Utilizing FireDAC, Delphi's cross-platform Data Access Component

FireDAC provides a lightweight, flexible, yet highly optimized data access layer for a multitude of database systems, with many of the differences between them abstracted to greatly simplify working with them in Delphi. The initial connection often provides the most variance as user credentials, server ports, and encryption settings often define many aspects of the underlying engine. After that, the components provide a consistent and seamless interface to the data your application needs while still allowing vendor-specific options to pass through or optimized SQL to be executed.

Note

The exception to the idea of consistency when using various...