Conference Schedule - PGDay.EU 2010

Back

PL/Perl - new features in 9.0

Date: Dec. 7, 2010
Time: 10:25 - 11:10
Room: Glasgow

Find out all you need to know about the new PL/Perl features in PostgreSQL 9.0 New features include:

  • New utility functions: quote_literal, quote_nullable, quote_ident, encode_bytea, decode_bytea, looks_like_number, encode_array_literal, encode_array_constructor.

  • The use and require commands can be used in plperl for modules that have already been loaded, like strict and warnings.

  • The features module is pre-loaded for perl 5.10+.

  • Better integration with tools like Devel::NYTProf.

  • END blocks and object destructors are run at session end.

  • Added plperl.on_init, plperl.on_plperl_init and plperl.on_plperlu_init GUCs for DBA use. Your plperl functions can now use external Perl modules, if your DBA allows. I'll talk about the security implications of this.

I'll also demonstrate using Devel::NYTProf to performance profile your PL/Perl functions.

Speaker

Tim Bunce

Privacy Policy | About the website
Copyright © 2008-2017 PostgreSQL Europe