From: Useko Netsumi <usenets_remote_this@...>
Date: 2004-04-22T00:34:06+09:00
Subject: Re: The quest for opensource database...

May be we can get away with the strored procedures. Why would one do
manipulation of the data inside a database engine, right? The function of
database is to store and retrieve information, that's it. Beyond that you
really stretch it and this where scripting language such as Ruby comes in.

But for trigger, to write a commercial grade transaction processing
application, you definitely need trigger. Trigger will aid
programmers/designer to ensure certain consistency checking happen
before/after certain opearation. How would you do that outside the database
engine withouth kludging it?

Just my 2cents back from my college days.


For simple and less-dynamic-update application, you might not need tri
"Tony Marston" <tony@NOSPAM.demon.co.uk> wrote in message
news:c65jm0$nl$1$8302bc10@news.demon.co.uk...
>
> "Ruby Tuesdays" <NoSpamPlease_rubytuzdaiz@yahoo.com> wrote in message
> news:c63aer$7ck4g$1@ID-205437.news.uni-berlin.de...
> > Perhaps you database guru able to suggest what would be a good choice
for
> > opensource database platform to use to develop projects.
> >
> > At the moment the project is small/medium, but it will grow in size both
> > data, users, and number of transactions. I'm using MySQL for right now
but
> > it lack of trigger, stored procedures, etc ... it sometimes slows the
> > project.
>
> You do not need stored procedures or database triggers to write successful
> applications. I once had to maintain a system that was built around
> procedures and triggers, and it was a nightmare. The problem was that one
> trigger/procedure updated several tables, which fired more triggers which
> contained more updates which fired more triggers ..... It was impossible
to
> keep track of what was being fired where.
>
> Another reason I prefer to put all my business logic into PHP code instead
> of triggers is that PHP code is a lot easier to debug. Have you come
across
> an interactive debugger for database procedures and triggers?
>
> -- 
> Tony Marston
>
> http://www.tonymarston.net
>
>
>
> > Is PostgreSQL any better/worse? Or is that any other choice beside the
> two?
> > Thanks.
> >
> >
>
>