http://www.perlmonks.org?node_id=967734


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?

Replies are listed 'Best First'.
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.
[reply]

      ... 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?

[reply]
        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.
[reply]

In Section Seekers of Perl Wisdom