Tag: postgresql
7 articles
· mongodb / postgresql
How to Migrate MongoDB to PostgreSQL Without Downtime
How to migrate MongoDB to PostgreSQL without downtime: dual-write strategy, TypeScript ETL, schema mapping, data validation, and 8 production gotchas.
· database / edge
Edge database tradeoffs: when latency is a lie
Edge databases cut read latency globally, but writes still go to a single primary. When D1, Turso, Neon, or PlanetScale makes sense — and when Postgres wins.
· supabase / postgresql
Supabase RLS pitfalls — what we learned in production
7 Supabase RLS pitfalls: NULL auth.uid(), service_role leaks, 171ms policies, infinite recursion, privilege escalation — with the exact SQL fix for each.
· typescript / orm
Drizzle ORM in 2026 — production opinion for TypeScript
Drizzle is production-ready for edge and serverless Postgres. Bundle ~81× smaller than Prisma, 4× throughput. The real trade-offs are in team tooling.
· typescript / orm
How to Migrate from Prisma to Drizzle ORM: Step-by-Step
Step-by-step Prisma to Drizzle migration: schema conversion, query rewrites, transaction refactoring, and eight gotchas most tutorials skip.
· postgresql / multi-tenancy
Multi-tenant Postgres patterns in 2026 — schemas vs RLS vs separate DBs
Your tenancy model locks you in before you have enough tenants to feel the pain. Schema-per-tenant degrades past 500 in plain Postgres. RLS has five known CVEs. Here's the decision map.
· clickhouse / postgresql
ClickHouse vs Postgres for analytics
If dashboard queries on 100M+ rows are hitting 8 seconds, ClickHouse is worth looking at. Here is what the benchmarks show about the actual break-even point.