6 ms·
Would love to be able to use Spanner.. What do you suggest one does if one has to run on Azure though? PS Azure Cosmos is not a real product, it is a beta toy
by dagss 4y ago
Would love to be able to use Spanner..
What do you suggest one does if one has to run on Azure though?
PS Azure Cosmos is not a real product, it is a beta toy that Microsoft just has made expensive enough that people think it cannot possibly be as bad as it is..
- avinassh 4y ago> PS Azure Cosmos is not a real product, it is a beta toy that Microsoft just has made expensive enough that people think it cannot possibly be as bad as it is.. what kind of problems you ran into with Cosmos?
- cj 4y agoIt’s supposed to be MongoDB compatible (if I’m not mistaken). Last I checked, that “compatibility” run at least a couple major version behind the real MongoDB. To be fair, the same is probably also true with AWS’s DocumentDB
- davidjfelix 4y agoI think that AWS DocumentDB uses the last mongodb version that wasn't their new(ish) SSPL license and any compatibility beyond that was "clean room" backported. Its possible Azure is in a similar place.
- CSDude 4y agoDocumentDB is a thin layer that converts the mongo commands to Postgres, uses Aurora Postgres. If you check, the constraints are exactly same. Even list RDS CLI returns the DocumentDB clusters. Most obvious indicator is DocumentDB is single node write whereas Mongo is really not, coming from Aurora Postgres.
- yawgmoth 4y agoRecently joined an Azure shop so new to Cosmos, but it's fairly abstract as a product. It seems to be a front for different database types like Mongo or Postgres or SQL Server with some additional features such as subscriptions. Would be interested to hear your challenges.
- vinay_ys 4y agoYou could consider one of these three – 1. yugabytedb (postgres compatible) 2. cockroachdb (postgres compatible) 3. tidb (mysql compatible) You could self-host these on azure or subscribe to each of their managed service offering. Of course, sticker price for managed will be more expensive than self-hosted enterprise product which itself will be more expensive than the self-hosted, community-supported, open-source option (which seems to be a real option with YugabyteDB).
- sgtfrankieboy 4y agoIt's also a real option with CockroachDB, unless you need regional sharding. Which a lot don't actually need anyways.
- rad_gruchalski 4y agoYugabyteDB tablespaces will get you there inside of their Apache 2 license.
- 411111111111111 4y agoIt always triggers me to read "postgres compatible" when they've entirely skipped features such as database triggers They've just selected a few features from postgres which they're compatible in.
- anecdotal1 4y ago[dead]
- alexvoda 4y agoI agree. I guess what they mean is you can use the existing adapter for your language. The PostgreSQL organisation should create some trademarked badges to properly label the levels of compatibility other products offer.
- rad_gruchalski 4y agoYugabyteDB supports triggers. YugabyteDB is not just „postgres compatble”, it is postgres with a distributed layer.