Tim's Weblog
Tim Strehle’s links and thoughts on Web apps, software development and Digital Asset Management, since 2002.
2003-10-23

calabashmusic.com's "main" table

Jacob Singh has posted a great comment where he explains something that reminds me so much of Topic Maps, or what I'd love to use them for:

"I use a table called main (bad name) which contains almost all peices of data in the site. Weird huh? but it's great. A typical record will contain the ID, ParentID (I have a seperate table for some many to many joins), url_name(like egypt), content_type(like music region), name, title, keywords, img, short desc, etc. etc.

[...] I know this sounds convoluted, but think of the possibilities:

ID hacking: http://calabashmusic.com?ID=546 my script can figure out that this is the same as http://member.calabashmusic.com/world/regsiter "