I like DBD::SQLite very much. It's extremely easy to install, and when you move a project over to another box, you don't need to copy the database separately. It doesn't work with a server, but that is okay for what I do with it. SQLite is fast and feature-rich and worth checking out.

Depending on the application, you may find Class::DBI very useful. Perhaps you want to write the queries yourself. In that case, have a look at DBIx::Simple. If you need extreme power or extreme speed, learn how to use DBI directly.

Do read The fine art of database programming and Before asking a database related question ... by gmax.

As usual, don't forget to use strict and small scopes. Database modules bite less if you let them destroy objects when they're no longer needed.

Juerd # { site => 'juerd.nl', plp_site => 'plp.juerd.nl', do_not_use => 'spamtrap' }