April 22, 2025
Building a Complex Real-Time Search Engine: PostgreSQL vs. Elasticsearch
PostgreSQL or Elasticsearch? I built a solid SQL-based search engine, but as complexity grows, I'm at a crossroads: keep pushing PG, or bring in Elasticsearch. This post is a behind-the-scenes look at my thought process, what real-time search really means, the tradeoffs I'm facing, and how I plan to move forward.
Read more
June 14, 2022
How to write a recursive SQL query
Let's see how to write a recursive SQL query with PostgreSQL's CTE (Common Table Expressions) and ActiveRecord
Read more
October 25, 2021
How to have UUID primary keys with PostgreSQL
Step-by-step tutorial on how to enable and use UUID primary keys in your Rails application
Read more