4 ms·
There's also CockroachDB, which is wire-compatible with Postgres. Of course, there are also some performance trade-offs to consider, and it is currently missing
by Zikes 9y ago
There's also CockroachDB, which is wire-compatible with Postgres. Of course, there are also some performance trade-offs to consider, and it is currently missing many SQL and data type features available in Postgres and others.
- the_duke 9y agoIt's a completely different database, it just happens to support the postgres binary protocol.
- Zikes 9y agoYes, it is. However when I went looking for a "HA Postgres" solution I found it to be a viable alternative for my use case.
- dianasaur323 9y agoCockroachDB employee here - Yes, CockroachDB is a completely different database from PostgreSQL. CockroachDB supports HA from the bottom up with data broken up into ranges that are consistently replicated using Raft. As mentioned earlier in the thread, it uses the PostgreSQL wire protocol and supports a good amount of SQL (but not all since the dialect is quite large if you include extensions). If you are looking for HA with SQL compatibility, it would be worth taking a look at CockroachDB.
- anarazel 9y agos/binary/wire/