sqlobject-discuss

[SQLObject] Managing hierarchical data

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

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

Mark

Re: [SQLObject] Managing hierarchical data

[Oleg B. <ph...@ph...>]

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.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

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.. 

Re: [SQLObject] Managing hierarchical data

[Oleg B. <ph...@ph...>]

On Thu, Oct 28, 2010 at 08:16:33PM +0000, Mark wrote:
> I can easily set up the 
> tree in my python code and pickle it.

   My not so humble opinion on that is - don't do that. Use portable tools
(portable between languages, I mean in this case). SQL is quite a portable
tool; if your project eventually grows up to include a number of developers
they would want to use different languages for different tasks, for
example, Java to create reports and PHP for quick-and-dirty backoffice; in
this case having a well thought out SQL schema is a big advantage.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Managing hierarchical data

[Lutz S. <l.s...@4c...>]

On Thu, 28 Oct 2010 01:09:59 +0000 (UTC)
Mark <mar...@ya...> 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

Some nice concepts not only for non SQL DBs:
http://www.mongodb.org/display/DOCS/Trees+in+MongoDB


regards
lutz