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
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.
Generalized Inverted Indexes And You
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.