When a CTE makes a Postgres query faster
What a WITH clause changes in the plan, measured on 2 million rows, and how to write the same queries in Rails.
Programming
60 posts
A local MCP server for project knowledge
PRDs, ADRs, the design system, agent profiles and the code, indexed in LanceDB on my laptop and searchable from any MCP client.
Rebuilding my blog from the Wayback Machine
How I got 101 posts back out of the Internet Archive and into a fresh WordPress install.
.env.example is untyped text
So I wrote dottyenv, a small CLI that checks your .env against a schema and tells you where to get what is missing.
Scanning for env vars without a language table
Every language reads the environment with the substring env. That turned out to be enough.
Shipping a Rust CLI to Homebrew, Debian and RHEL
How dottyenv gets from a git tag to a binary that runs on RHEL 8, and how CI proves it.
My Commonly Used Gems
These are frequently used gems. Almost every project I start or work on use these: pagy pg redis annotate faker pry-rails name_of_person whenever friendly_id inline_svg bootstrap / tailwind...
Hello Ruby 3.0 and Rails 6.1
I love when the tools I use are updated.
Baby Name Rails App: Part 1 Import Data
I guess this is my how-to build a rails app from scratch. Using Rails 6.0.3.3, ElasticSearch (Searchkick), Sidekiq, Redis, PostgreSQL to build an app to utilize the data....
Docker: apt-get cleanup
If you install things with apt-get remember to clean it up afterwards This would be a better way: