Started rewrite of whelkboard. Notes:
- 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');
db.fetchall()returns a tuple containing a tuple for each row. e.g.
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.