PostgreSQL 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.
Development When an esoteric bug gives you a crisis of confidence. I'm building a little toy / passion project app for saving bookmarks and archiving what they link to. It's Ruby on Rails, with TailwindCSS and Phlex components. It's very vanilla Rails. When I built a cross platform image for it on my ARM64 Mac, and
Development Vibe coding MCP servers "Model Context Protocol" - it's the hot new thing. It provides a standard interface for LLMs like Claude and ChatGPT to use other software on the internet. I recently hooked Claude Code into my self-hosted Gitea service via the Gitea-MCP. This means that, right within my
SQLite SQLite on Rails Ruby's SQLite library and Rails SQLite adaptor have improved their capabilities and performance massively recently. It's now perfectly reasonable to use SQLite in a production application. I presented at Ruby Australia's Melbourne meetup on these improvements and why you should take a close look
SQLite Hybrid Databases in Rails: Using SQLite Alongside PostgreSQL My Rails site Booko has several ancillary services which support it. There's the Cover Art system which downloads and resizes book cover art. CSV-to-API service which downloads CSV files of book prices and turns them into an API for Booko to use. The latest of these, which I&
Talks Semantic Searching with RAG and Ruby Hey! I did a talk at Ruby Australia on how to build a Semantic Search system using Ruby. I really enjoyed building this little demonstration toy. I first got a glimpse of how they work with Simon Willison's excellent video "Embeddings: What they are and why they