Tag
Every post tagged postgresql.
Backend & APIs
I loaded the same 200,000 order documents into MongoDB 9.0 and PostgreSQL 18 JSONB and measured inserts, indexed lookups (GIN vs B-tree), containment filters, nested updates, aggregations and disk size.
Backend & APIs
I benchmarked a hand-written SKIP LOCKED queue, pg-boss 12 and BullMQ 6 on both Redis and PostgreSQL: enqueue speed, throughput, pickup latency, crash recovery, transactional enqueue and storage per job.
Backend & APIs
I scored built-in tsvector, pg_search, pg_textsearch, Elasticsearch 9.5 and Meilisearch 1.55 on three BEIR datasets: ranking quality (nDCG@10), latency, index size, typos and how fast new rows become searchable.
Backend & APIs
A walkthrough of the security layer in my NestJS 11 + Prisma 7 starter: Helmet headers, a CORS allow-list, three-window rate limiting, opt-in CSRF, header-free Pino logs and a Prisma error filter, with the real code and the gaps still to close.
AI Engineering
I loaded 100,000 OpenAI embeddings into pgvector 0.8.7 on Postgres 18 and Qdrant 1.19 and measured recall, latency, index build and filtered search, then compared Pinecone's documented limits and pricing. When you need a vector database, and when Postgres is enough.
DevOps & Self-Hosting
PostgreSQL 18 generates UUIDv7 natively. I loaded 10M rows keyed by bigint, uuidv4 and uuidv7: load time, WAL, index size and insert throughput, plus Prisma and Drizzle setup and the index trap in time-range queries.
Next.js & React
A tested Better Auth 1.7 setup for Next.js 16.4 with Prisma 7 and PostgreSQL: route handler, server-action sign-in with nextCookies, proxy.ts checks, query counts per page load, the joins gotcha and Better Auth vs Clerk.
Next.js & React
Drizzle vs Prisma, benchmarked on PostgreSQL 17 across Drizzle 0.45, Drizzle 1.0 RC, Prisma 7 and Prisma 8 RC: query speed, the OFFSET trap, cold starts, install size, migrations and which to choose.
Next.js & React
Prisma 8 is a release candidate, yet npm install prisma already installs it. What changed from Prisma 7, what is missing, a tested side-by-side migration on PostgreSQL, two gotchas the docs skip, and whether to upgrade now.
