Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Re: (z) Separation of SQL code

by htoug (Deacon)
on Sep 12, 2003 at 06:47 UTC ( #290941=note: print w/ replies, xml ) Need Help??


in reply to Re: (z) Separation of SQL code
in thread (z) Separation of SQL code

You might even separate the layers into separate processes, perhaps even on separate machines.

We've done that with very good results. There are benefits to be had from protecting the application from the "messy" database design: if you normalize your database design - as you should - the database tables often bear very little resemblance to wwhat the user sees. Keeping that mapping in a tightly controlled module is Good(TM). Further benefits are to be got from using stored procedures (as Abigail-II notes)

Having the front-end (user and possibly badguy accessible) macine not having direct access to your valuable database is also a security bonus.


Comment on Re: Re: (z) Separation of SQL code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (6)
As of 2014-12-20 22:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (99 votes), past polls