Worked on Mnemosyne the past couple of days. Added password protection so that spammers can’t enter anything. Add the same functionality to the delete page so that only I can delete the entries for now.
Also added an edit page (also password protected). The main functionality is starting to come together. Stuff on the horizon:
- Tag support
- Profile Support
And then a bunch of code quality issues. I’m sure there’s got to be a better way to handle database stuff. Hopefully something like hibernate for php. I’ll have to look into that.
Got my local environment set up, so I don’t have to use the live site as my testing ground. That didn’t take as long as expected. A couple of trip ups. For one, if using Windows 7 64-bit, apache 2.2, and php5 make sure you get the VC6 thread safe versions, or else apache and PHP might not work well together. I tried all four distributions of php5 before I got it right.
I sort of let this site slip. And by sort of, I mean completely. I had uploaded functionality to Mnemosyne without fully testing it, and it pretty much broke everything. I was able to sort out what the problem was and fix it, but I don’t think I’m doing database connections properly in PHP. I basically have a database connection opening at the beginning of each page, then closing it at the end. Maybe that’s how it should be done, but it seems intuitively wrong. I’ll have to look at that.
So Mnemosyne works again. Lots of spam on there that I’m going to have to clean up. I’ll need a password or CAPTCHA to filter that out. Maybe password for the beginning, then CAPTCHA when I have more time.
I removed some music flash players on the home page. They had worn their welcome. I need to change that front page completely. I don’t like it anymore.
Hopefully this isn’t the last entry for a while.
Worked on Mnemosyne last night. I have the ability to list all the tags, and list all the entries. It’s looking pretty terrible right now, and the code is very sloppily put together, but some of the core functionality is coming together. Next major steps are going to be adding the edit and delete ability (with some permissions), and linking tags and entries. I was thinking of having a simple text box for tag entry, but maybe it should be a fixed list? A text box might not be restrictive enough.
Added two photos to Apollo. A play with focus. I noticed that the wordpress theme is cutting off my landscape pictures. I’ll need to put that on the list of things to fix.