[Koha-bugs] [Bug 15707] Add ability to define hierarchical groups of libraries

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15707

--- Comment #170 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
I've not really been following this one too closely yet, though it is
interesting.

I agree that we need a clear inheritance model defined, and personally would
agree with the above comments.

As a further note, I see you've chosen to use Adjacency List, and you've coded
the queries yourself.  Did you investigate any of the other options for storing
hierarchies in a database.. Nested Set or Materialized Path perhaps, and did
you not consider leaning on the shoulders of giants and using one of the
DBIx::Class modules to construct the queries for you in the most optimal way
for the data you require?

It's important to consider future use cases, each hierarchical data model has
it's strengths and it's weaknesses in terms of performance and space
requirements.  In general, I think Materialized Path is the defacto recommended
way of doing hierarchies in relational databases now.

-- 
You are receiving this mail because:
You are watching all bug changes.