Having recently upgraded to a new server for many of my research websites, I have blogged about MySQL 8.0 spatial indexing and migrating from earlier versions. During many hours of trying to get everything to work, I discovered that much of my GPS data is bloated with linestrings full of duplicate adjacent points. The primary… Continue reading MySQL 8.0 GIS
Category: Software
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”
Networking tidbits
Not sure how many people read these posts … actually, wordpress blogs do keep track of your visitor stats … here’s a quick peak. In light of that, this post is mainly for myself to remember a few networking related tasks and commands: HTTPS via bash/terminal Here are some useful commands I found for interacting… Continue reading Networking tidbits
Bringing the cloud back home
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
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