Howdy Michael, Thursday, December 19, 2002, 7:54:13 PM, Michael T. Tangorre wrote:
> I am attempting to to try some more advanced things with an idea I > have. I am going to be building an online forum to tinker with.. can > anyone point me to some database examples? The code side is what I am > going to be playing with but need a good architecture to use.. anyone > know of one I can download? I didn't see a reply to this yet, so I'll offer one to consider: http://sourceforge.net/projects/fbopenforums/ It uses Fusebox, but you might be able to get something useful out of it. If you are wanting to explore how the database would be structured for a forums app, you might want to research hierarchical database design, parent-child relationships, or using recursion with your database. This page is an example of doing recursive joins for a forum: http://www.4guysfromrolla.com/webtech/sqlguru/q120899-1.shtml with a follow-up here: http://www.4guysfromrolla.com/webtech/sqlguru/q121799-1.shtml Another post about threaded discussion forums database design: http://www.sqlteam.com/item.asp?ItemID=1353 with a follow-up here: http://www.sqlteam.com/item.asp?ItemID=1602 Some good SQL sites to check out: http://www.dbmsmag.com/index.shtml http://www.codebits.com/ntm/ http://www.onlamp.com/pub/a/onlamp/2001/07/12/aboutSQL.html http://www.sqlteam.com/Default.asp http://www.4guysfromrolla.com/ http://www.intelligententerprise.com/info_centers/database/ http://www.databasejournal.com/ http://www.sqlmag.com/ Hope that helps you somewhat. Happy Holidays! -- Chris Montgomery monty @ airtightweb.com Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
