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.
written sometime in July 2019
|
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.
written sometime in July 2019
|
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!
written sometime in July 2019
|
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.
written sometime in July 2019
|
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?
written sometime in July 2019
|