Before we start to code in Delphi, it is necessary to have the databases created, and to then connect to those databases in Delphi.
For our project in this chapter, we will work with three tables:
- users
- products
- customers
If you have not installed SQL Server 2008 R2 Express Edition (free) or PostgreSQL 9.3 (also free), you can use the database of your choice, but for the best use of this chapter, we strongly recommend that you follow the instructions contained herein:
- To download SQL Server: https://www.microsoft.com/en-us/sql-server/sql-server-editions-express
- To download PostgreSQL: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
The installation and configuration of the SQL Server and PostgreSQL database managers will not be covered in this chapter.