Published onAugust 10, 2025Why Different LIMIT Values Return Different Results in PostgreSQL (And How to Fix It) 🎯PostgreSQLDatabasePaginationSQLPerformanceA deep dive into PostgreSQL pagination inconsistencies and the importance of deterministic sorting in complex queries that was driving our users crazy
Published onJuly 21, 2025Building a Search Bar That Feels Like AI: The Technical Deep DivePostgreSQLSearchAIE-commerceFull-text-SearchTypeScriptPerformanceHow 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
Published onMay 5, 202560-80% Faster Search: Optimizing PostgreSQL CTEs in Node.jsPostgreSQLPerformanceSQLNode.jsPrismaOptimizationThree SQL anti-patterns that were killing our search performance, and the CTE optimizations that fixed them.