Bala Paranj wrote in post #962528:
2. Model a parent/child relationship that can go infinitely deep.
specifically equipment, parent => child => child => child ....
Use acts as tree plugin
Hell no! acts_as_tree should be avoided at all costs. The adjacency
list model that it uses is simple, naïve, and inefficient: each level of
the tree requires a separate query (unless you're using Oracle, which
has a proprietary extension to its SQL that fixes this).
What you want instead is a *nested set* or *nested interval* structure
(do a Web search for articles on how these work). These allow retrieval
of an entire tree, to arbitrary depth, with a single query. Rails
plugins exist for both. acts_as_nested_interval was buggy last time I
used it, but has probably been fixed by now. awesome_nested_set lives
up to its name.
RoR Developer Now Available for Hire
The fact that you're recommending acts_as_tree means that people ought
to think twice about hiring you...