MYSQL Database Maintenance of Web Site
 Lenses
For Less
MySQL Maintenance. I did not design
the Lenses
For Less website. Rather,
I was asked to modify the backend MySQL database and supporting
code to add functionality to accept electronic fund transfer
(EFT) payments and fix miscellaneous "mystery" bugs
that had eluded the previous programmer.
thorough analysis of the problem for complete solution
Like reading a technical manual in French, I had to read
the perl code to find out what it was actually doing because
there was no documentation for the web site.
No Substitute for Old Fashioned Desk
Work. Thorough
analysis of all the perl files led me to find all the changes
necessary to "forgotten" functionality that is used only periodically
(such as end-of-month reports).
What might
have seemed to be a simple addition of a few fields to the
database was, in fact, a rather complex task involving the
changing of numerous perl files.
live production site maintained with no down time
This website did not lose any orders due to downtime during
the software upgrade. This was accomplished by using
prudent software development techniques to assure quality.
|
