Hello world!

Welcome welcome, come on in, pull up a seat. You've found my site, a love letter to an older internet that I barely remember. Before Javascript, before everything was flooded with ads and flashy graphics, we had text.

Mostly this is where I think about Postgres. One day I'll write about something else, but for now, it's Postgres. I do have other interests, I promise.

I build sites, not quite as minimal as this one, for small businesses as well.

Get In Touch!

pg-trgm and Text Similarity Search

November 1, 2023

I asked ChatGPT what are some advanced Postgres tricks I should learn about, and one of the things that came up was pg_trgm. After a bit more reading, I'm convinced this plugin should be an essential part of any database engineers toolkit.

Read the whole thing

Generalized Inverted Indexes And You

October 12, 2023

I've been reading PostgreSQL documentation for fun lately, and I'd like to share what I've learned. Right now, that means advanced indexes and how to work with collection fields efficiently.

If you've ever worked prexisting array or JSON column and needed a complex WHERE clause for the latest feature, you might have worried about query performance. Or maybe you didn't worry about it, only to find out later that it was glacially slow.

Read the whole thing