Posts that have the tag "database"
New Blog Update
I've been working on my new blog software for a few months now. I don't intend on adjusting the outward appearance of my blog in any appreciable way, so when I move from the old software to the new software, it should look the same. Rather, all of the changes I'm making are all on the back end of things.
I've been working to objectify my PHP code. Right now, my blog spans over 20 disparate files. There are a few files that are common to them all (similar to classes), but they're mostly for the more complex features. The problem I've been having is reconciling similar functionality and standardizing my coding practices. For instance, I recently spotted a bug in my site redirect script. Were my program stored in a few central classes, I would only have to modify a few portions of the code. However, because everything was apart, I had to modify 15-20 different files correcting the bug. Of course, even with classes, I may have to modify a fair amount of items. For instance, adding, editing and deleting information has a similar procedure with a different query string. With 4 different information classes with an add, edit and delete method in each, that's 12 instances of the exact same code. Making a method for the redundant code makes the code more succinct AND makes it easier to modify down the line.
Currently, I have information classes: my blog entries, comments, image info and image folders. I also have a class for database use, a utilities class, a user authentication class and an HTML class. So far, I've written most of the database and information classes. I need to fine tune and correct any logic errors and try to synchronize common class types. I've also finished writing my utility classes, as they were taken from the old utilities I used before.
The authentication and HTML classes will take a fair amount of time, but most of the logic and styles for each have already been written. I'll just need to slice them up and edit them to function correctly in a modular fashion.
If I were to give a percentage of completion, I'd say that I'm somewhere around 60%. I've completed a lot of the logic grunt work and I have a little left. Afterward, it will be about testing the applications to insure proper working order.
Posted on February 22, 2010 at 12:26 pm. 0 comments. Tags: website admin blog images programming php mysql database
Cat Shelter Software
I've been volunteering at a local cat shelter near where I live. Mostly I've been helping at events at a farmer's market where I stand around at a table, talk with patrons and encourage people to take a look at a cat or donate and just talk to them about their pets.
I also used to help with data entry. Though, I've become increasing frustrated with the software used. So much so, that I want to develop an online database for all of the data. I already have experience in developing front end, web-based data pages. The biggest hurdle, right now, is database construction. The medical information is so varied, that producing a single table or a set of tables is difficult. So, I have to extract the information from the shelter manager/owner...but, that's difficult because she's so busy. So, before I talk with her, I just have to do what I can for now and move on afterward when I can talk to her.
Though, I've also been thinking about developing law administration software. Having worked in the legal field for several years, I think I have the knowledge to start writing my own, custom software to keep track of what I do now. Initially, it'll have to be web-based, but I hope to eventually learn network programming, allowing me to communicate within a network and maybe even remotely. Though, before I even start, I'll need to have a look around and see what else is out there and how they work.