Re: [SQLObject] Managing hierarchical data

[Mark <mar...@ya...>]

Oleg Broytman <phd <at> phd.pp.ru> writes:

> 
> On Thu, Oct 28, 2010 at 01:09:59AM +0000, Mark wrote:
> > Is there a recommend way to deal with hierarchical data with SQLObject?
> > I think I'm going to simply keep track of my categories and their 
> > hierarchy outside of SQLObject classes and then simply have all of my 
> > objects contain a category id so I can list them under the proper 
> > category. 
> > 
> > Reference:
> > http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
> 
>    See also http://onlamp.com/pub/a/onlamp/2004/08/05/hierarchical_sql.html
> 
> Oleg.

Thanks for the link, it is less taxing on my brain.  I really don't want to put 
this into SQL and figure out the SQLObject handling when I can easily set up the 
tree in my python code and pickle it. But as I'm new to moving my app 
functionality onto the web I worry about how big the tree ends up getting, 
formatting, backup/recovery etc..