I recently completed University of Waterloo’s Introduction to Computer Graphics Course. If you’re a present or future computer science student at Waterloo: This was one of the most interesting and challenging courses I’ve taken at the University; definitely check it out if you can (especially if it’s being taught by the wonderful Craig Kaplan). Fair warning: The work load is quite high.

The course work consists of four assignments covering OpenGL basics, the graphics pipeline, hierarchical modelling, and ray tracing, as well as a final project. For the project, I chose to extend my ray tracer from the fourth assignment…

In April 2016, a user wrote in wondering why their profile said they were following 6 people but it was not possible to see who they were.

Thus began my month-long journey that ended in triple distilled, single-malt scotch whisky.

The Bug

500px uses a MySQL-based master/slave database to store the most frequently accessed user data. I quickly narrowed the cause down to how we store who follows whom. That data lives in one database table, “followings”, that’s structured like this:

| Field | Type | Null | Key | Default | Extra | |-------------|------------|------|-----|---------|----------------| | id | int(11) | NO |…

Nick Frasser

Software Developer at Structura Bio. Aspiring photographer. Alleged hipster. http://nfrasser.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store