12. Databases

Perl’s DBI module makes it extremely easy to interact with almost every popular database server (and many not-so-popular ones). Although the mechanics are quite simple and straightforward, there are many higher-level pitfalls.

Database interaction is a specialized topic, since it requires knowledge of a lot more than just Perl. You have to know about the query language, the peculiarities of the database server, and many other extra-Perl things. It’s an extremely big topic that deserves a book of its own. However, there are a few things that improve your Perl database experience right away.

We’re purposely ignoring some topics, such as KiokuDB, document database systems such as CouchDB, and Object Relational Mappers (ORMs) such ...

Get Effective Perl Programming: Ways to Write Better, More Idiomatic Perl, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.