Re:Using PostgreSQL as a Data Warehouse
by manigandham on Monday May 10, 2021 @07:10PM
(#27112031)
Yes, Yugabyte has been featured on Jepsen. It's basically in the class of "newsql" natively distributed relational databases.
Yugabyte uses actual Postgres code for the query parsing top layer and then translates that into to operates on it's key/value store which handles replication and distributed. CockroachDB is similar but has built everything from scratch in Go. There are similar examples like TiDB and Vitesse for MySQL as well.
Re:Using PostgreSQL as a Data Warehouse
by rad_gruchalski on Monday May 10, 2021 @07:23PM
(#27112163)
The Jepsen tests do not inspire confidence but they're also pretty aged by now. 1.3.1 under test and the most recent appears to be 2.7.0.
Cockroach is a no go for me because of the licensing restrictions. For example, password authentication only in the BSL licensed code. Backups in enterprise.
Re:Using PostgreSQL as a Data Warehouse
by jordanlewis on Monday May 10, 2021 @11:05PM
(#27113791)
Backups are available without a license in CockroachDB as of 20.2, FWIW.
https://www.cockroachlabs.com/blog/distributed-backup-restor... https://www.cockroachlabs.com/docs/v20.2/backup.html
Re:Using PostgreSQL as a Data Warehouse
by zinclozenge on Monday May 10, 2021 @06:53PM
(#27111867)
yugabyte is multi-raft i believe
Yugabyte appears to an application as essentially Postgres 11.2 with all psql features (even the row / column level security mechanisms) but, apparently, handles replication and sharding automagically (is it DHT, similar to Cassandra)?
Are there any serious technical comparisons with some conclusions, without marketing bs?