Blog

Sql

Published on
August 10, 2025
Why Different LIMIT Values Return Different Results in PostgreSQL (And How to Fix It) 🎯
A deep dive into PostgreSQL pagination inconsistencies and the importance of deterministic sorting in complex queries that was driving our users crazy
PostgreSQL Database Pagination SQL Performance
Published on
May 5, 2025
60-80% Faster Search: Optimizing PostgreSQL CTEs in Node.js
Three SQL anti-patterns that were killing our search performance, and the CTE optimizations that fixed them.
PostgreSQL Performance SQL Node.js Prisma Optimization

Why Different LIMIT Values Return Different Results in PostgreSQL (And How to Fix It) 🎯