Cloud computing is the way of the future, right? Well, yes, but it’s also expensive. $55/month expensive. That adds up year-after-year, so I decided to purchase a server I could get keep running here at the house to bring all my websites back home (literally) … being careful to stay within the confines of our… Continue reading Bringing the cloud back home
End of an era
I started a combined Masters/PhD program at the amazing UC Davis Department of Computer Science in the Fall of 1999. As a grad student, I not only had access to the lab computers, but also access to a folder named “public_html” in my user account which was configured to serve up a website under the… Continue reading End of an era
django migration
I am one of the coaches on the Spain Park high school mountain bike team where both my son and daughter have been racing for many years now (since middle school). I run the team website, which I ported from standalone HTML to a django application to add the ability for team members to login,… Continue reading django migration
Migrating mybiketraffic.com
I saved the hardest for last. While technically not really that hard, I did want to keep the website up and running during as much of the migration as possible. As an extra complicating factor, to ease server space on my server, I stopped storing as much data in the mysql database and was storing… Continue reading Migrating mybiketraffic.com
DNSmasq-uerading
ATT Fiber has been absolutely fantastic. Zero downtime for the first month and incredibly fast. One of the challenges is ATT is making money off of DNS errors. I don’t have a problem with that at all, but they have locked down their modem/router combo so that you cannot change the DNS server to force… Continue reading DNSmasq-uerading
Trouble in paradise
My migration to a new server for all the web-based projects I’m hosting has been going great … until now. This morning, I woke up and was working on my main computer when I noticed that my server wasn’t kicking up every few minutes to refresh the OSM planet database. I turned on the screen… Continue reading Trouble in paradise
Migrating MySQL5.6 to MySQL8.0
Whew, this turned out to be quite problematic for one of my oldest databases with spatial data. The problem turned out to be that MySQL5.6 was quite flexible with how you used spatial datatypes. I had a table with a POLYGON data type, but I had stored a bunch of LINESTRING geometries instead. MySQL5.6 …… Continue reading Migrating MySQL5.6 to MySQL8.0
di2stats.com migration
One of my longest running projects with many thousands of users now is the website di2stats.com. I just added this message to the import page and disabled the import functionality so that I can migrate the database and file data to a new server. I started the migration process this morning (which I will detail… Continue reading di2stats.com migration
Mybiketraffic.com
Well, it has been three years since I last wrote here. That doesn’t mean I haven’t been busy! Quite to the contrary, shortly after my last post in 2018, I launched probably my most ambitious project yet: https://mybiketraffic.com At the same time, my long time friend, mentor, and colleague, Steve Donaldson, passed away and I… Continue reading Mybiketraffic.com
Windows subsystem for Linux
Well, haven’t we come a long way? It seems like Microsoft has always kept its eye on Linux – providing limited interoperability through it’s Hyper-V virtual machine system. But Microsoft has taken a few leaps forward with Linux in the past year or two. First, they introduced the Windows subsystem for Linux for the latest… Continue reading Windows subsystem for Linux