Accessing databases with FireDAC

Now that we have a database, we need a way to access it, reading and writing data via SQL commands. The best way to do it in a Delphi application is to use FireDAC, a very powerful data access library, which has been a part of the product for many years and offers access to a dozen different database engines with native and specific drivers.

To keep the demo app simple, we are going to use SQLite as the database engine and our ToDo List app will have just one database table called ToDos. SQLite has a simple type system and effectively a column can store null, integer, real, text, or blob values.

In our design, we are going to use an integer Id value as the primary key. We will also need the Title and Category text fields. The key FireDAC component that we will need is a FireDAC database connection. There will also be query components connected to the database connection.

Let’s see how we can add a data access layer to our sample app...