YoU cAn Go YoUr EnTiRe CaReEr AnD nOt UsE iT!!!
sure, this is true if:
- you don't work for / build / care about apps that have a persistence layer and serve more than about... let's say 20K daily users
- you don't care about perfomance
- you are confused
Postgres over:
- mongo: Postgres has ACID principles, where with Mongo you aren't sure you've saved ANYTHING at scale, there are multiple blog posts and humorous videos about them, i leave hunting them down to your discretion
- mySQL: don't even get me started, doesn't have any sort of plugin possibilities, is slower performance wise in literally ANY benchmark
- LiteDB: I know its the hacknews hipster rage, but seriously, you're going to rely on your entire backend via IO with a single file? ok, enjoy that one
sorry for the rant, i know it's not conducive to the hackernews mentality, but i've heard this rage and poking fun at postgres so many times, and nearly all have absolute NOTHING to with postgres' technical performance and much more to do with ego or some bullshit affiliation to some company and i'm sick of all of it and finally laying down the law:
Postgres is one of the BEST (if not THE BEST, bar none) databases currently available.
I would certainly expect the best database out there to be relatively straightforward to scale out. Posgres isn't. As a former SRE, redundancy > performance (for the differences we're talking about).
Is this true for any technology, let alone database technology? I've yet to find one.