Working on Remote Updates

Today I decided that I needed to be able to update my Journal while I was away from the office. So I came up with a little script that reads all the HTML files in a directory and inserts them into the database by their file timestamp. This is the first such inserted entry and I'm hoping that this will make it a lot easier for me to keep my notes during the day and then save them to the database each evening when I plug my laptop into the network and sync up.

There were a lot of things that needed to be done to get this right - and while the script is short, it is deceptively simple. I augmented the standard HTML to include the TagLine as well as stripping it out on the INSERT. Nothing fancy, but it was a lot of little details.