Re:MongoDB gets support for multi-document ACID transactions
by munk-a on Thursday February 15, 2018 @01:42PM
(#16386411)
Yes, come over to the actually greener lawn of Postgres, it is amazing how much more powerful than MySQL it has become with recursive CTEs https://www.postgresql.org/docs/current/static/queries-with.... and some rather amazing JSON support https://www.postgresql.org/docs/current/static/functions-agg...
[ Parent
| on HN ]
Re:MongoDB gets support for multi-document ACID transactions
by derekperkins on Thursday February 15, 2018 @02:46PM
(#16386913)
JSON has been great in MySQL for a few years now since 5.7, and recursive CTEs are coming in the next couple months with 8.0. I don't think you can make a wrong choice between the two these days, but choosing Mongo over either is almost always the wrong decision.
https://www.infoworld.com/article/3228154/sql/whats-new-in-m...
Re:MongoDB gets support for multi-document ACID transactions
by takeda on Friday February 16, 2018 @03:01AM
(#16390714)
This is actually what I think the biggest power of JSONB is.
I can for example use jsonb_agg() and get a hierarchical response for 1:N joins. It returns JSON value even though neither of the columns contain JSON.
Previously in that scenario I would either need to make more than one query or get a response that has a lot of data repeated.