Checking PostgreSQL Version in Scripts

psql(1) has a bar support for conditionals, that can be used to check PostgreSQL version and act accordingly in scripts.

Suggesting Single-Column Primary Keys (almost) Automatically

Is it possible to infer primary keys automatically? If it, I’m not able at doing that, but at least I can try.

As powerful as tar(1) is ...

tar(1) is probably one of the most frequently used command by any Unix sysadmin. But the BSD version has a lot of features hidden to Linux users!

Jekyll Blog Statistics: a Perl Program to Graph Them

Having to manually launch a few programs to compute statistics, graphs and copying and pasting the results was quite boring. Here I show my personal approach to solve the problem in a quick way.

Generate Primary Keys (almost) Automatically

What if your database design is so poor that you need to refactor tables in order to add primary keys?