News for hackers. Stuff that matters.
Re:Why we're ending support for MySQL by mst on Wednesday July 03, 2019 @12:28PM (#20345851)
I've always found materialized path does me proud for this sort of use case.

Also nicely easy to back-populate after you add the column using a CTE, if you didn't have it originally.

Re:Why we're ending support for MySQL by dspillett on Wednesday July 03, 2019 @12:47PM (#20346077)
Cached paths is usually pretty cheap for adding new nodes, but it can be quite expensive if you need to be able to move non-leaf nodes around (caveat: I've not looked at their use-cases here, I don't know if moving non-leaf nodes is an important matter) especially if the forest is deep rather than (or as well as) wide.