codebind
All articles
Firebase vs Supabase vs Appwrite: why we pick Appwrite

Firebase vs Supabase vs Appwrite: why we pick Appwrite

Almost every web app needs the same foundation: user accounts, teams with roles, a database, file storage and a dashboard to manage it all. Rebuilding that from scratch for every project is a waste of time and money.

Backend platforms solve this. The three we get asked about most are Firebase, Supabase and Appwrite. Here is how they compare, and why Appwrite is our default choice.

Firebase: easy to start, hard to leave

Firebase, owned by Google, is often the first backend people try. It is quick to set up and well documented. But it comes with real trade-offs.

Vendor lock-in. Firebase is a proprietary Google service. Your data lives in Google's databases, behind Google's APIs, with Google's query model. Moving away later means rewriting large parts of your app. You cannot run Firebase on your own server.

Costs that are hard to predict. Firebase bills per read, write, download and function call. That is cheap for a prototype, but costs grow with traffic, and a single inefficient query or traffic spike can produce a surprising bill.

Built for everyone, so built for no one in particular. A closed platform has to cover every possible customer, because those customers cannot extend it themselves. The result is a large, sprawling set of products and settings, much of which a typical business app never uses.

Supabase: a powerful database toolkit

Supabase is open source and built on PostgreSQL, which is a big improvement in portability over Firebase. If your team thinks in SQL, it is a strong option.

The flip side is that Supabase gives you building blocks more than a finished foundation. Many things, such as access rules, are written as database policies in SQL. Team management with roles usually means designing your own tables and policies. That is powerful, but it is work you redo on every project, and mistakes in those policies can expose data.

Appwrite: the essentials, well rounded, out of the box

Appwrite is open source and takes a different approach: ship the features almost every app needs, make them work well together, and keep the rest out of the way.

  • Authentication with email, magic links, OAuth providers and sessions
  • Teams and roles built in. Invite members, assign roles, and set permissions per document or file without writing policy code
  • Databases with a clean data model and permissions at the collection and document level
  • Storage for files and images, with the same permission system
  • Functions for server-side logic when you need it
  • A clear console to browse data, manage users and teams, and see what is going on

This is what nearly every business app needs, and it is ready on day one. No reinventing auth and roles for each new project.

Self-host it, and stop paying per project

Because Appwrite is open source, you can run it on your own VPS. A single affordable server can host many projects:

  • Predictable cost. You pay for the server, not per read, write or user.
  • Your data stays yours, on infrastructure you control, in the region you choose.
  • No lock-in. If a hosting provider changes its prices, you move the server.
  • Unlimited projects. Spin up a new backend for each client or app without a new subscription.

Appwrite also offers a managed cloud if you would rather not run servers yourself, and you can move between the two.

Our verdict

FirebaseSupabaseAppwrite
Open sourceNoYesYes
Self-hostableNoYesYes
Teams and roles built inPartialBuild it yourselfYes
Pricing modelPay per usagePlans or self-hostSelf-host or plans
Best forQuick prototypes in Google's ecosystemSQL-heavy teamsBusiness apps that need auth, teams and data fast

For the business apps we build, such as CRMs, client portals and internal tools, Appwrite gives us the most solid foundation with the least custom code. That means faster delivery and lower costs for you, and a backend you actually own.

Build your app on a foundation you own

Want a custom app without monthly SaaS fees or vendor lock-in? Use Start Project on our homepage and tell us what you need.