|Programming the Perl DBI
- By Descartes & Bunce
Copyright 2000, O'Reilly & Associates, Inc.
A great solid book on the subject. 5 stars out of 5.
Who should be interested in this book?
Anyone who needs to access databases from Perl.
Anyone who needs to store complex structured data from Perl.
If your like me and find that a lot of the scripts you write need to access data
stored in a database of some kind then DBI is the way to get at it and this book
is the one to tell you how.
After a short introduction the book starts with database basics and the storage
of data in flat files. It explains what flat files are good at and what they aren't.
It also explains how to get more complex data structures into flat files.
The book then moves on to the various hash based Database Managers that are available.
Again it gives plenty of examples and shows the pros and cons of these tools.
The book then plunges into an introduction to SQL and Relational databases. If your already
used to these technologies you can skip this chapter as it is really just a short primer.
We then get into DBI for real and start to use the objects provided by the module. Connection,
disconnection, queries and updates are all covered in detail with lots of example code and
details of where specific methods should be used.
The DBI Shell (an interactive SQL tool which uses DBI) is covered as well as writing Database proxies.
A good class reference is included as well as specific information on most of the main relational
databases and their particular quirks when it comes to DBI.
The book is quite new and therefore is quite up to date.
I found it invaluable when learning DBI and still refer to it regularly whilst cutting code. I would
thoroughly recommend it to anyone who wants to harness the power of databases inside their Perl code.
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||