There are a lot of benefits to migrating an on-premises database to Amazon Relational Database Service (RDS). I’ve found that RDS is much easier to operate than MySQL or PostgreSQL. …

Continue reading “8 Tips for Surviving a Live Database Migration to Amazon RDS”

This article introduces the very basics of writing stored procedures with PostgreSQL (aka Postgres), an open-source database system. It is intended for both Postgres newbies and MS SQL Server/MySQL stored …

Continue reading “A Basic Introduction to Postgres Stored Procedures”