MySQL benchmark of AWS RDS vs EC2 with complete results and instructions on how to recreate on your own for under $0.25. Update 9/15/2013 – Added bar charts to compliment tables. I found a couple blog posts with benchmark data … Continue reading
The following MySQL query is useful for getting a count of all the domain names used by email addresses in your database. It isolates the domain name (after the @ sign) in the email field. SELECT substring_index(email, ‘@’, -1), COUNT(*) … Continue reading
This post demonstrates 5 examples of Spreadsheet-Fu to make quick work of menial data formatting tasks. Spreadsheet programs have useful functions built into them for string manipulation (concatenation, search and replace, formatting, etc). It used to be just Excel and Open … Continue reading
From time to time, MySQL 5.1 databases need a little house keeping. We found our production DB had a hard time running a simple join query between two tables with about 400k rows. It was taking between 30 and 100 … Continue reading
I introduced MongoDB to a colleague today (version 1.8.1 to be exact). He comes from a RDBMS, 3rd normal form, relational background. Here’s what he said. Keep in mind, we have a healthy humor level going at the office. I … Continue reading
