Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

comment on

( #3333=superdoc: print w/replies, xml ) Need Help??
Programming the Perl DBI - By Descartes & Bunce ISBN: 1-56592-699-4 Copyright 2000, O'Reilly & Associates, Inc.

Capsule Review 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.

Full Review 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. barndoor

In reply to Programming the Perl DBI by barndoor

Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":

  • 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:
    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
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others having an uproarious good time at the Monastery: (5)
    As of 2019-09-21 08:59 GMT
    Find Nodes?
      Voting Booth?
      The room is dark, and your next move is ...

      Results (271 votes). Check out past polls.