Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

what's a better code design priciple?

Principles? I've heard of those.

If you're writing a serious application for a real RDBMS (Oracle or
PostgreSQL), it's worth your time to put the business logic in stored
procedures and make your front ends more declarative than procedural.

However that tends to lock you into a particular database forever.

If you're using MySQL, you simply don't have that choice. You have to put
all the logic in your application. You also don't need to worry about the
overhead of multiple queries because it's so damn fast. Beware of locking,
consistency, and backup issues, though.

Here's an entertaining introduction to the topic.
Rich Graves <rcgraves at>
UNet Systems Administrator

Please don't talk to me about Windows 2000. If you did, it might become illegal
for me to support it.

Subcription/unsubscription/info requests: send e-mail with
"subscribe", "unsubscribe", or "info" on the first line of the
message body to discuss-request at (Subject line is ignored).

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /