Migrations to PostgreSQL

Important PostgreSQL 14 update to avoid silent corruption of indexes

On June 16 2022, a new PostgreSQL 14 minor release will be published by the PostgreSQL Global Development Group. The new PostgreSQL 14.4 release fixes an issue with all versions of PostgreSQL 14 that can lead to silent corruption of indexes. Usually, the community announces a minor version update on the second Tuesday of the second month of …

Important PostgreSQL 14 update to avoid silent corruption of indexes Read More »

Handling Trailing Zeros With Numeric Datatype in PostgreSQL

While performing Oracle to Postgres migrations, we may come across many interesting conversion challenges. Sometimes, the same logic might produce a different behavior between Oracle and Postgres. Minor mistakes in such conversions may create a lot of work while fixing the application functionality. One of such mistakes is while handling trailing zeroes with numeric datatype in PostgreSQL, during …

Handling Trailing Zeros With Numeric Datatype in PostgreSQL Read More »

Contributions by MigOps to PostgreSQL in 2021

Our team at MigOps, believes that the increasing open source contributions to the PostgreSQL ecosystem is the major reason for increased migrations to PostgreSQL. Several developers across the world have been spending a lot of their personal and professional time to keep the beauty of this Open Source database software active. Some organizations have even hired developers to …

Contributions by MigOps to PostgreSQL in 2021 Read More »

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 …

A short summary of the Year 2021 in the PostgreSQL ecosystem 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 …

Is Aurora PostgreSQL really faster and cheaper than RDS PostgreSQL – Benchmarking 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 …

PostgreSQL 15 will include some more regexp functions 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 …

MigOps announcing the support for Babelfish on any Cloud Platform 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 …

Migration Management and schema version control in PostgreSQL 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 …

Organizing PostgreSQL codebase using templates in Golang Read More »

Stored Procedure OUT Parameters in PostgreSQL 14

PostgreSQL global development group generally announces a new release every year, with several new features. With an increase in the number of contributions and contributors, the new version PostgreSQL 14 released on September 30th, 2021, with several important features.  As a developer and a database migration expert, I am happy to say that there are several developer friendly …

Stored Procedure OUT Parameters in PostgreSQL 14 Read More »

Scroll to Top