Friday, September 30, 2016
Last week I finished populating the Celebrity Birthday Database I maintain locally on my Macbook. It was a manual process, in that I no longer maintain the database online for security reasons.
In the past, the WiredPages Style and Events page used the data within a Java Applet to provide visitors with the current Celebrity Birthdays.
Initially, I developed a JDBC servlet which on a daily basis- extracted the data from a source and then inserted the data to my online database. About 3 months before retrieving all of the data for a complete year of celebrity birthdays- I made a mistake and deleted most of the records. The most recent backup was missing about a month of the records.
Also when I checked the online database, I found the data was corrupt. Birthdays that I had intentionally deleted, [that first year I checked every day to insure the data being inserted would be useful to WiredPages visitors and therefore manually deleted some of the records my software inserted]-- were somehow reinserted. I know this was malicious because of the birthdays selected for reinsertion.
I maintain several databases I custom built for WiredPages, and the Celebrity Birthday Database perhaps the most valuable in that the data was mined from a credible source-- initially with software.
Because of the security issues with both the idea of theft of the database and the insertion of data I did not want, I chose not to leave a credible database online at the current location.
My plan was/is to move the entire site to a more secure host and create and build the new version online from the Celebrity Birthday Database I maintain on my Macbook.
I have been planning this move for awhile. Right now, mainly hoping that DOJ and others help with the resolution of the many legal issues involved with my business and personal affairs.
So though I try to do very little in the way of coding, and even less in the way of updating anything online-- I did do a little work today.
I am moving away from the Java Applet and starting to work on new interfaces that provide the same data to WiredPages' visitors without the Applet. In the future, I will continue to use Java-- however mostly only Java Servlet technology. This will be more friendly for mobile devices and the newer browsers being used with the latest releases of operating systems, i.e., Windows 10, Chrome, etc..
Shown below-- my work environment today, including my IDE, local Database Management Software and a Firefox browser window showing how the new Celebrity Birthday Interface will look. The interface is shown in stand alone mode-- however will be easy to integrate on the WiredPages Style & Events Page when I decide to move everything online.
I was so pleased to complete the insertion of the remaining records to the local Celebrity Birthday Database earlier in the week, I could not wait to rewrite the JDBC Servlet interface to access the data. I really miss coding and researching new ideas for WiredPages. I hope to get moving on other updates in the near future, however wanted to provide some of the details involved.