Long-form writing on Postgres,
Supabase, and AI-assisted ops.
Practical, opinionated articles by the same team that builds Suparbase. We write about what we ship and what we see in production.
- 11 min
Your AI agent will eventually delete your database. Here's the seat-belt.
Three 2026 post-mortems show the same shape: an AI agent leaked PII or deleted prod, and existing tooling caught it weekly. Agent Sentry is the always-on probe + one-click undo for vibe-coded Supabase projects.
- vibe-coding
- supabase
- rls
- ai-safety
- 14 min
The AI-Assisted Database Admin in 2026: What Actually Works
Two years into LLM-assisted database operations, here's what we've learned shipping AI features in admin tools: tool-use beats text-to-SQL, schema-aware agents, confirm-then-execute writes, and the failure modes.
- ai
- postgres
- supabase
- tooling
- 13 min
JSONB vs Tables: A Decision Framework for Postgres Schema Design
When to use Postgres' JSONB column vs columns vs a separate table. A 2026 decision framework with concrete queries, indexing implications, and the bug patterns of each.
- postgres
- schema
- jsonb
- 14 min
Connection Pooling for Modern Postgres: pgBouncer, Supavisor, PgCat
The 2026 state of Postgres connection pooling for serverless and traditional servers: pool modes, when transaction-mode breaks, prepared statements, and which pooler to pick.
- postgres
- pooling
- operations
- serverless
- 13 min
Which Database for a Vibe-Coded Project in 2026?
A practical decision guide for picking a database when an AI agent is writing most of your code. Covers Postgres, Supabase, Neon, Turso, MongoDB, PlanetScale, and Convex, with the trade-offs that actually matter in 2026.
- vibe-coding
- databases
- decision-guide
- 13 min
MongoDB vs Postgres in 2026: Honest Comparison
After a decade of partisan takes, here's an honest 2026 comparison of MongoDB and Postgres. Where each one wins, where each one loses, and the workloads we'd genuinely pick MongoDB for.
- mongodb
- postgres
- databases
- 11 min
Best AI-Friendly Database in 2026: What Makes a DB Easy for Agents
Not all databases are equally easy for an AI agent to operate. Here's the 2026 ranking by AI-friendliness, with the four properties that decide whether your agent ships or stalls.
- ai
- databases
- vibe-coding
- 14 min
Vector Databases Ranked for 2026: pgvector, Pinecone, Qdrant, Weaviate, and the Rest
An honest 2026 ranking of vector databases: pgvector, Pinecone, Qdrant, Weaviate, Chroma, Milvus, LanceDB. Where each one wins, what's overhyped, and what we'd actually pick.
- vector
- rag
- ai
- databases
- 12 min
SQLite at the Edge in 2026: Turso, libSQL, D1, and the Renaissance
Why SQLite is suddenly winning workloads that used to belong to Postgres. Turso, libSQL, Cloudflare D1 explained, when to pick each, and the limits to know about.
- sqlite
- turso
- edge
- databases
- 13 min
Vibe-Coding with a Database: 10 Patterns That Don't Break
Ten concrete patterns for keeping AI-paired database work clean: typed schemas, migration discipline, RLS-as-authz, write-confirmation gates, and the anti-patterns to avoid.
- vibe-coding
- patterns
- databases
- ai
- 10 min
Why Supabase is the AI Agent's Favorite Postgres in 2026
Schema introspection in one HTTP call, RLS as the authorization primitive, JWT-based claims your agent can simulate. Why Supabase ended up perfectly aligned with the AI-paired era.
- supabase
- ai
- postgres
- 12 min
Edge Databases Compared in 2026: Turso vs Cloudflare D1 vs Neon
Three takes on "database at the edge" in 2026. Turso's SQLite-per-user, Cloudflare D1's Workers-native SQLite, and Neon's branched Postgres. When each one wins.
- edge
- neon
- turso
- cloudflare
- 11 min
AI Code Review for Database PRs in 2026
How to use an AI reviewer to catch the migration, RLS, and N+1 bugs your eyes miss. Practical patterns for AI-augmented code review on Postgres / Supabase PRs.
- ai
- code-review
- postgres
- ci
- 12 min
The Cursor + Supabase Stack in 2026
End-to-end setup for the AI-paired stack that ships the fastest in 2026: Cursor for the editor, Supabase for the database, Drizzle for types, MCP servers for schema access.
- cursor
- supabase
- vibe-coding
- 10 min
When AI Agents Shouldn't Touch Your Database
Vibe coding is great. There's a short list of operations where the human still needs to be in the loop. Here's the list, why each one, and the controls to enforce it.
- ai
- vibe-coding
- safety
- databases
- 11 min
Type-Safe Database Access for AI-Paired Codebases
Why type-safety isn't optional when an AI writes most of your code. Drizzle vs Prisma vs Kysely vs sqlc compared for the AI-paired workflow.
- typescript
- drizzle
- prisma
- ai
- 10 min
Capping the Cost of AI-Generated Database Code
AI-paired teams can rack up surprising database bills: bad queries, runaway loops, expensive review pipelines. Here's how to put guardrails in place without slowing the team down.
- ai
- cost-control
- postgres
- operations
- 12 min
Reading Postgres EXPLAIN ANALYZE: The 2026 Guide
A field guide to Postgres EXPLAIN ANALYZE in 2026. The operators that matter, the numbers to look at, and the four patterns that explain 90% of slow queries.
- postgres
- performance
- explain
- 13 min
Postgres Indexes Explained, Visually: btree, GIN, BRIN, GiST, Hash
Every Postgres index type, what it does, when to use it. A 2026 visual guide with concrete examples and the surprising performance numbers.
- postgres
- indexes
- performance
- 11 min
MVCC in Postgres: When It Bites You
Postgres uses MVCC for concurrency. Most of the time you don't think about it. Then you do. Here are the four ways MVCC bites in production, and how to handle each.
- postgres
- mvcc
- performance
- 11 min
Postgres Full-Text Search in 2026: Still Worth It?
Postgres full-text search has been around forever. In a 2026 world of pgvector and external search engines, when does it still make sense? Benchmarks and trade-offs.
- postgres
- search
- fts
- 12 min
Postgres Partitioning at Scale
Declarative partitioning landed years ago; in 2026 it's the boring-and-correct answer for tables past 100M rows. The patterns that work, the gotchas, and when to skip it.
- postgres
- partitioning
- scale
- 11 min
Database Backups That Actually Work in 2026
Point-in-time recovery vs logical dumps vs storage snapshots. What each one buys you, what they don't, and the restore drills that prove they work.
- postgres
- backups
- operations
- disaster-recovery
- 11 min
The Modern Postgres Observability Stack in 2026
The metrics that actually matter, the tools that work in 2026, and the alerts to set up before your database becomes someone else's problem.
- postgres
- observability
- operations
- 12 min
PostgREST vs GraphQL vs tRPC in 2026
Three flavors of 'API on top of your database' and how to pick. Honest 2026 comparison of PostgREST, GraphQL, and tRPC, with the AI-paired angle baked in.
- api
- postgrest
- graphql
- trpc
- 12 min
Event-Driven Architecture on Postgres in 2026
You don't need Kafka. Postgres ships LISTEN/NOTIFY, logical replication, and the outbox pattern. The 2026 guide to event-driven on the database you already have.
- postgres
- events
- architecture
- 16 min
Zero-Downtime Postgres Migrations: Patterns That Actually Work
Add columns, drop columns, rename, change types, and re-shape big tables without a maintenance window. Production-tested Postgres migration patterns for 2026, with the locks each one takes.
- postgres
- migrations
- operations
- 18 min
pgvector and Postgres for RAG: A 2026 Production Setup
How to build a production RAG pipeline on Postgres with pgvector in 2026: HNSW indexes, embedding hygiene, chunking strategies, hybrid search, and the failure modes that bite teams in production.
- postgres
- pgvector
- rag
- ai
- 17 min
Building Multi-Tenant SaaS on Postgres: Schemas, RLS, and Pooling
Three battle-tested patterns for multi-tenancy on Postgres (and Supabase) in 2026: shared table with tenant_id, schema-per-tenant, and database-per-tenant. With migration, RLS, and pooling trade-offs.
- postgres
- multi-tenant
- saas
- supabase
- 16 min
Supabase vs Self-Hosted Postgres: When to Choose Which in 2026
A 2026 comparison of managed Supabase, Supabase self-hosted, and rolling your own Postgres. Picks where each wins, where they break, and the migration paths between them.
- postgres
- supabase
- architecture
- 14 min
Row-Level Security in Postgres: A Practical Guide for 2026
How to design, debug, and ship Postgres Row-Level Security policies in 2026. Covers Supabase patterns, JWT claims, policy testing, and the bugs that bite teams in production.
- postgres
- rls
- supabase
- security
We publish on average two long-form articles per month. Subscribe via your favourite RSS reader at https://suparbase.com/rss.xml (coming Q3 2026).