Davide Andreazzini

Hi there! welcome to my blog about coding, tech, photography and ideas

PostgreSQL Migrations Without the Framework Bloat
DATABASE

PostgreSQL Migrations Without the Framework Bloat

I have been running PostgreSQL migrations by hand for years and it was fine, until it wasn't. One missed ALTER TABLE on production and suddenly your app is throwing 500s at 2am. Here is how I do it now, properly. Why Migrations Matter If you are still running

davide
fail2ban: Set It and Forget It
SECURITY

fail2ban: Set It and Forget It

Every server I deploy gets brute-force attempted within hours. SSH, HTTP auth, FTP, doesn't matter. The internet is full of bots scanning entire IP ranges 24/7 and they will find you. fail2ban is the lazy dev's answer to this. It reads your logs, spots repeated

davide
iptables Firewall in 5 Rules
SECURITY

iptables Firewall in 5 Rules

I keep seeing people overcomplicate their firewall setup with fancy wrappers and GUI tools. iptables is not that hard, and understanding it directly saves you when those wrappers break ( because they always do at the worst time ). Here's how I set up iptables on every new server. The

davide
What an Italian Learned About Uruguayan Food
PHOTOGRAPHY

What an Italian Learned About Uruguayan Food

I moved to Uruguay in 2019 and one of the first things that hit me was the food. Coming from Italy, I thought I knew everything about pasta, bread and proper coffee. Then I landed in Montevideo and realised that these people take their meat even more seriously than we

davide
Why I Put All My Docker Commands in a Makefile
DEVOPS

Why I Put All My Docker Commands in a Makefile

I spend way too much time typing long docker commands. Every time I need to rebuild a container, I end up scrolling through my bash history trying to find that one command with the right flags. Last week I got tired of it and decided to move all my docker

davide
Why I Still Use Makefiles in 2026
makefile

Why I Still Use Makefiles in 2026

Every side project I've ever shipped has a Makefile. Not because I'm nostalgic or some kind of Unix purist — because after ten years of trying every alternative, Make is still the one that works without surprising me. I've used npm scripts, rake, just, task,

davide
ESC
// awaiting input_