Home

A simple place for my collected thoughts and notes.

Welcome! I'm Sam Stelfox, a security engineer and operations leader with a long-standing habit of taking things apart to see how they work. The best of my time belongs to my wife Hannah, our daughter Zelda, and our pup Cookie, with whatever is left going to tinkering with compilers, knowledge graphs, genetic algorithms, and whatever else catches my attention.

I use this site to keep notes on things I'm digging into, write the occasional blog post, and track whatever projects I'm tinkering with. If you want to know more, there's an about page with contact info.

The Postgres Migration

2026-04-24 Sam Stelfox 7 min read

This is the biggest structural change Hive has gone through since I forked it. 723 files changed, 90,471 insertions, 132,463 deletions against upstream main at the fork point. SQLite is gone. PostgreSQL with pgvector is the only storage backend now and there's no migration path from the old data. That sounds dramatic but it was the right call. The previous setup had Arc<Mutex<Connection>> contention, spawn_blocking wrappers everywhere because rusqlite isn't async, and client-side cosine similarity computation that should have been happening in the database all along.

2026-04-24 The Postgres Migration hive project rust security architecture
2026-04-08 API Security Hardening hive project security rust api authentication
2026-04-08 A Third Fork hive project ai agents open-source community
2026-04-04 Why Build Another Agent Harness hive project ai agents rust philosophy
2024-07-26 Secure Boot on Older and Unstable Motherboards hardware linux secure-boot security
2023-05-10 Podman Socket Compatibility for Docker Tools docker linux podman
2023-04-13 Combining "Subscribers" in Rust's Tracing Library rust programming tracing
2020-02-23 Logical Volume in Use linux lvm
2020-02-18 Extracting Dracut Built initramfs linux
2019-11-27 Blender Loop Select in Cinnamon blender linux tips