Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Angry Design of a Forum database

    What kind of a database design would work perfectly with JSP/MySQL for a forum?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: Design of a Forum database

    Originally posted by razafarooqui
    What kind of a database design would work perfectly with JSP/MySQL for a forum?
    One that has a normalised set of tables that reflect the structure of the information that you wish to hold. If it is for a Forum like this one, then (looking around the page I am typing into) I would expect to see tables for User, Forum, Subject, Posting, etc.

  3. #3
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697

    Re: Design of a Forum database

    Originally posted by razafarooqui
    What kind of a database design would work perfectly with JSP/MySQL for a forum?
    There are some open source forum packages you can use as models, for example, SlashCode. It's far from perfect (and uses Perl instead of JSP) but it's quite mature and there are archives of developer discussions weighing issues that have arisen over time.

  4. #4
    Join Date
    Oct 2002
    Posts
    37

    Re: Design of a Forum database

    Originally posted by razafarooqui
    What kind of a database design would work perfectly with JSP/MySQL for a forum?
    First, I don't think the structure of DB tables have any strong relationship with the programming envirnoment.

    Second, if you want to build a forum for real world usage, you might consider to join force rather than do your own. There is a open source J2EE forum project, called mvnforum (http://www.mvnforum.com/mvnforumweb/index.jsp). It is in a very good shape at this moment. Take a look.

  5. #5
    Join Date
    Dec 2001
    Location
    Delhi/Bangalore, India
    Posts
    74
    Although it isn't a discussion forum concept (it is rather a Content Management System), an interesting concept using nodes is http://everydevel.com/ (worth a check before you go on to design your web-based forums).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •