Perl/MySql

[Steven]

I really really want to learn how to use mysql. I don't know much about it. I want to be able to store member information in something other than a simple old text database, and collect that data using a form and have it written to the database with a perl script.

I can create text databases just fine, but they just arent good enough for me. If anybody knows of some really good websites that can each me how to use mysql and a bit about it, it would be appreciated, thank you

[Edited by Steven on 04-28-2001 at 03:00 AM]

[Gonzo]

http://www.mysql.com

[razor]

why dont u just use php instead of perl, it is faster.

[Gonzo]

Originally posted by razor
why dont u just use php instead of perl, it is faster.
And much easyer.

[gyrbo]

Originally posted by Gonzo

Originally posted by razor
why dont u just use php instead of perl, it is faster.
And much easyer.
And I don't even think perl can handle MySQL. Correct me if I'm wrong.

[Dusty]

And I don't even think perl can handle MySQL. Correct me if I'm wrong.

You're wrong. MySQL predates PHP by two years, Perl predates it by sixteen. MySQL and Perl were being used together (using Perl's DBI module) before PHP even existed. *

On a side note, SQL in general was around before either of them, IBM invented that way back in the '70s.

Though I will agree that PHP is more suited to MySQL, that by no means prevents Steven from using it with Perl. Ease of use shouldn't be a factor, if we stuck to things easy we'd all be using BASIC. The speed difference, under normal conditions, between Perl and PHP is negligible and really doesn't come into play when writing simple scripts not intended to be heavily used.

"Short Guide to DBI" can be found at http://www.perl.com/pub/1999/10/DBI.html.


* Yes, technically PHP was created in 1994, but the first version was actually written in Perl so it can hardly be called a language unto itself. "Real" PHP was created in 1997. Plus, I'm not exactly sure when MySQL was created. I'm guessing 1995 since that's the earliest I can find anything written about it. It may of been around before then.

[Steven]

I never thought about using php actually. Im not sure why, It would probably be easier and quicker. I was just interested in learning a bit about MySQL is all. Actually thanks for the advice I think I will learn about php. I know f2s allows php and since that was the server I planned on doing it on anyway I wont have to find a new host.

[lucifer]

Perl is a nice language but for many web applications php is just so easy you don't even need to get variables out of cookies forms etc

well worth the day or 2 it takes to get the hang of

it's so easy it doesn't matter that the documentation sucks