Re: [sqlite] nested set tree: how to change order of one node?

2019-06-25 Thread Lifepillar
On 18 Jun 2019, at 14:19, Sam Carleton wrote: > > The tree in question contains categories, subcategories and finally image > galleries. It is common for the user to want to sort all the subordinates > of one level a different way, at times alphanumeric, other times simply to > their liking. I

Re: [sqlite] nested set tree: how to change order of one node?

2019-06-18 Thread ingo
Sam, Can't answer your question directly, maybe the closure extension is something for you. To read a bit about it: http://charlesleifer.com/blog/querying-tree-structures-in-sqlite-using-python-and-the-transitive-closure-extension/ ingo On 18-6-2019 14:19, Sam Carleton wrote: > My thought proces

[sqlite] nested set tree: how to change order of one node?

2019-06-18 Thread Sam Carleton
The tree in question contains categories, subcategories and finally image galleries. It is common for the user to want to sort all the subordinates of one level a different way, at times alphanumeric, other times simply to their liking. I have been reading through Joe Celko's Trees and Hierarchie