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