I don't know if it makes any difference, but I actually first attempt at using the recursive select stuff to build my tree plugin in the "sequel_plus" gem, but found right off the bat that not all DBMS supports such fancy syntax, so I fell back to a safer implementation.
Also, I started reading that linked article, but didn't get too far into it before getting distracted by real work and deadlines, so we may be talking about two different things with regards to trees and adjacency plugins... Michael On Fri, Mar 19, 2010 at 3:39 PM, Scott LaBounty <[email protected]> wrote: > Since you asked for "feelings" and not rationale, I'm going to go with > "shipped with". > > Scott > > > On Fri, Mar 19, 2010 at 11:21 AM, Jeremy Evans <[email protected]>wrote: > >> I've been working on a plugin for Sequel that uses recursive common >> table expressions to implement eager loading of tree like structures >> in an SQL database. It's available at http://pastie.org/877511.txt, >> and based on earlier work shown in the Advanced Associations RDoc >> page. It's inspired by comparisons of the adjacency list model to the >> nested set model at Explain Extended (see >> >> http://explainextended.com/2009/09/24/adjacency-list-vs-nested-sets-postgresql/ >> ). >> It allows the lazy and eager loading of all ancestors and descendants, >> as well as the eager loading of all descendants to a given level, >> along with caching the necessary parent-child relationships so >> iterating over the tree structure after eager loading causes no >> database access. >> >> I'm posting this to the list for early comment as to whether people >> think this plugin should be shipped with Sequel, or whether it should >> be an external plugin (available as a separate gem, similar to >> sequel_validation_helpers_block). If you have feelings either way, >> please post here. >> >> Thanks, >> Jeremy >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sequel-talk" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<sequel-talk%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/sequel-talk?hl=en. >> >> > > > -- > Scott > http://steamcode.blogspot.com/ > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<sequel-talk%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/sequel-talk?hl=en. > -- http://codeconnoisseur.org -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
