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
Report generator
Master/detail reports