Re: sending mail from Postgres

On Tue, 2005-12-27 at 20:58 -0800, Randal L. Schwartz wrote:
> >>>>> "Tony" == Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com> writes:
>
> Tony> Check out my site at http://www.amsoftwaredesign.com
>
> Tony> and click on the forums link, I have some examples on how to send a
> Tony> email from a function using plperl, also how to connect to a simple
> Tony> socket server and send messages, plus lots of other function examples,
> Tony> some my own and some from the original function cookbook.
>
> I fear for the future.
>
> Did someone forget what a "database" is for?

Hah! A few months ago, I got all excited because I made PostgreSQL
connect to an instance of DRb (distributed ruby) and make an IRC bot
talk on freenode when a trigger was called... it was a nice proof of
concept... but in the end I moved that process into the application
layer.

http://rubyurl.com/t3S (installing pl/ruby-untrusted)

http://rubyurl.com/Dz2 (using plruby and rubygems)

In any event... using Ruby from within a PostgreSQL function is a
snap... just hasn't proved itself very useful outside of allowing some
older PHP applications to use some rubygems in the database.

Robby

--
/**************************************************************
* Robby Russell, Founder & Executive Director *
* PLANET ARGON, LLC | www.planetargon.com *
* Ruby on Rails Development, Consulting, and Hosting *
* Portland, Oregon | p: 503.351.4730 | f: 815.642.4068 *
* blog: www.robbyonrails.com | book: www.programmingrails.com *
***************************************************************/