Postgres, auth, and storage as a platform you can host.
- Stars
- 115,184
- Updated
- License
- Apache-2.0
- Hosting
- Both
- Category
- Databases
Supabase has the most GitHub stars in this list (115k, Apache-2.0). Supabase, PocketBase, and Appwrite can be self-hosted. Supabase and Appwrite list a hosted option.
Compare the setPostgres, auth, and storage as a platform you can host.
A single-file backend with a database and admin.
Auth, database, and storage APIs for applications.
Evaluate Supabase when you want a Postgres foundation, Appwrite when you want application services behind its APIs, and PocketBase for a compact backend with an embedded database. Choose around your data model, access rules and operating capacity, then prototype one real workflow.
Editorial guide reviewed October 7, 2026. Based on project documentation, not hands-on benchmarks. Catalog metadata last checked November 20, 2026.
| Alternative | Consider it for | Check before choosing | License / hosting |
|---|---|---|---|
| Supabase | Postgres with application services Combines a relational database with services including authentication and storage. Its self-hosting guide documents the platform components. | Firestore documents and security rules do not become SQL tables and access policies automatically. Self-hosting also makes your team responsible for the services it runs. | Apache-2.0 Both Official source for Supabase (opens in a new tab) |
| Appwrite | Backend services through application APIs Offers a self-hosting path for applications using its backend APIs, rather than asking you to assemble every service yourself. | Verify each Firebase dependency against the Appwrite service you would use. Client calls, permissions and function deployment need an application migration. | BSD-3-Clause Both Official source for Appwrite (opens in a new tab) |
Selection is by workflow fit, not sponsorship or star count. Licenses and paid features can differ by edition; check the linked source for the version you plan to use.
Documented capabilities and migration checks. Confirm the version and edition you plan to run.
| What to compare | Supabase | Appwrite |
|---|---|---|
| Data model | Postgres tables and SQL. Map Firestore documents, nested collections and references into a relational schema. Official source for Supabase: Data model (opens in a new tab) | Data behind Appwrite APIs. Check the database APIs available in your self-hosted version; hosted documentation can describe newer services. Official source for Appwrite: Data model (opens in a new tab) |
| Sign-in | Auth supports passwords, passwordless sign-in and identity providers. Map account identifiers and reconfigure provider callbacks. Official source for Supabase: Sign-in (opens in a new tab) | Auth supports email/password, OAuth and passwordless flows. Test the methods your application uses on the version you deploy. Official source for Appwrite: Sign-in (opens in a new tab) |
| Files | Storage uses buckets with access policies. Copy file bytes as well as metadata, then test private downloads. Official source for Supabase: Files (opens in a new tab) | Storage provides file APIs and buckets. Rebuild upload/download calls and file permissions. Official source for Appwrite: Files (opens in a new tab) |
| Live updates | Realtime includes Broadcast, Presence and Postgres Changes. Replace listeners deliberately; test reconnects and access control. Official source for Supabase: Live updates (opens in a new tab) | Realtime subscriptions deliver resource events over WebSockets and respect permissions. Rewrite Firebase listener subscriptions. Official source for Appwrite: Live updates (opens in a new tab) |
| Access rules | Postgres grants and row-level security control table access. Translate Firebase rules and test both permitted and denied requests. Official source for Supabase: Access rules (opens in a new tab) | Permissions identify users and teams allowed to access resources. Verify permissions with normal client sessions, not only an administrator. Official source for Appwrite: Access rules (opens in a new tab) |
| Operating the backend | Run and maintain the platform services, database, backups and monitoring. Managed-platform features are not all included in self-hosting. Official source for Supabase: Operating the backend (opens in a new tab) | Operate a self-hosted deployment and its dependencies. Check release compatibility, capacity and backup procedures before cutover. Official source for Appwrite: Operating the backend (opens in a new tab) |
Use this proposed acceptance test with synthetic data in an isolated test environment. It is a migration plan, not a benchmark we have run against these products.
Repository activity is a signal, not a security or quality guarantee.