Let me preface this post by saying this is a bad idea for most true production systems, particularly ones with many hundreds, thousands, or hundreds of thousands of users. But for quiet, independently developed web apps with only a handful of users, I believe this is a viable strategy given the caveats in bold a… Continue reading Developing on production?
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
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
I blogged during an epic merge that took a couple weeks to complete in which I reconciled code changes between a development system and a production system which had diverged significantly over a period of a few years. Today is the day I’m going to try to tackle the corresponding data merge mentioned in that… Continue reading An epic “data” merge
Yesterday was a successful day here in the Samford University Math/CS department hosting the Southeastern Region of the ICPC contest. As site director, I oversaw the preparation and implementation of the contest using our facilities. It would not have been a success without the help of our Computer Science director, David Luginbuhl, and colleagues Greg… Continue reading Samford hosts ICPC regional programming competition
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”