Re:Discovering Azure's unannounced breaking change with Cosm...
by rrdharan on Thursday October 13, 2022 @11:01PM
(#33199162)
DynamoDB or Bigtable?
Re:Discovering Azure's unannounced breaking change with Cosm...
by HorizonXP on Thursday October 13, 2022 @11:21PM
(#33199275)
We're on Azure, otherwise those were my goto choices too.
Re:Discovering Azure's unannounced breaking change with Cosm...
by noahl on Thursday October 13, 2022 @11:05PM
(#33199180)
Spanner offers that on GCP, and I believe CockroachDB offers something similar cross-cloud.
Do you have any specific requirements for which cloud provider you use, or any particular interface you really need?
Re:Discovering Azure's unannounced breaking change with Cosm...
by HorizonXP on Thursday October 13, 2022 @11:22PM
(#33199286)
Azure is our cloud provider. Interface is flexible, since our current implementation leverages Prisma ORM connected to Postgres & SQL Server. We're going to have to rebuild it anyway.
Re:Discovering Azure's unannounced breaking change with Cosm...
by skunkworker on Friday October 14, 2022 @02:26AM
(#33200237)
Vitess maybe? from what I have demoed and for being open source that’s the one I would choose. Unfortunately there isn’t a Postgres compatible one that is as mature yet and certainly not free.
Re:Discovering Azure's unannounced breaking change with Cosm...
by noahl on Friday October 14, 2022 @10:10AM
(#33203728)
Got it, thank you! CockroachDB is the only one I know offhand that does what you're looking for. Another comment mentioned Vitess, which might also work.
It seems like there are a lot of options for large scale analytics, but I don't know a lot for high throughout geo-redundant transaction processing.
Re:Discovering Azure's unannounced breaking change with Cosm...
by ayende on Friday October 14, 2022 @01:51AM
(#33200074)
RavenDB can do that
Re:Discovering Azure's unannounced breaking change with Cosm...
by robertlagrant on Friday October 14, 2022 @05:04AM
(#33201246)
What about Azure's Citus Postgres? I think it's called Hyperscale?
Re:Discovering Azure's unannounced breaking change with Cosm...
by yellowfool on Friday October 14, 2022 @11:48AM
(#33205118)
Everything Azure Event* is crap, the drivers are so buggy.
Use Confluent and connect it with a managed postgres on aws or gcp. If you really need more, use Google Cloud Spanner.
Alternatives? LOL
Basically just looking for geo-redundant, high read & write throughput. Our intention was to leverage Azure Event Grid/Kafka Connect to have event streaming used to coordinate writes between Redis (cache), Cosmos (transactional DB), and our systems of record (legacy). Majority of read/writes would occur via our API, but some would occur via the systems of record, hence the use of a log-based architecture.