3 ms·
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.postgresq
by munk-a 9y ago
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.html https://www.postgresql.org/docs/current/static/queries-with.... and some rather amazing JSON support https://www.postgresql.org/docs/current/static/functions-aggregate.html https://www.postgresql.org/docs/current/static/functions-agg...
- derekperkins 9y agoJSON 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-mysql-80.html https://www.infoworld.com/article/3228154/sql/whats-new-in-m...
- takeda 9y agoThis 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.