Choose the right database for your Application : Considerations & my Opinionated view for startups and more.

Over the last couple of years, I’ve built and dealt with applications at every scale and technical stacks — from simple CRUD metadata management Applications to apps storing and searching through data at 200k Records / Second. It’s amazing to see how much the world of databases has to offer. Some of these projects were either something that started from nothing or an existing app that needed some thought into by selecting the right database for it. For large-scale projects, we had a small requirement, but the load was huge.

Database decisions and issues are faced by every single application developer at some point in their careers. Databases form a critical component of practically every back-end system. And to add to scale and challenges, there are like hundreds of databases available these days to solve each and every one of the problems. While some databases can scale infinitely, some can provide real time synchronization. And others may guarantee consistency, availability, durability — or some of these — there are a lot of factors worth considering before a decision is made.

The motivation of this article is to share my experience over time working with various databases — focussing mostly on strategy that will help anyone quickly…