Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: SQuirreL Monks

by Coyote (Deacon)
on Apr 10, 2001 at 00:13 UTC ( [id://71129]=note: print w/replies, xml ) Need Help??


in reply to SQuirreL Monks

I wouldn't vote down a question related to SQL as long as it was in the context of a perl program. I view SQL questions much like I view regex related questions in the respect that regexen are applicable to many tools outside of perl.

I've spent a number of years as a *nix sysadmin and I've seen many bad CGI scripts cross my desk. The most common problems I see with CGI scripts are:

  • the programmer did not use CGI.pm
  • the programmer did not use strict and #!perl -wT
  • the programmer used very inefficient or sloppy SQL

I can't tell you how many times I've seen a perl program come across my desk where the author used "SELECT * FROM some_table" and looped through thousands of rows to find a single value from a single column. So in summary, I don't have any problems with SQL related questions (or answers) in the monestary.

I will be interested to hear what others have to say on this matter, I've been thinking about doing a review for Joe Celko's SQL for Smarties: Advanced SQL Programming. The book has no perl code or mention of perl in it whatsoever, but it has been an invaluable tool for me in the context of perl, PHP, and VB development. I haven't done the review yet as I'm not sure if a review of a SQL book is appropriate on PM.

----
Coyote

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://71129]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others cooling their heels in the Monastery: (5)
As of 2024-04-25 08:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found