[thelist] [DB Design] Recursive Directory Structure

Ken Kogler ken.kogler at curf.edu
Sat Feb 1 19:21:00 CST 2003


I don't even know where to start googling on this one... Nothing useful
has been turned up yet.

I want to emulate a directory structure in a database. I don't want to
have to traverse the filesystem on the server as I'm already making
calls to the database (prefrences, config, etc). The structure is
something like this:

Beef
  hamburger
  steak
    sirloin
    strip
    ribeye
Chicken
  sandwiches
  rotisserie
  grilled
Pork
  bacon
  ribs
  chops

If it was a 2-level thing, I could do it with no problem. But I do have
a problem -- this needs to be n-levels deep. I have no clue how many
levels this could eventually end up as.

This is for an online photo gallery -- I'm trying to allow for the
possibility of nested albums.

Am I explaining this clearly?

Thanks everyone!
--Ken




More information about the thelist mailing list