[Tutor] Message persistence

Daniel Yoo dyoo@hkn.eecs.berkeley.edu
Fri, 13 Apr 2001 00:58:36 -0700 (PDT)


On Mon, 9 Apr 2001, Derek White wrote:

> Hello all,
> 
> If I were wanting to write a web based message board system with CGI with 
> replies in threads what would be some of the ways to consider for message 
> persistence in Python?

If there's going to be a lot of messages, you'll probably want to store
your data within some sort of SQL database.  The reason for this is
because databases are equipped to handle large amounts of heirarchical
stuff.  There are a few free (free speech and free beer) systems out
there, including mysql and postgresql:

    http://www.mysql.com
    http://www.pgsql.com

(Strangely enough, www.pgsql.com seems to be down at the time of this
writing.  Check back on it later.)

There's a nice web site that talks a lot about mysql called devshed:

    http://devshed.com/Server_Side/MySQL/

which might give you ideas on how to plan out the structure of your web
message board.

Something tells me, though, that all this might be overkill.  Is this what
you're looking for, or something else?