AWS CloudFront Databases EC2 PostgreSQL RDS

Lower your AWS bill

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 […]

AWS Databases EC2 MySQL Wordpress

From Hostgator shared hosting to AWS EC2 using Bitnami’s WordPress AMI

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 […]

Databases PostgreSQL Rails Ruby

Change column type from boolean to integer

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 […]

Databases MySQL

Remove leading and trailing spaces from a string in MySQL

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 ‘ ‘ as email attribute, one easy way to find this record is using the TRIM string function in MySQL: SELECT * FROM […]