From: Tony Marston <tony@...>
Date: 2004-04-22T09:04:07+09:00
Subject: Re: The quest for opensource database...


"Useko Netsumi" <usenets_remote_this@earthlink.net> wrote in message
news:c66fl8$8i94l$1@ID-205437.news.uni-berlin.de...
> But isn't that supposedly the function of the database trigger - that is
to
> ensure that all contraint are accounted for without kludging it?
>
> But I do get your point though. I'm sure with expertise such as yours, you
> can replace those stored procedures/trigger function in PHP or any
scripting
> language but isn't that stretching it a bit too far?

It is not stretching anything at all. In my early days of programming, which
was before relational databases were fashionable, none of the database
management systems had triggers or procedures, so I learned to write entire
applications without them.

> With stored procedures/trigger, script programmer can concentrate more in
> the flow/design of the application where the database programmer can
> concentrate on the data storage(and simple data manipulation using strored
> procedures) and data constraints(trigger).

I don't work on projects where the database, business logic and screen
layout are dealt with by separate people as this is a recipe for disaster.
There is nothing in a stored procedure or database trigger that I cannot
achieve more easily with PHP code, it is easier to control and it is far
easier to debug.

-- 
Tony Marston

http://www.tonymarston.net