One of the HTML5 features introduced that I have not needed until now is something called “server-sent events“. It’s a strange name which I think is derived from the HTTP content-type text/event-stream which must be set on the server side script generating the events. This isn’t quite the same as web push notifications which are… Continue reading Server-Sent Events
Category: Research
MySQL 8.0
I’ve already run into a number of issues with MySQL 8.0. Most of them have been related to the GIS features (e.g., all functions are now named ST_, geometries must exactly match the column type, etc…). One new issue I ran into today is that my spatial indices are being ignored because I didn’t create… Continue reading MySQL 8.0
An epic “merge”
I have a development system which has diverged quite a bit from the corresponding production system. I have deleted, added, tweaked, fixed, edited, and looked at code on both systems separately without committing on either system. This has dragged on for several years now as I dreaded the day I would need to merge the… Continue reading An epic “merge”
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
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
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