Nathan Milford of Outbrain answering the question how do you decide what database to use for what task:
We look at how the data will be queried, its size, and how it needs
to be distributed. We might use things like MySQL for historical reasons and
MongoDB for smaller tasks, and then Cassandra for situations where data
doesn’t all fit into memory or where it spans multiple machines and possibly
This is indeed the good recipe: data access model, data size, distribution model.
Original title and link: How do you decide what database to use for what task? ( ©myNoSQL)