Get the latest tech news
Just use Postgres
This is one part actionable advice, one part question for the audience. Advice: When you are making a new application that requires persistent storage of data, like is the case for most web applications, your default choice should be Postgres.
The thrust of it is that databases that are in the same genre as DynamoDB- which includes Cassandra and MongoDB- are fantastic if- and this is a load bearing if: Even when maintained by a cloud provider (and there are good managed Kafka services) its another piece of infrastructure you need to monitor. I know its super unlikely that you will contribute a patch to Postgres, so I won't pretend that there is some magic "power of open source" going on, but I think you should have a very specific need in mind to choose a proprietary DB.
Or read this on Hacker News