in reply to newbie asking for perl connection with Databases

You don't need phpmyadmin at all - unless you want a web based database management tool. I prefer to use the standard mysql client program when I can.

Anyway, you need 2 modules: DBI and DBD::mysql. DBI is the standard database engine for perl and DBD::mysql is the mysql driver for DBI. Both are pretty well documented.

If you want to do OO-relational mapping take a look at DBIx::Class - you don't need it, but it sure can make things easier.

  • Comment on Re: newbie asking for perl connection with Databases

Replies are listed 'Best First'.
Re^2: newbie asking for perl connection with Databases
by adam_blackice (Acolyte) on Mar 31, 2007 at 17:22 UTC
    thanx ....., but this all the tools i need ..... what other resources can i use to undestand it deeply ? ...... and what about using LAMP (xampp tool) from apachefriends.org is that suitable for perl or itis for php only and will it make things easier ? . ...
      XAMPP does provide perl. I know they do, because they say so on their website:
      The distribution for Windows 98, NT, 2000 and XP. This version contains: Apache, MySQL, PHP + PEAR, Perl, mod_php, mod_perl, mod_ssl, OpenSSL, phpMyAdmin, Webalizer, Mercury Mail Transport System for Win32 and NetWare Systems v3.32, JpGraph, FileZilla FTP Server, mcrypt, eAccelerator, SQLite, and WEB-DAV + mod_auth_mysql.

      Apparently, they also provide add-ons with DBI/dbd::mysql. Or maybe that's included in the base install. Not sure.

      If you're on windows, xampp might be a good way of getting precompiled binaries for everything involved. On most unix/linux systems you can usually get all the tools from your system distributer - or at least you should get a decent C compiler so you can compile everything yourself.