Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Perl and MySQL

by artist (Parson)
on Dec 20, 2007 at 15:34 UTC ( #658132=perlquestion: print w/replies, xml ) Need Help??

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.



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

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

      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;
Re: Perl and MySQL
by planetscape (Chancellor) on Dec 22, 2007 at 05:41 UTC

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://658132]
Approved by Corion
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2022-09-27 05:43 GMT
Find Nodes?
    Voting Booth?
    I prefer my indexes to start at:

    Results (118 votes). Check out past polls.