4 ms·
There’s no need for consolidation when Postgres already exists.
by sail0rm00n 5y ago
There’s no need for consolidation when Postgres already exists.
- speedgoose 5y agoSometimes I dream about a highly available multi primary postgresql.
- cultofmetatron 5y agoyea, some sort of vitessdb equivalent to postgresql would be amazing!
- supergirl 5y agothere used to be citus but now it's part of microsoft Azure
- mslot 5y agoTrue, it is developed by Microsoft and available as a service on Azure. It is also open source, actively maintained and improved, and it's a PG13-compatible Postgres extension that adds both distributed database capabilities and columnar storage. :) https://github.com/citusdata/citus https://github.com/citusdata/citus (Citus engineer)
- jhgb 5y ago> PG13-compatible So not (IBM-System-)R-compatible, then?
- DaiPlusPlus 5y agoCockroachDB?
- speedgoose 5y agoPerhaps. It's missing the 30 years of experience, the PostGreSQL reputation, an opensource license, and a better name.
- qaq 5y agoYugobyteDB ?
- DaiPlusPlus 5y ago> a better name NGL, I've had to explain to enough people by now that the "funny name" is because it was made by ex-Googlers with a view towards resiliency, as per the idiom that only cockroaches will survive global nuclear war.
- bob1029 5y agoDo you also dream of loss of certain ACID semantics or crippling performance issues? In the real world, it is extremely hard to provide all the same guarantees you get out of a single instance of <database vendor> if you turn around and spread it across the internet. If you have super deep control over the physical & temporal environment around your system, you can cheat the rules a little bit (i.e. Google).
- speedgoose 5y agoYes I know that the perfect database cannot exist. I think some trade-off are possible though. Today I use postgresql with a primary and replicas, together with couchdb in the same application. They complement each other, but I think something good between is possible.
- rad_gruchalski 5y agoI would recommend having a look at Yugabyte.
- zinclozenge 5y agoWhy yugabyte over cockroachdb?
- rad_gruchalski 5y agoLicensing. CockroachDB does not allow as-a-service.
- zinclozenge 5y agoYugabyte does allow it though? I could take it and create my own company based around providing yugabyte as a service?
- rad_gruchalski 5y agoYes. The core database is fully Apache 2 licensed with no strings attached: https://docs.yugabyte.com/latest/legal/ https://docs.yugabyte.com/latest/legal/. Maybe it will change if the company behind feels they're ripped off. Who knows, but for now, yes, you could. CockroachDB has an explicit clause is the licensing: Yes, employees and contractors can use your internal CockroachDB instance as a service, but no people outside of your organization will be able to use it without purchasing a license: https://www.cockroachlabs.com/docs/v21.1/licensing-faqs.html#can-i-host-cockroachdb-as-a-service-for-internal-use-at-my-organization https://www.cockroachlabs.com/docs/v21.1/licensing-faqs.html....
- speedgoose 5y agoThanks. I should try it out.
- qaq 5y agowell some use cases need something that is distributed like PolarDB, YugobyteDB, CockroachDB etc.