perl and DBI

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I don't have enough money to buy the book, does anyone know of a good thorough tutorial on how to use MySQL or other real databases specifically in Perl? I want to print off a few tutorials and give them a read.

Using SDBM and DB_File get so tiresome having to join and split values all the time, I figure it's finally time to get off my lazy butt and learn the real deal.

Any suggestions?

Comment on perl and DBI

Replies are listed 'Best First'.
Re: perl and DBI by Art_XIV (Hermit) on Jan 12, 2004 at 20:08 UTC
Here's a link to an introduction that's pretty good. It assumes you know absolutely nothing about DBI. Hanlon's Razor - "Never attribute to malice that which can be adequately explained by stupidity"	[reply]
Re: perl and DBI by kutsu (Priest) on Jan 12, 2004 at 19:43 UTC
If you want books check out the Book Reviews on this site for a lot of good options and a few DBI Tutorials. Also just read the documentation, for DBI as well, and search google. "Cogito cogito ergo cogito sum - I think that I think, therefore I think that I am." Ambrose Bierce	[reply]
Re: perl and DBI by bart (Canon) on Jan 12, 2004 at 21:26 UTC
There's a beginner-friendly tutorial on Webmonkey. After that, most of the DBI book is actually in the POD. Don't forget to check out the DBI::FAQ (which comes with DBI), and the DBI homepage.	[reply]
•Re: perl and DBI by merlyn (Sage) on Jan 12, 2004 at 19:27 UTC
If you want a lightweight database for testing or local use, use DBD::SQLite (which installs its own "serverless server"). When you want a real high-performance database that's ACID compliant, get PostgreSQL, and DBD::Pg. There's no point to start a new installation with MySQL any more, since SQLite to Pg now cover the spectrum overlapping nicely. MySQL is soooo 90's. {grin} -- Randal L. Schwartz, Perl hacker Be sure to read my standard disclaimer if this is a reply.	[reply]