Truth Tables (… you can handle the truth)

About eight years ago I worked on my first major commercial software project. Before I worked as a freelancer and had mostly rather small and dull projects. This project however had a team of eight people plus management and it was surprisingly complex at times. One day we had to implement a feature which depended […]

Camel Case in MySQL Table Names is a Bad Idea

Today at work I encountered all kinds of “naming schemes” for MySQL tables and columns. Camel case table names in particular can cause serious pain because: Table names directly correspond to filenames on your hard drive There are tons of different filesystems and some of them are case insensitive. So if you develop on OS […]