Our Redis cache kept dropping TLS connections, taking down the entire caching layer. After a misleading benchmark nearly sent us in the wrong direction, we migrated to PostgreSQL — same performance, zero drops, one less service to manage.
A deep dive into PostgreSQL pagination inconsistencies and the importance of deterministic sorting in complex queries that was driving our users crazy
How we built a sophisticated multi-layered search system that understands user intent, handles typos, and delivers relevant results across 9 languages using PostgreSQL, TypeScript, and smart algorithms
Three SQL anti-patterns that were killing our search performance, and the CTE optimizations that fixed them.