Dkam's Blog

Home
TIL
Booko

Sign in Subscribe

Nipsu

Dan Milne

15 Aug 2025

Nipsu

Enter your email

Proxying Distant HTTP Services for Latency wins

My Rails app, Booko, uses Meilisearch for text search - it's great. So easy to setup and use. Booko runs in Hetzner's Singapore location, but the Meilisearch instance is in Hetzner's Helsinki region on a physical host. They're hard to beat for

14 Sep 2025 2 min read

Migrating PostgreSQL across the planet, with almost no downtime.

TL;DR: Using PostgreSQL logical replication and Tailscale VPN, I migrated 200GB of data from California to Sydney with seconds of downtime and no time pressure. The replica synchronized over several days while production ran normally.

07 Aug 2025 7 min read

Using PostgreSQL Tablespaces on your VPS

Moving PostgreSQL indexes to the local NVMe drive from Hetzner's remote volumes boosted TPS by 86% (3,161→5,870). Using tablespaces to split storage between fast local and slower remote disks gives massive performance gains for free when your database is too big for the local drive alone.

04 Aug 2025 6 min read

Dkam's Blog © 2025

Powered by Ghost