News for hackers. Stuff that matters.
Re:MongoDB gets support for multi-document ACID transactions by mcintyre1994 on Thursday February 15, 2018 @10:26AM (#16384743)
This is basically what Microsoft's Cosmos DB is, you store JSON documents, don't have to define a schema and you can query them with SQL.
Re:MongoDB gets support for multi-document ACID transactions by malloryerik on Thursday February 15, 2018 @11:45AM (#16385436)
And you can also bake in graph relations, right? How has your experience been with CosmosDB?
Re:MongoDB gets support for multi-document ACID transactions by mcintyre1994 on Thursday February 15, 2018 @12:14PM (#16385688)
To be honest I've only used it for pretty trivial things, I didn't do any joins. From the docs [0] it looks like they only have self joins, so joining on children or something like that but not across documents/collections.

Depending how much graph relation stuff you need you might be better off just using the graph API. I have no experience with that though. Or they support a MongoDB API if that covers your needs too.

Like I said I've only done basic stuff, but I really liked it - it's performant and really easy to set up and use. I used the Python API and it was really easy, then I switched to the Node one to try using it in Azure functions (Python library imports aren't really supported there) and that's nice too - it uses promises and works great. It also doesn't feel like a giant lockin (IMO) - their APIs work anywhere and there's no magic in Azure AFAIK to make you put your compute there if you're using the Database.

[0] https://docs.microsoft.com/en-us/azure/cosmos-db/sql-api-sql...