[EMAIL PROTECTED] wrote on 10/18/2006 07:43:41 AM:
> * Matthias Ludwig <[EMAIL PROTECTED]> [2006-10-18 09:05]:
> > On every category- and article-page there should be a "way to
> > the top" with links to every base-category (up to the root). In
> > the database every category has a id, base_id and a name (<=100
> > chars). Every article has category_id that references the
> > category.
>
> You can fetch the entire hierarchy with a single query:
> http://www.developer.com/db/article.php/3517366
>
> See also http://www.google.com/search?q=nested+set in general.
Aye, NS tree would allow you to do this stuff very quickly without loading
obscene amounts of data. Its one disadvantage though is that it is slower
on updates as you have to reorder the tree, but most web aps are heavy
read light write and this is not a big deal.
also check out:
http://www.dbmsmag.com/9604d06.html
http://www.dbmsmag.com/9605d06.html
The old version of mojomojo had a NS tree in CDBI (in-line SQL) which shows
all of the sql in context of a webapp. I think this is being rewritten in
DBIx::Class, but I am not sure on the progress. Also Bluefeet (IRC) was
also working on a Tree module that supports NS generally on DBIC..
_______________________________________________
List: [email protected]
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
