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.

written sometime in April 2018

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
All post tags:
FreeBSD , GEOM , Hacktoberfest , Kubuntu , Linux , Open Source , Perl , PostgreSQL , Sqitch , WhiteCat , aglets , api , arco , aspectj , blog , browsers , bsdmagazine , c , c++ , calendario avvento , carmensita , cmake , conferences , cpan-pr-challenge , cups , dataflex , development , devops , digikam , divertimenti , doc , dos , eclipse , egit , emacs , falcon , firefox , flap , fossil , freebsd , freedos , freenas , git , github , gmail , gnome , hacktoberfest , haiku , helm , icaors , ieee , itpug , java , jfk , jsf , kde , kdevelop , kernel , kmail , kubuntu , linux , lisp , magit , matrimoni , maven , maxine , mercurial , microsoft , mp3 , my story about , my story about using , mysql , no shave november , no-shave-november , open source , openbsd , opensolaris , opensource , oracle , password , pcbsd , perl , perl5 , perl6 , perlbrew , perlsphere , pets , pfsense , pgday , php , planet-emacsen-org , planet-kde-org , planet-perl-ironman , planet-postgresql-org , pljava , postgresql , programmazione , programming , programming best practice , python , qt , qupzilla , rcp , research , riflessioni , room number , samba , security , shell , sicurezza , signatures , skype , sqlite , subito.it , svn , swt , sysadmin panics , trasporti , uefi , università , varie , vi , viaggi , web , webcalendar , windows , wtp , zfs , zmv , zsh

FreeBSD

GEOM

Hacktoberfest

Kubuntu

Linux

Open Source

Perl

PostgreSQL

Sqitch

WhiteCat

aglets

api

arco

aspectj

blog

browsers

bsdmagazine

c

c++

calendario avvento

carmensita

cmake

conferences

cpan-pr-challenge

cups

dataflex

development

devops

digikam

divertimenti

doc

dos

eclipse

egit

emacs

falcon

firefox

flap

fossil

freebsd

freedos

freenas

git

github

gmail

gnome

hacktoberfest

haiku

helm

icaors

ieee

itpug

java

jfk

jsf

kde

kdevelop

kernel

kmail

kubuntu

linux

lisp

magit

matrimoni

maven

maxine

mercurial

microsoft

mp3

my story about

my story about using

mysql

no shave november

no-shave-november

open source

openbsd

opensolaris

opensource

oracle

password

pcbsd

perl

perl5

perl6