Server-Sent Events

Server-Sent Events enable finer grained progress updates on a long-running script.

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

Linux in the classroom

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: Invoke an HTTPS request from bash/terminal Clarify the difference between ssh -L… Continue reading Networking tidbits