geekdom without assumption

MySQL Data Footprints: How Big are Your Tables?

If you work on the architectural end of things (or if you're just curious), it can be extremely helpful to see what kind of footprint your data tables actually have in real use. In testing, it can be Continue Reading

Timezone fun with MySQL and UTC

Since our company has timeclocks and users all over the country (and world, for that matter), we switched pretty early on to using UTC exclusively in the back-end. The views handle spitting out the Continue Reading