Re: N-tier, client/model, and business rules?

My main database experience is with Sybase and MySQL. Sybase has stored procedures, but MySQL doesn't have them. Which is one of the many reasons MySQL can't be taken seriously.

AFAIK, Oracle has stored procedures as well. I've done some db2 work, but that was mostly writing an qmail-db2 interface (in C); I don't know whether db2 has stored procedures.

Abigail

Comment on Re: N-tier, client/model, and business rules?

Replies are listed 'Best First'.
Re: Re: N-tier, client/model, and business rules? by BrowserUk (Patriarch) on May 15, 2003 at 20:23 UTC
I don't know whether db2 has stored procedures. It does, as do Informix and SQL Server. I believe, but am not certain, that the concept of stored procedures (and triggers) began with DB2 in order to support CICS and IMS respectively. I agree that MySQL has a long way to go before it can be consider a substitute for any one of the commercial RDMBSs. I've heard that PostGRE is moving up quite rapidly, but also still has a ways to go. That said, given the contrast in the funding for the commercial -v- "free" RDBMSs, they aren't doing at all badly given their relatively short histories. Examine what is said, not who speaks. "Efficiency is intelligent laziness." -David Dunham "When I'm working on a problem, I never think about beauty. I think only how to solve the problem. But when I have finished, if the solution is not beautiful, I know it is wrong." -Richard Buckminster Fuller	[reply]

Replies are listed 'Best First'.

Re: Re: N-tier, client/model, and business rules?
by BrowserUk (Patriarch) on May 15, 2003 at 20:23 UTC

I don't know whether db2 has stored procedures.

It does, as do Informix and SQL Server.

I believe, but am not certain, that the concept of stored procedures (and triggers) began with DB2 in order to support CICS and IMS respectively.

I agree that MySQL has a long way to go before it can be consider a substitute for any one of the commercial RDMBSs. I've heard that PostGRE is moving up quite rapidly, but also still has a ways to go. That said, given the contrast in the funding for the commercial -v- "free" RDBMSs, they aren't doing at all badly given their relatively short histories.

Examine what is said, not who speaks.

"Efficiency is intelligent laziness." -David Dunham
"When I'm working on a problem, I never think about beauty. I think only how to solve the problem. But when I have finished, if the solution is not beautiful, I know it is wrong." -Richard Buckminster Fuller

[reply]