Category: PostgreSQL

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

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