Re:Pgagroal: High-performance connection pool for PostgreSQL
by api on Tuesday November 23, 2021 @12:05PM
(#29320235)
CockroachDB is pretty close. I wouldn't say I'd go fully into production in one day but the failover behavior is Raft based and easy to understand. I could prototype an enterprise cluster in a few hours without descending into the arcane bowels of secret pg_incantations and "I think this is set up right but not sure if it will actually recover" clunky shit.
Do they include ACID and CAP tradeoffs similar to PostgreSQL?
Is their query language as rich and transferable as SQL?