Re: stored procedures and triggers

2002-09-05 Thread Curtis Maurand
I have to agree here.If one doesn't know the schema and has to figure out how to locate keys in related tables, then one's not paying too much attention to the constructs of the data set. Lets not forget joins, eh? What network traffic? The list of tables? How much traffic is there in a q

Re: stored procedures and triggers

2002-09-03 Thread yvictorovich
That's only if you access it directly from client. What I was talking about is AppServer sitting next to MySQL server. Preferably on the same computer. Agree that for some cascade actions triggers are very useful. But most of the folks just try to push all business logic into sp/triggers. And th

Re: stored procedures and triggers

2002-09-02 Thread yvictorovich
I would like to see the triggers/stored procedures/views in MySQL also. And the only estimate I saw somewhere was "around version 5.0". But think about this this way: in the complex enterprise-level system you would probably need some kind of application server instead of direct client-db access.

Re: Stored Procedures and Triggers

2001-09-03 Thread David Turner
Great thanks, I'll check it out. Dave On Mon, Sep 03, 2001 at 01:49:31PM -0700, Steve Edberg wrote: > At 1:10 PM -0700 9/3/01, David Turner wrote: > >A friend of mine mentioned something about perl stored procedures for > >MYSQL. Has anyone heard about this? I have searched everywhere and only >

Re: Stored Procedures and Triggers of MySQL

2001-09-03 Thread Alexander Skwar
So sprach »Kimman Lui« am 2001-09-03 um 16:26:33 +0800 : > How many types of triggers MySQL have? And what about stored procedures? none and (close to) none. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects

Re: Stored Procedures and Triggers

2001-09-03 Thread Steve Edberg
At 1:10 PM -0700 9/3/01, David Turner wrote: >A friend of mine mentioned something about perl stored procedures for >MYSQL. Has anyone heard about this? I have searched everywhere and only >seen posts related to POSTGRESQL. If they have this for MYSQL it would >be really helpful. That would be My

Re: Stored Procedures and Triggers

2001-09-03 Thread David Turner
A friend of mine mentioned something about perl stored procedures for MYSQL. Has anyone heard about this? I have searched everywhere and only seen posts related to POSTGRESQL. If they have this for MYSQL it would be really helpful. Thanks, Dave On Mon, Sep 03, 2001 at 01:37:23AM -0700, Jeremy Zaw

Re: Stored Procedures and Triggers

2001-09-03 Thread Jeremy Zawodny
On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui wrote: > > How many types of triggers MySQL have? And what about stored procedures? Zero and Zero, as explained in the docs. If you need them today, I'd suggest looking at PostgreSQL. If you're patient, they'll likely appear in MySQL someday-