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

Re: Object Oriented SQL

by Anonymous Monk
on Sep 10, 2000 at 01:02 UTC ( #31770=note: print w/replies, xml ) Need Help??

in reply to Object Oriented SQL

Eak wrote: "Do you just squirrel away SQL throughout your code?"

Depends on the scale of the project.

On large projects, there are some good arguments for hiding (encapsulating) all of the nitty gritty SQL behind stored procedures inside the database. That way, should the backend database change, all well-behaved front-end apps that read and write data through the stored procedures wont break.

On medium-size projects, I hide (encapsulate) the SQL inside purposeful functions (eg insert_new_customer( ... ), get_all_customers( ... )) and share these functions across the project by putting them in a module.

Replies are listed 'Best First'.
RE: Re: Object Oriented SQL
by nop (Hermit) on Sep 10, 2000 at 01:19 UTC
    oops... forgot to login... the previous post was mine, nop.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (6)
As of 2022-05-20 11:05 GMT
Find Nodes?
    Voting Booth?
    Do you prefer to work remotely?

    Results (73 votes). Check out past polls.