The shape of things to come
Sunday February 21, 2010
As many followers of this site are aware, this site started as a simple weekend project for me to learn how to develop web pages on a LAMP stack (Linux, Apache, MySQL, PHP). I needed some data for the MySQL database and my astronomy observing log book was close at hand. I typed a few log entries into the database and started building PHP scripts to extract the log entries and display them on a web page. That was six years ago and my tinker-toy project grew into something far beyond its humble beginnings.
When you are building proof of concept applications (my professional term for tinker-toy projects) you don’t necessarily follow traditional development processes or develop the project to the end level. For example, I never built an online editor to post these blog entries to the database. I write the blog entries in a text editor, add the HTML markup by hand, and then add the record directly to the database. I repeat this process for every log entry, blog entry, object description, etc. that you read on this site. If I want to link two pieces of information (e.g. a log entry to an object in the database), I have to look up the record ID’s for each item and enter those by hand. As you might surmise, this is a time consuming task.
Now I am looking to expand my observing log and take some features to the next level, but I need to employ new technology to make that happen. To make the next leap, I am moving the log off of the LAMP stack to an ASP.Net application connected to a Microsoft SQL database. The database conversion is already well underway and I am approximately 90% complete. For the past few weeks, I have been making updates in both databases (MySQL and MSSQL) but that is going to end soon. It doesn’t make sense to do double work. I will be concentrating on making all future updates in the MSSQL database from this point forwards. Additionally, I will be moving the site to a new server which may cause availability issues during move.
If everything goes as planned, you will see a smooth seamless transition from the old site/technology to the new site/technology but keep a watch out for those unexpected bumps along the way.










Jeff Burton








