[thelist] Database Schema Suggestions

Joshua Olson joshua at waetech.com
Mon May 3 07:28:32 CDT 2004

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


Look no further an Evolt's own article archive:


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.

More information about the thelist mailing list