Given a choice, what are the factors you consider before selecting a database. How do you decide whether NoSQL is better or SQL? Which NoSQL database to select? Etc.
Please share your recent experience if possible.
just the from the top of my head. usually i tend to put user as well as financial transaction data in an SQL because consistency is important.
but it's taste :)
@chilimatic has given an appreciable abstract viewpoint. One important point I think when you are on the verge of selecting NoSQL vs SQL is to ask the question, if you have to do a lot of "transactions".
I don't know about other NoSQL databases, but from what I have come to know; the NoSQL solutions' support for transactions is squeamy at best. That is why I never feel at home when I have to deal with NoSQL thingies, they propose "entities-isolated" way of thinking.
Being an old guy, you can feel right at home with SQL, if you have to deal with a lot of transactions.
I might not have the whole picture here, so please feel free to elucidate the old guy. :)
Honestly, I think that 3 questions are not enough to choose a correct database :) This guide contains a lot of useful tips on choosing a DB.
Jan Vladimir Mostert
Idea Incubator
CAP Theorem should be the basis on which you start to make this decision: robertgreiner.com/2014/08/cap-theorem-revisited