Free Pascal

Database Tutorials

Lazarus allows for programming database applications. We present tutorials for two well known types of databases:

DBF, the underlying file format for the legendary dBase system. dBase was one of the first database management systems for microcomputers, and the most successful in its day.
The .dbf file format is still widely used by millions of software developers. Many popular applications can export data to and import from .dbf files, such as Open Office, MS Excel, MS Acces, FileMaker.

* Intro to DBF
* Project GuitarClub: a relational RDBMS
* Adding / editing records with validation

SQLite, the most widely deployed database in the world. SQLite is a "self-contained, serverless, zero-configuration, transactional SQL" database engine. It's easy to export/import SQLite databases to and from other formats, such as CSV, formatted text, and various spreadsheets.

* Intro to SQlite
* Simple example with 1 table
* Useful utility for SQLite
* Relationship between tables
* Validation
* Report generator
* Master/detail reports