Jun 16 2016

8 Tips for Surviving a Live Database Migration to Amazon RDS

Patrick Delaney

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. RDS makes it easier to manage multiple databases, the interface is easy to use, it has a good API, and it maintains good uptime. But […] …

Read more

Dec 14 2015

The Ease of Migrating to Aurora

Patrick Delaney

Those looking for a solution to alleviate performance and resource issues with their data tier should consider Amazon RDS’ Aurora a viable option. While the benefits laid out from the AWS marketing team are straightforward and have general appeal, I’d like to take some time to explain just how *easy* it is to transition from […] …

Read more

Jan 25 2007

A Basic Introduction to Postgres Stored Procedures

Jamie Begin

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 procedure veterans who are interested learning more about Postgres. Introduction I originally come from the world of MS SQL Server where stored p …

Read more