Re:Ask HN: Is there a resource to help choose the right DB f...
by joshxyz on Thursday January 28, 2021 @08:29AM
(#25941486)
My cheat sheet is: For transactions, postgresql. For analytics, clickhouse. For cache, redis. For search, elasticsearch. For objects, anything s3 compatible.
Anything else, I really have to do in-depth research and comparisons because 1.) Each database has their own pros and cons, 2.) These pros and cons between dbs tend to overlap and has each of their own gotchas, and 3.) These pros and cons also improve overtime where some problems brought up earlier might be addressed already in the lastest releases.
CMU Database Group's YT channel is also worth checking out for introductions on some databases.
Anything else, I really have to do in-depth research and comparisons because 1.) Each database has their own pros and cons, 2.) These pros and cons between dbs tend to overlap and has each of their own gotchas, and 3.) These pros and cons also improve overtime where some problems brought up earlier might be addressed already in the lastest releases.
CMU Database Group's YT channel is also worth checking out for introductions on some databases.
https://m.youtube.com/channel/UCHnBsf2rH-K7pn09rb3qvkA