A database accident
04 Feb 2026
While cleaning up my web host account I accidentally destroyed the database of this website, so navigating to digitalkOmiX.com threw a 500 error. Fortunately my web host makes automatic backups, so I just emailed the support team and I received a response within minutes. The *.dump file was uploaded to my account, ready to be restored. A brief explanation of "how to fix" was provided, all by email.
First I had to recreate the database with the same name of the deleted one, along with it's user. Upon creation a new password was issued, so I had to copy/paste it. Accessing my account via SSH in the same directory where the *.dump file was uploaded, I restored the Postgres database with the following command:
pg-restore -U <database user> -d <database name> file.dump
I was prompted for the new password and the process worked seamlessly. Next I had to update the same password in the configuration file of the application that managed the database. I restarted the server and the website was back online!
Huge thanks to the (((Opalstack staff!
My StudioLab
30 Jan 2026
I already have a homelab, but it sits in my studio, so I'll call it StudioLab. It's made from a small HP we had at work, RAM 16 GB, two SSD respectively 512 and 256 GB. It's too big and noisy to stay at home, but suitable for a work environment. It has Proxmox installed, here I learned to use VMs and Linux containers. Actually there is a LXC for a name server (BIND) and a VM with an Immich instance, other stuff is just shut down. The machine is remote controlled via a Tailscale VPN.
Let's build a HomeLab
29 Jan 2026
I'm building a homelab! First you need a machine: I bought this refurbished Lenovo ThinkCentre M710q Tiny, 16 GB of RAM and a 512 GB SSD. It's a very cute computer, small and quiet. Just one screw and you can access all the internals, on the bottom there is also place for another drive, a NVMe SSD (maybe I'll buy it and install the OS there to speed it up). It comes with Windows 10 Pro installed, but I'll swap it with Ubuntu 24.04. Of course they messed up with the shipment (the SATA SSD is half the size), and I'm waiting for the replacement.
In memoria di Francesco Guerra
26 Jun 2025
La settimana scorsa è venuto a mancare mio padre. Era un fisico teorico, per il suo contributo alla ricerca potete cercare qui:
https://en.wikipedia.org/wiki/Francesco_Guerra
Papà era molto giovane quando io ed i miei fratelli siamo nati. Abbiamo avuto il privilegio di condividere con lui tante esperienze di prima mano: i primi viaggi all'estero, le prime puntate di Star Trek... Aveva una capacità di concentrazione straordinaria, riempiva fogli e fogli di formule mentre noi nella stanza a fianco distruggevamo i soprammobili a pallonate.
Io ed i miei fratelli siamo nati sotto due Soli, uno molto caldo, quello di mia madre, uno un po' più freddo ma molto luminoso, quello di mio padre. Si sono spenti entrambi, ma ne sentiamo ancora il tepore e ne siamo illuminati.
Decollato
25 Apr 2025
Una trincea in Ucraina
Danse macabre
23 Apr 2025
Ispirato alla guerra ucraina