[kw-pm] cool: postgres server-side perl scripting

[Daniel R. Allen]

On Mon, 14 Nov 2005, Matt Sergeant wrote:

> On 14 Nov 2005, at 17:11, Daniel R. Allen wrote:

> > Anybody around here use postgres?
>
> We use it for a number of large scale projects, but never found a real
> need for pl/perl. Sadly there is one horrible bug in Pg's stored
> procedure language (at least there was last time I used it in anger -
> back in 7.x days) that temp tables weren't temporary - they were
> created once and cached sort of like a mod_perl version of temp tables.
> I hope that's fixed in the 8.x series...

>From the oreilly article, it sounded like pl/perl has grown up a bit;
I'd be surprised if a bug that glaring wasn't fixed; but I've not used it
myself.

> BTW: You can have perl functions in SQLite via DBD::SQLite too.

Wow.  ...looking at the perldoc...  that's pretty neat.  I could totally
see that making database code cleaner.

I gotta ask, does that slow things down much?

-Daniel