Could I have a list of type of applications I should build on a sql database and a list of applications i should build on a nosql database?
Advertisement
Answer
There is no list and the real answer IMHO is the classic “It Depends”.
In very loose terms, financial applications where consistency is critical would be an example of something not suitable for NoSQL – in that case, ACID is crucial…..BASE would not be suitable (Basically Available Soft state Eventually consistent).
You really need to understand what NoSQL has to offer vs RDBMS, and the tradeoffs in order to know whether it is suitable for a given scenario.