SQL and Perl

Justin S's picture

They have: 2,076 posts

Joined: Jun 1999

Ok- here is my question: I want to create a database script using Perl and SQL. I've never used SQL in my life, but I've decided to try it instead of just a text file for storing stuff because I've heard it's faster. Are there any resources or tutorials on how to use SQL for what I want to do? How do i start?

------------------
Flame Hosting : http://www.flamehosting.com
NT and UNIX Hosting, Dedicated Servers, and Co-Location Programs

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Justin,

I don't have much experience using Perl with SQL. Depending on how you're using Perl (PHP or CGI) you might have to get hold of a module or DBI to be able to connect Perl with SQL.

Try doing a search on deja.com (usenet discussion) for Perl and SQL, I'm sure there will be lots of reference material there.

If you know Perl learning the SQL syntax should be no problem, it's fairly simple.

Regards,
Peter J. Boettcher

PJ | Are we there yet?
pjboettcher.com

They have: 5,633 posts

Joined: Jan 1970

Justin,

Integrating Perl with SQL is pretty simple, however using PHP is the way to go if you can.

Check out http://www.devshed.com/Server_Side/MySQL/Intro/ for good tutorial on mySQL. Even if your using another SQL flavor it will give you the basics. In terms of modules and DBI’s search Perl.com for the exact SQL flavor your using.

Good luck,

------------------
Adam
AIS Internet Solutions
[email protected]
www.aisinternet.com

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.