Started rewrite of whelkboard. Notes:

MySQL:

1. Setting the password for a database user
   
   Assigning a password to the user via

   UPDATE USER
   SET PASSWD = PASSWORD('password')
   WHERE USER='username'

   just didn't seem to assign a properly encrypted password. Eventually discovered (when logged in as the root user)

   SET PASSWORD FOR username = PASSWORD('password');

2. Using MySQLdb
   
   

   db.fetchall()

   returns a tuple containing a tuple for each row. e.g.

   ((1L, 'fudge'))
   

Next step is to build in simple user support and then to hook that into cookies. Would like to run all the python CGI in the same runtime so that I can keep a resident shared object but have no idea how to go about it at this stage.