in reply to [OT] MySQL recalibrating a sort-index

www.sitepoint.com/hierarchical-data-database/ ... This old post from another site] describes another way to do it – modified pre-order traversal trees (MPTTs). Strangely, I did not immediately identify suport for them in CPAN but they surely must be in there somewhere.
  • Comment on Re: [OT] MySQL recalibrating a sort-index

Replies are listed 'Best First'.
Re^2: [OT] MySQL recalibrating a sort-index
by LanX (Saint) on Feb 17, 2018 at 01:59 UTC
    This is slightly off-topic, since my problem is about rearranging a linear order and not necessarily connected to trees.

    Of course I knew this article already, it deals with structure which can be described as hashes of hashes.

    But my f_sort expands the model to also include arrays.

    Please note that the described downsides are rather obsolete for trees with a maximal depth, as long as you can use Self Joins and Updatable Views.

    And even a dynamic depth could be handled by redefining the view.

    Cheers Rolf
    (addicted to the Perl Programming Language and ☆☆☆☆ :)
    Wikisyntax for the Monastery