Environment

In this tutorial we are going to use SQLite database because it's light, fast and suits well for learning purposes.

Before every code example and exercise a database.db database is created with the following tables:

CREATE TABLE `users` (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    firstname VARCHAR(255) NOT NULL DEFAULT '',
    lastname VARCHAR(255) NOT NULL DEFAULT ''
);

Also all the example load DBI modules as:

use DBI;