In contrast to the previous Delphi Starter, the free Delphi Community lets you develop more complex database applications.
SQL stands for Structured Query Language. SQL allows working with relational databases.
SQLite is the most widely deployed database in the world, with many millions of installations. You can find it on Windows, on all iOS and Android mobile devices and on Mac OS desktops. It is used by The United States Library of Congress (a recommended storage format for preservation of digital content), Microsoft, Firefox, Skype, Microsoft, Google, McAfee anti-virus, and many more.
A complete SQLite database with multiple tables, indices, and so on, is contained in a single disk file.
Field types, aka "storage classes":
There is no separate Boolean
storage class. Instead, Boolean
values are stored as integers 0 (false) and 1 (true).
Information held in an SQLite database file is easily accessible using commonly available open-source tools, such as DB Browser for SQLite (more info: sqlitebrowser.org)
SQLite and Delphi
You find the necessary Delphi components on the FireDAC tab of the component palette.
The advantage of using FireDAC is that it is fairly easy to change to a different type of database, such MSAccess or InterBase, without changing your program too much.
Tutorial project: Geo
We'll show you how to set up and program a Database Management System (DBMS) for maintaining a table with countries and some of their properties.