Politics, Weather, Photography, and the Dog
Saturday 3 November 2012

I mentioned a few weeks ago that I've had some difficulty moving the last remaining web application in the Inner Drive Technology Worldwide Data Center, Weather Now, into Microsoft Windows Azure. Actually, I have two principal difficulties: first, I need to re-write almost all of it, to end its dependency on a Database of Unusual Size; and second, I need the time to do this.

Right now, the databases hold about 2 Gb of geographic information and another 20 Gb of archival weather data. Since these databases run on my own hardware right now, I don't have to pay for them outside of the server's electricity costs. In Azure, that amount of database space costs more than $70 per month, well above the $25 or so my database server costs me.

I've finally figured out the architecture changes needed to get the geographic and weather information into cheaper (or free) repositories. Some of the strategy involves not storing the information at all, and some will use the orders-of-magnitude-less-expensive Azure table storage. (In Azure storage, 25 Gb costs $3 per month.)

Unfortunately for me, the data layer is about 80% of the application, including the automated processes that go out and get weather data. So, to solve this problem, I need a ground-up re-write.

The other problem: time. Last month, I worked 224 hours, which doesn't include commuting (24 hours), traveling (34 hours), or even walking Parker (14 hours). About my only downtime was during that 34 hours of traveling and while sitting in pubs in London and Cardiff.

I have to start doing this, though, because I'm spending way too much money running two servers that do very little. And I've been looking forward to it—it's not a chore, it's fun.

Not to mention, it means I get to start working on the oldest item on my to-do list, Case 46 ("Create new Gazetteer database design"), opened 30 August 2006, two days before I adopted Parker.

And so it begins.

Saturday 3 November 2012 14:48:40 CDT (UTC-05:00)  |  | Software | Business | Cloud#
Search
On this page....
Starting the oldest item on my to-do list
Countdowns
The Daily Parker +3325d 13h 10m
2015 10d 01h 03m
Parker's 9th birthday 176d 00h 03m
My next birthday 257d 04h 08m
Categories
Aviation (347) Baseball (110) Best Bars (7) Biking (44) Chicago (916) Cubs (197) Duke (132) Geography (336) Higher Ground (5) Jokes (284) Kitchen Sink (660) London (58) Parker (195) Daily (204) Photography (144) Politics (303) US (1099) World (258) Raleigh (21) Readings (8) Religion (66) San Francisco (88) Software (207) Blogs (77) Business (233) Cloud (90) Cool links (134) Security (99) Travel (228) Weather (702) Astronomy (88) Windows Azure (60) Work (83) Writing (10)
Links
Archive
<December 2014>
SunMonTueWedThuFriSat
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
Full archive
Blogroll
About
David Braverman and Parker
David Braverman is the Chief Technology Officer of Holden International in Chicago, and the creator of Weather Now. Parker is the most adorable dog on the planet, 80% of the time.
Legal
All content Copyright ©2014 David Braverman.
Creative Commons License
The Daily Parker by David Braverman is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 United States License, excluding photographs, which may not be republished unless otherwise noted.
Admin Login
Sign In
Blog Stats
Total Posts: 4598
This Year: 496
This Month: 28
This Week: 1
Comments: 0