Guide
Postgres for indie SaaS
When to use Supabase vs. raw Postgres, and the schema patterns we copy into every project.
Postgres is the default for indie SaaS. Supabase is how we usually host it.
When Supabase wins
You want auth, Postgres, storage, and edge functions in one dashboard. MVPs and early-stage products.
When raw Postgres wins
Existing infra, complex migrations, or team already on RDS/Neon with custom tooling.
Schema patterns we copy
users table mapped to auth provider id
created_at / updated_at on every table
Soft deletes only when you actually need audit trails
JSONB for flexible metadata, not as a substitute for relations
Migrations
We use Supabase migrations or Prisma depending on client preference. Both work, pick one and stick with it.
Related
- 01
AtroUI SEO Master Plan — what we shipped
Summary of the Identity Kit, JSON-LD, sitemap optimization, IndexNow integration, and OG watermarking implemented for AtroUI.
Essay · 3 min read - 02
AtroUI is now in the official shadcn registry directory. Here is why that matters for SaaS builders.
The shadcn registry directory merged @atroui. That means the production sections we use on SaaS MVPs can be installed without a custom registry URL. Lower friction, same ownership.
Essay · 7 min read
Want this built for you?
Fixed-scope MVP sprints and AI integrations. Same stack as this guide.