The simple goal was to use Microsoft Azure services to setup a traditional SQL Database (SQL Server) running in the Azure cloud. Students had $100 credit towards the services. The problem we ran into is that by using all the default settings, you end up with $380/month system that was going to blow through the… Continue reading Linux in the classroom
Developing on production?
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?
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”
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
End of an era
I started a combined Masters/PhD program at the amazing UC Davis Department of Computer Science in the Fall of 1999. As a grad student, I not only had access to the lab computers, but also access to a folder named “public_html” in my user account which was configured to serve up a website under the… Continue reading End of an era