First step: hire me. Done. Joking aside (or maybe not), there are some obvious things to do like: purchasing reserved instances, using scheduled instances or even spot instances. And some that are not so obvious like right-sizing your instances (EC2 and RDS) or asking for discounted pricing when it comes to CloudFront. RDS First step […]
Category: Databases
I needed to move two WordPress sites from a Hostgator shared hosting account to AWS EC2 for two simple reasons: website performance and SSL certificates. There are several WP plugins to ease the transfer but the main problem is that the entire website + database is almost 1GB in size so I have to do […]
Background I had an ActiveRecord Class Message with a read column of type boolean. This column was used, you guessed it, to know if the message had been read by the recipient. Initially this column was of type boolean because it was a simple true/false case but as I continued working on the project and extending the functionality […]
It might be frustrating when trying to query for a record that, without knowing, has a leading or trailing space on a string column. Lets say that you have a User record with ‘ email@example.com ‘ as email attribute, one easy way to find this record is using the TRIM string function in MySQL: SELECT * FROM […]