sql module for perl?

Doomhead · #1 09-18-2003, 08:34 AM

Anyone know if there is a module for PERL that can access an sql database?

When the devs come out with a stable 5.0, I want to make some web cgi apps that can access and alter the database. I also want to use the web apps to allow users to sign up before they can play on my server (use default status of -2 then webapp will set to 0 once registered. I could use the shell to do this while the server is up using the commands to world.exe but would rather go directly to the db.)

#2 09-18-2003, 08:45 AM

I Googled for mysql and Perl and got this link ... not sure if this is the sort of thing you are looking for

http://www.mysql.com/portal/software/item-77.html

http://search.cpan.org/author/RUDY/D...b/DBD/mysql.pm

**Rogean** · #3 09-18-2003, 10:05 AM

Doomhead:

Your avatar is asking for an Admin Login to Guildmaster.Wox.Org. I Recomend you check it out

krich · #4 09-20-2003, 04:28 PM

PHP is good for that too.

Just a thought,

krich

Doomhead · #5 09-22-2003, 09:02 AM

Lost my power and someone else got my IP. It's updated now so it will work now.

BTW thanks for the info, i'll look into it.

Eglin · #6 11-26-2003, 10:47 PM

Quote:

Originally Posted by Doomhead

Anyone know if there is a module for PERL that can access an sql database?

Yeah. DBI/DBD work wonderfully. I usually use DBI via ODBC, since almost all dists. include the ODBC bridge. You can, however, download the DBD for your db (e.g. DBD::mysql) to go directly through your dbms. I posted some code that does just that in another thread. Feel free to rip it off.