Postgres is not best in class in many things it does well but it suits the needs most people will actually encounter in the wild while being built on a rock sol

Postgres is not best in class in many things it does well but it suits the needs most people will actually encounter in the wild while being built on a rock solid foundation. It truly is a fantastic hammer for every nail involving data integrity or synchronization. It's well designed so that when you do venture into territory where you need a specialized solution it's not difficult to replace. But you'll definitely miss ACID and relational data if you're leveraging them. There is a great operational economy to making Postgres your default solution for these sorts of problems.