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)  | Comments [0] | Software | Business | Cloud#
Comments are closed.
Search
On this page....
Countdowns
The Daily Parker +3076d 12h 04m
To San Francisco 37d 11h 39m
Parker's 8th birthday 60d 01h 09m
My next birthday 140d 23h 26m
Categories
Aviation (300) Baseball (100) Best Bars (4) Biking (42) Chicago (824) Cubs (179) Duke (131) Geography (300) Higher Ground (5) Jokes (282) Kitchen Sink (577) London (32) Parker (180) Daily (204) Photography (134) Politics (301) US (1014) World (223) Raleigh (20) Readings (8) Religion (61) San Francisco (77) Software (185) Blogs (67) Business (203) Cloud (79) Cool links (122) Security (94) Travel (139) Weather (652) Astronomy (72) Windows Azure (46) Work (26) Writing (7)
Links
Archive
<April 2014>
SunMonTueWedThuFriSat
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910
Full archive
Blogroll
About
David Braverman and Parker
David Braverman is a software developer 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: 4260
This Year: 158
This Month: 23
This Week: 7
Comments: 0