←back to thread

Show HN: Open source, logical multi-master PostgreSQL replication

(github.com)
131 points pgedge_postgres | 7 comments | 09 Oct 25 22:53 UTC | HN request time: 1.136s | source | bottom
1. foreigner ◴[10 Oct 25 07:20 UTC] No.45536174[source]▶
What are the pros and cons of this compared to CockroachDB?
replies(3): >>45536200 #>>45536648 #>>45538518 #
2. snthpy ◴[10 Oct 25 07:26 UTC] No.45536200[source]▶
Not the OP nor knowledgeable in this area but I would suspect / hope postgres compatibility as a start. The last time I looked into whether I could use cockroachdb as a backend for my Airflow cluster, it wasn't possible due to compatibility issues.
replies(1): >>45536869 #
3. znpy ◴[10 Oct 25 08:51 UTC] No.45536648[source]▶
License. CockroachDB moved to a license that I can’t even remember if it’s source-available anymore.
replies(1): >>45536932 #
4. pgedge_postgres ◴[10 Oct 25 09:27 UTC] No.45536869[source]▶
You're actually 100% correct! CockroachDB is only 57.25% compatible with standard PostgreSQL (according to https://pgscorecard.com, which details the way it comes up with these numbers) whereas we are 100% compatible (and 100% open-source, whereas they are source-available).
5. pgedge_postgres ◴[10 Oct 25 09:37 UTC] No.45536932[source]▶
It technically is source-available, as of Nov 2024, anyway: https://news.itsfoss.com/cockcroachdb-no-open-source/

So yes, license (and compatibility - see https://pgscorecard.com) are two major differences between pgEdge and CockroachDB.

pgEdge version updates also come in very close alignment with upstream PostgreSQL intentionally to make sure security patches/bugfixes and the latest features get to users ASAP.

6. traceroute66 ◴[10 Oct 25 13:01 UTC] No.45538518[source]▶
> compared to CockroachDB

CockroachDB != PostgreSQL.

I take great issue with the way CockroachDB marketing seeks to imply compatability, when infact what they are promising is wire protocol compatability (i.e. you can fire up your copy of psql on the CLI and it will connect).

Last time I looked, a great number of primitive, obvious, fundamental, low-hanging fruit were completely absent from CockroachDB, e.g. (IIRC) stored procedures are nowhere to be seen in CockroachDB.

replies(1): >>45540411 #
7. bonesmoses ◴[10 Oct 25 15:58 UTC] No.45540411[source]▶
You can't even run pgbench unaltered on CockroachDB, as simple table structures and indexes are fundamentally different there. It is in no way a compatible product, and never has been.