Subject RE: [firebird-support] Re: Emailing from Firebird 1.5 (Linux) in a trigger?
Author Alan McDonald
> I agree that with events one can have more control, a distinct
> application that are not on the server to handle e-mailing, etc. but why
> you said thats is not recommended to use an UDF ?
>
> Bad written UDF can crash the server, but once the UDF are ok, I see no
> problem using it.
>
> see you !
>
> --
>
> Alexandre Benson Smith

I just think that the sendmail process is stepping out too far from the
inline process of the database server. For the same reason you don't use
UDFs to access another database or write to an external file (not including
debugging process in dev process).
It's a better design to have a a trigger store a record of "sendmail" and
have an external application poll the db and query these records. It then
sends email outside any process of the db server. I don't use events - I'm
afraid they have always had something wrong with them and there are other
more reliable ways to do things with less network traffic etc.
Alan
PS - but if you want to, you can do it. There's nothing stopping you.