Choosing the Right Database for Your Flutter App

Photo by Campaign Creators on Unsplash

This article was originally published here on the Codemagic blog

There are a lot of options out there today when it comes to databases in your application. They typically fit into these three categories:

• Relational — these are the databases in the traditional sense. They don’t just store data but also the relationships between the data. SQLite is an example of a relational database.
• NoSQL — these databases store data as documents. A schema is not enforced as is the case with a relational database. They are lightning-quick and handle huge unstructured pieces of data very well. MongoDB is an example of a NoSQL database.
• Individually tailored data storage — while this option is not technically a database, you don’t have to use the above solutions. You can store your data in a JSON file and handle the serialisation and deserialisation yourself. This would be incredibly fast but would open you up to some weird bugs if you weren’t a programming genius. 🤓

By the end of this article, you will know:

• The basics of how each database works. 📰
• How to get set up with each database. ⚙
• What a good use case would be for each database. 📳