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.
written sometime in April 2018
|
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 !
written sometime in April 2018
|
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.
written sometime in April 2018
|
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…
written sometime in April 2018
|
PostgreSQL 10 and Python 3 (on FreeBSD)
Today a friend of mine asked me for a trouble between PostgreSQL 10 and Python. Since I’m not a pythonist, my quick answer was that PostgreSQL 10 does support Python 3. But it turned out it was not so simple (at least, not so simple as to get Perl 5 working!).
written sometime in April 2018
|