On Dec 6, 2010, at 3:46 AM, Tim Bunce wrote: > I'm at PGDay Europe 2010 (http://2010.pgday.eu/) > > On Tuesday morning (that's tomorrow as I write this) I'm giving a talk > called "PL/Perl - New features in 9.0". > > It would be a great help to me if I could get a better idea of how other > people use PostgreSQL PL/Perl. > > What kinds of things do you use PL/Perl in the server for? > How much PL/Perl code do you have (approximate number of functions and lines)? > What kinds of CPAN modules would you like to use in PL/Perl?
I used PL/Perl in the PGXN code to create JSON-parsing and -formatting functions using JSON::XS. It was nice to be able to just use those libraries (loaded at server startup with plperl.on_init) and have them just work, very well. Basically, I go to PL/Perl when I need to do text processing. Best, David