[kw-pm] cool: postgres server-side perl scripting
Daniel R. Allen
da at coder.com
Mon Nov 14 18:34:02 PST 2005
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
More information about the kw-pm
mailing list