I tried Appwrite, Supabase, and Firebase Databases

Building real apps with their backends showed me their strengths and weaknesses.

Photo by Matthieu Beaumont on Unsplash

In the past, more and more articles were talking about why Firebase Firestore is not good and other alternatives are better. Since I had no experience, I decided to play around with the databases of Firebase, Appwrite, and Supabase and build real apps with them. After a few weeks, I now know exactly what database I would use for what use case. Here is a small summary for you.

💡 I am a Dart/Flutter developer.

For other tech stacks, the result might be different.

Firebase

Let’s start with Firebase.

Firebase Firestore is a NoSQL document database and part of the Google Firebase services. It uses a hierarchy of collections and documents to structure data and is optimized for large collections of small documents. It is not useful, or even possible, to store entire files in it.

Many features, learning curve, free tier

Firebase shines when it comes to documentation and the learning curve. You can get stuff done rather quickly, and you learn along the way. The Firestore package (all Firebase packages) is well-maintained and regularly updated by the…