DEV Community

Discussion on: What database should I use?

Collapse
 
andreidascalu profile image
Andrei Dascalu

Well, as a general direction, you have SQL, noSql and blends.
SQL: you have mySql (though Mariadb as a drop-in MySQL replacement is significantly better and provides noSql models as well as climb stores) and postgresql as main options. I generally go with Mariadb because I know it better and how to optimize it. Don't disregard online sources.

NoSql: for all intents and purposes Mongo is ahead.

Column store: I strongly recommend Clickhouse as a high performance column store with SQL compatible syntax.