Appwrite vs Supabase
Two open-source Backend-as-a-Service platforms. One is self-host first. One is Postgres first. Both want to kill Firebase.
Supabase
Supabase gives you real Postgres with all its power. Appwrite is great for self-hosting and has a nicer console, but Postgres wins over MariaDB for most serious applications.
The Firebase Killers
Firebase locked everyone into Google's NoSQL world. Supabase and Appwrite both said 'what if BaaS, but open source?'
Supabase chose Postgres as its foundation. Appwrite chose MariaDB. This single decision shapes everything about both platforms.
Why Supabase Wins
Postgres. That's it. That's the argument.
Okay, more specifically: row-level security, PostgREST auto-generating your API, pg_vector for AI embeddings, full SQL access, and the ability to migrate away to any Postgres host.
The real-time subscriptions work well. The auth is clean. The storage integrates with your Postgres policies. It's a cohesive platform.
Where Appwrite Shines
Appwrite's console is genuinely better. Cleaner UI, better UX for managing your backend.
Self-hosting Appwrite is easier. One Docker Compose command. Supabase self-hosting is possible but more complex (many services to orchestrate).
Appwrite Functions support more runtimes: Node, Python, Dart, Ruby, PHP, Swift. Supabase Edge Functions are Deno-only.
And Appwrite's permission system is simpler to understand than Postgres RLS policies.
Quick Comparison
| Factor | Appwrite | Supabase |
|---|---|---|
| Database | MariaDB | PostgreSQL |
| Self-hosting | Easy (Docker) | Complex (many services) |
| Console UI | Excellent | Good |
| Functions | Multi-runtime | Deno only |
| SQL Access | Limited | Full Postgres SQL |
| Real-time | WebSocket events | Postgres changes |
| AI/Embeddings | Not built-in | pgvector |
The Verdict
Use Appwrite if: You want easy self-hosting, prefer a beautiful console, need multi-runtime functions, or find Postgres RLS overwhelming.
Use Supabase if: You want Postgres power, need AI/vector features, want SQL access, or prefer the Supabase ecosystem and community.
Consider: Firebase is still valid if you're mobile-first and want the best real-time sync and offline support.
Supabase gives you real Postgres with all its power. Appwrite is great for self-hosting and has a nicer console, but Postgres wins over MariaDB for most serious applications.
Related Comparisons
Disagree? nice@nicepick.dev