Some Resources on Open-Source Discussion Forums
Sourceforge.net FuseBox-based Open Forum
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/