At my last company, we had a great experience using postgresql flavored Aurora, especially because we could use recursive CTEs to do deep traversal of graphs.
Since CockroachDB is SQL, what would be the benefit over using Aurora?
Since CockroachDB is SQL, what would be the benefit over using Aurora?
You can see some details about how this affects write perf in this blog by another distributed SQL database which compares the three databases (YugabyteDB, Aurora and CockroachDB) - https://blog.yugabyte.com/comparing-distributed-sql-performa...
[1] There is also multi-master Aurora (but based on https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide... that only supports 2 read-write masters and has other limitations).