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

Dear Monks,
In few days I am going to start a new project with MySQL and Perl with heavy data volume. I am good with Perl and basic DBI but not so good with specialized knowledge of MySQL with Perl. I like to get good pointers to train myself.

Thanks,

--Artist

Replies are listed 'Best First'.
Re: Perl and MySQL
by olus (Curate) on Dec 20, 2007 at 16:15 UTC
    Hi artist

    The first pointer would naturally be mysql's documentation :)
    But since you will be dealing with loads of data, I'll leave here pointers to some specifics on architecture solutions implemented by others.

    MySQL and Web2, maybe some marketing stuff, but maybe some things to learn form the links.
    Maximum velocity MySQL presentation.
    Mod_Perl's team recommended reading
    And I know there is a very interesting presentation by Tim Bunce, but I can't seem to find the link.

    update: actually, Tim has several talks on CPAN
[reply]
Re: Perl and MySQL
by amarquis (Curate) on Dec 20, 2007 at 15:54 UTC

    I learned MySQL alongside PHP, and Perl separately. I don't remember hitting any traps or gotchas when I started combining the two.

    Managing & Using MySQL (O'Reilly) was a useful resource, though, even though its focus was on the interactions between MySQL and generic external sources. If I recall correctly, it does have a smallish Perl specific chapter.

    All in all, I think if you've a handle on both separately you won't find any surprises or troubles using 'em together.

[reply]
Re: Perl and MySQL
by narainhere (Monk) on Dec 20, 2007 at 16:31 UTC
    I have read the book Programming the perl DBI and found it useful to cover basics of any databse handling

    The world is so big for any individual to conquer

[reply]
      I would recommend Perl and MySql for the Web by Paul Dubois. It is definatley centered toward using CGI and the web, but also talks alot about DBI etc. 
      use strict;
use CGI;

      [download]
[reply]
[d/l]
Re: Perl and MySQL
by planetscape (Chancellor) on Dec 22, 2007 at 05:41 UTC
[reply]

Back to Seekers of Perl Wisdom