Blog Archives

MySQL RDS Point-in-time restore

RDS for MySQL on AWS allows you to restore to any point in time for your backup retention period, minus the last 5 minutes or so. Restoration creates a new instance, it does not overwrite whatever instance you’re restoring. AWS’s

Tagged with: ,
Posted in Databases, IT

Micra: A simple Java Web framework

Java powers a lot of webapps, but I’ve always found it to be fairly unwieldy to get a project started, especially in comparison to the simplicity of Ruby, PHP, or server-side JavaScript (Node.js). Even a simple Hello World in Spring

Tagged with:
Posted in IT

Never use floats for money

UPDATE: Several people have commented that decimal(10,2) is not correct for money, since sometimes currencies go out to more than 2 decimal places. Others claimed that storing cents (or base unit) as integers make it simpler to perform calculations (thanks, Kevin Farley for

Tagged with:
Posted in Databases, IT

Interviewing for a Database Developer

I work for a firm that’s heavily invested in SQL – a team that needs to have developers who know their way around relational databases and MySQL in particular. I want to show you how I run interviews for our

Tagged with:
Posted in Databases, IT

Tiny happy features in MySQL

I love it when software gives you elegant ways of solving your problem. Programming language designers make me feel like they care when they take the time to include succinct, powerful expressions. I’ve recently discovered some in new things in

Tagged with:
Posted in Databases, IT, Open-Source