Making the Journal Easier
I have been working on the Journal through the pgaccess interface, and while it's good enough to get the job done in a pinch, it's not nice enough for me to be able to make the kinds of updates that I want to. So... I looked into making a pgaccess form and seeing if that would solve the usability problems. No good. So I decided to see if PHP could do the trick. I was in luck.
The key for me is the security. I wanted to be able to do this on the web, but I also wanted to secure it so that I'd be the only one able to modify the journal. Thankfully, PHP gets the remote browser's IP address, and saves it. This means that my two pages - the viewer, and this, the editor, can check that address and compare it to the address of the machine on which I'll do all the updates. Then, it was a simple matter of creating this update page and enhancing the viewing page to allow for updates coming in. Pretty simple, really.
The result is that I get a very nice editor for my journal entries. I can go back and edit entries, and add new ones as I see fit. No need to worry about URLs or other problems. It's nice and clean. I think this is going to be even nicer than the older version. What a deal!