Re:Ask HN: What database should I use, and how should I choose?
by c4n4rd on Wednesday July 08, 2015 @02:30PM
(#9853703)
I would agree withdavismwfl "So I don't think in today's environment that you need to say one database is the end all".
If your data is relational, that is what relational DBs are for - if you hdata is text search, that is what elastic search tools are for.
The key is to identify how the data will be used.
Good luck on the project.
I use MongoDB for our core database, but we also have data in elasticsearch for text based queries and some reporting. I am right now contemplating introducing Postgres for the accounting side of our SaaS and to possibly serve some of our reporting requirements that we have found are truly highly relational.
So I don't think in today's environment that you need to say one database is the end all. However, I agree that picking one is the right choice for a new project and then adding/changing as you find the requirements that don't fit. We are micro-serviced based too so in some ways it makes it easier because we isolate which services interact with which databases, but I won't say it isn't without its own complications too.