News for hackers. Stuff that matters.
Re:MongoDB gets support for multi-document ACID transactions by Waterluvian on Thursday February 15, 2018 @10:21AM (#16384684)
That's what I was wondering too. It feels like SQL and NoSQL will meet in the middle: JSON with SQL support, SQL with JSON support.
Re:MongoDB gets support for multi-document ACID transactions by egeozcan on Thursday February 15, 2018 @10:26AM (#16384747)
"Mongres is a PostgreSQL extension that runs a custom background worker speaks mongo wire protocol."

https://github.com/umitanuki/mongres

Re:MongoDB gets support for multi-document ACID transactions by btown on Thursday February 15, 2018 @10:57AM (#16384988)
There's also https://www.torodb.com/stampede/docs/1.0.0-beta3/relational-... which tails the Mongo oplog and makes a fully-relational read replica, adding columns and indices as needed. An amazing (and free) shortcut to using analytics tools if Mongo's your main datasource.
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...

Re:MongoDB gets support for multi-document ACID transactions by overcast on Thursday February 15, 2018 @10:25AM (#16384726)
Which is why I'm depressed RethinkDB failed to take off :(