A short summary of the Year 2021 in the PostgreSQL ecosystem

On behalf of the PostgreSQL community and the team at MigOps, we wish all the readers a very Happy New Year – 2022. It is no wonder that PostgreSQL is the only Open Source database with a consistent increase in its adoption every year. The Year 2021 has been another milestone in the PostgreSQL world. Every user of

Read More »

Is Aurora PostgreSQL really faster and cheaper than RDS PostgreSQL – Benchmarking

This article is to help you understand that you should benchmark before choosing Aurora PostgreSQL over PostgreSQL. We have often noticed that a lot of Customers migrating from Oracle to PostgreSQL get confused between PostgreSQL and Aurora PostgreSQL. Majority of leaders and key decision makers incline towards Aurora PostgreSQL as it is often marketed as 3 times faster

Read More »

PostgreSQL 15 will include some more regexp functions

While migrating from other databases like Oracle to PostgreSQL, we may come across some functionalities that may be only available with a complex work-around. At MigOps, we have migrated many customers from Oracle to PostgreSQL and I have personally seen many scenarios where direct equivalent is not possible. One of them was while working with regular expressions. There

Read More »

MigOps announcing the support for Babelfish on any Cloud Platform

AWS has recently announced the release of Babelfish extension that supports SQL Server TDS protocol. In order to have this extension work with PostgreSQL, it required some changes to PostgreSQL. However, the original thought of having the required hooks integrated into PostgreSQL has not been considered by the PostgreSQL Community (see the discussion here). For this reason, AWS

Read More »

Migration Management and schema version control in PostgreSQL

Version control of any code is essential for every organization. All organizations use their own preferred tools like git, svn, perforce etc. As I was working on a new requirement, which is about porting the current CI/CD pipeline to PostgreSQL, I needed to look for a tool which will take care of the schema changes. In this use

Read More »

Organizing PostgreSQL codebase using templates in Golang

While migrating to PostgreSQL, have you ever wondered whether you could make changes to SQL-only code without triggering a build, re-deployment, or even a restart? Have you ever attempted packaging software as a binary and allowing clients to execute their own compatible queries on any DB engine at no additional cost? In such cases, a better approach to

Read More »
Scroll to Top