- Published on
A deep dive into PostgreSQL pagination inconsistencies and the importance of deterministic sorting in complex queries that was driving our users crazy
Sql
All Posts
- performance (14)
- nuxt-3 (10)
- typescript (8)
- vue (5)
- vercel (5)
- caching (5)
- optimization (4)
- nuxt (4)
- prisma (4)
- redis (4)
- i18n (3)
- postgresql (3)
- seo (3)
- nodejs (3)
- bundle-size (2)
- e-commerce (2)
- components (2)
- monorepo (2)
sql (2)
- swr (2)
- architecture (2)
- lighthouse (1)
- lazy-loading (1)
- search (1)
- ai (1)
- full-text-search (1)
- core-web-vitals (1)
- lcp (1)
- cls (1)
- css (1)
- svg (1)
- web-vitals (1)
- youtube (1)
- gdpr (1)
- privacy (1)
- vue-3 (1)
- generics (1)
- carousel (1)
- git (1)
- worktrees (1)
- turbo (1)
- productivity (1)
- refactoring (1)
- software-engineering (1)
- iteration (1)
- deployment (1)
- cdn (1)
- production (1)
- error-handling (1)
- prefetch (1)
- bandwidth (1)
- font-awesome (1)
- ssr (1)
- nitro (1)
- api-design (1)
- database (1)
- pagination (1)
- bundling (1)
- build-errors (1)
- frontend (1)
- compression (1)
- component (1)
- pagerank (1)
- links (1)
- turborepo (1)
- sitemap (1)
- debugging (1)
- guide (1)
- datetime (1)
- timezone (1)
- utc (1)
- javascript (1)
- Published on
Three SQL anti-patterns that were killing our search performance, and the CTE optimizations that fixed them.