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.. ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
