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?
Month: March 2022
MySQL 8.0 GIS
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
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 “data” merge
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
Samford hosts ICPC regional programming competition
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
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”