Luca Ferrari
Open Source advocate, human being
plperl: invoking other subroutines
plperl does not allow direct sub invocation, so the only way is to execute a query.
PostgreSQL online course via BSD Magazine
I’m preparing another short course on PostgreSQL, this time online with written material.
plperl: which version of Perl?
plperl is a great extension for PostgreSQL that allows the execution of Perl 5 code within the database.
When your effort is publicly recognized (2)
I’ve already written about the importance of having a public recognition about everyone’s effort.
Improving the Perl 6 documentation
Today I hit the 200th commit on the Perl 6 Documentation project. Nothing special, but I’m glad to be part of such project.
Renaming a table in SQLite3 (and PostgreSQL)
Renaming a table is a very powerful feature of every database. SQLite3, as flexible as it is, has a feature to not cascade the renaming to foreign keys. Depending on how (and why) you use such feature, it can allow you for doing poweful things or ruin your database.
Generating an italian 'Codice Fiscale' via plpgsql or plperl
PostgreSQL built-in plpgsql can be used to build stored procedure and, with a few tricks, to consume data and translate it into other forms. It is also possible to generate a so known codice fiscale, the italian string that represents the tax payer number based on the person’s name, birth date and place.
This posts will show some concepts about how to generate the single pieces of the codice fiscale via plpgsql.
And why not? Let’s compare it to a plperl implementation.
Apache, PHP, Systemd and PrivateTemp
While systemd is a great tool, the way it is (ad)used by Linux distributions could make developers spend a few hours trying to solve stupid and trivial problems… as writing a simple file to /tmp!
What happens when you add a column?
Adding a column with a default value requires a full table rewrite, and therefore it is often suggested to avoid the default value. However, it is possible to add the default value without having PostgreSQL perform the full table rewrite.
PostgreSQL 10 short course in Modena
The local Linux Users’ Group ConoscereLinux is delivering a six-part course on PostgreSQL 10. Guess who’s lecturing…