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
Author: Brian Toone
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
New Home
Welcome to the new home on the web for my faculty blog. Moving the blog here has simplified the update process for the site as wordpress.com and all of the default plugins and themes are automatically updated. Also, this reduces the attack surface area on my university’s network. Look for more frequent posts in the… Continue reading New Home
di2stats.com – a study on gear shifting statistics
I recently unveiled the beta version of di2stats.com. I am releasing this website as a service to the cyclists who have Di2 electronic shifting data available but no means of viewing the resulting data. I am also releasing the website to collect data for inclusion in a journal article describing my preliminary findings. This study… Continue reading di2stats.com – a study on gear shifting statistics
Mapmycity.org project page
I have created a page with summary information on one of my most active projects. There is a lot of exciting progress being made that will hopefully see this tool in the hands of the people who need it most! https://cs.briantoone.com/?page_id=873
Challenges beyond the classroom
Epic bike ride today put on by the Samford chapter of the ACM. Four of us persevered through the snow, freezing temps, and all-round epic conditions for a great ride to remember. Maybe the mini-lecture on microwave towers at the top of Double Oak Mountain will be on the final 😉 Watch a video of… Continue reading Challenges beyond the classroom
Another student project success!
Today we launched a new website for the Samford Campus Recreation department. This launch is the culmination of a year’s collaborative effort with the Campus Recreation department, my Software Engineering students from last Fall, and my continued refinements throughout the academic year and summer. The previous version of the website was developed and edited exclusively… Continue reading Another student project success!
Back up and running
Downtime One of the many great things about Samford University is that faculty and lab computers are on a lease system through Dell. That means that every three years, I get to log onto the Dell website and configure my new machine with the hardware that I want as long as I stay within the… Continue reading Back up and running