David Gardner wrote:
OK I think that would work for me.
I have another question in regards to joined table inheritance and
performance.
At work we are planning to restructure our database schema, and what we
are considering doing is
creating an adjacency list, of objects using joined
Thanks for the feedback it ended up being really helpful.
I think we are going to try a dev branch using joined table
inheritance and at least do some testing, because at this point there
are only three or four subtypes that we currently know about.
Also in our new schema the data will be more
OK I think that would work for me.
I have another question in regards to joined table inheritance and
performance.
At work we are planning to restructure our database schema, and what we
are considering doing is
creating an adjacency list, of objects using joined table inheritance.
We are
yeah. OK we only have limited support for that concept right now
using of_type(), which currently only supports one type, not a list.
so it would be
query(Company).join(Company.employees.of_type(Engineer)). In theory
of_type() could support a list, but that isnt built right now.