Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re^4: perl & SQL best practices

by ksublondie (Pilgrim)
on Apr 27, 2012 at 23:01 UTC ( #967734=note: print w/ replies, xml ) Need Help??


in reply to Re^3: perl & SQL best practices
in thread perl & SQL best practices

So, you have no bottlenecks, no goals (performance wise), you're rather small, and all you can tell about your future is that you're adding "canned applications, along with my custom coding".

Yea, you're correct.

What do you expect to get?

Your advice. Tell me what you do or would do as a programmer if you had complete control over your db server. Are there any practices you yourself follow? Of course, we all use strict. Do you have similar rules you follow and/or made in regards to sql db interaction? Do/would you develop your sql from your perl or instead put it outside on the db server? And what are your reasons for doing it that way?


Comment on Re^4: perl & SQL best practices
Download Code
Re^5: perl & SQL best practices
by JavaFan (Canon) on Apr 27, 2012 at 23:19 UTC
    Tell me what you do or would do as a programmer if you had complete control over your db server.
    How many times do I need to repeat: IT DEPENDS. Define goals. Measure. Know what the budget is. Work out what needs to be done. There are no magic bullets.
    Of course, we all use strict.
    That's like saying: "what should I do when I need to transport something? Of course we all check our headlights first." If you don't tell me what you need to transport from which pickup point to which destination, at what time, what the budget for it is, what your resources are and when it has to be there, don't expect me to tell you whether you should use a bicycle, a pick-up truck a train, or whether you should hire a specialist company. Magic bullets do not exist.
    Do you have similar rules you follow
    I do have rules I follow (but they aren't as mindless, boring and and a bit more useful than "use strict"), and they are: do not do anything without knowing what's going on, what the goal is, and what the budget is (budget is to be taken in a broad sense. It includes, but is not limited to: money, people, time frame, regulations, knowledge). Aka, don't run around as a headless chicken, going in any direction monks in the peanut gallery are shouting to you.

      ... as mindless, boring and and a bit more useful than "use strict" ..
      Not to be picky or anything, but the advice to "use strict" is not mindless, nor is it not useful, so you've got two obvious strikes out of three (and an umpire call on the third).

      The point the OP was making should be obvious: there are indeed areas where a consensus exists on what's the best practice, and he wants to hear about others.

      I do have rules I follow ... and they are: do not do anything without knowing what's going on
      So you mean you never do anything?

        Not to be picky or anything, but the advice to "use strict" is not mindless, nor is it not useful, so you've got two obvious strikes out of three (and an umpire call on the third).
        In the grand scheme of things, "using strict" is mindless, boring, and compared to other things, utterly unimportant. It's on the list of "useful things to do", around place 3000, along with eating enough fruit and vegetables. "use strict" isn't the magic bullet some people think it is. Slapping "use strict" on a program doesn't make it better.
        The point the OP was making should be obvious: there are indeed areas where a consensus exists on what's the best practice, and he wants to hear about others.
        Whether or not there's consensus, the point is, the OP remained too vague on his circumstances to even determine what area he's talking about.
        So you mean you never do anything?
        No, it means I'm informed.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (13)
As of 2014-08-28 15:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (263 votes), past polls