[thelist] Database Schema Suggestions

[Joshua Olson]

> -----Original Message-----
> From: Burhan Khalid
> Sent: Monday, May 03, 2004 6:59 AM
>
>    I'm once again faced with a database design problem, and not quite
> sure what is the best way to solve it.  The task is to design one of
> those unlimited category directories.  Like dmoz.org or yahoo
> directories, et. al.

Burhan,

Look no further an Evolt's own article archive:

http://www.evolt.org/article/a/17/4047/index.html

Technique #3 (Flat table) has worked very well for me.  It's greatest
benefit is EXTREMELY quick selects, which is ideal for browsing.  Inserts
and branch moves require a few more steps, but are still quite possible.

Best of luck,

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168