PostgreSQL

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 »

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 »

SELECT FOR UPDATE and its behavior with foreign keys in PostgreSQL

The general approach followed by developers is to pre-acquire the lock(FOR UPDATE)on the data sets that are being updated/deleted concurrently. This approach may be considered to solve the dead lock problem or to control the concurrent access to one or more rows, but could sometimes lead to an unnecessary locking behavior. In this article we shall discuss about …

SELECT FOR UPDATE and its behavior with foreign keys in PostgreSQL Read More »

Upgrading PostgreSQL 9.6 to PostgreSQL 13

It the the time for everybody using PostgreSQL 9.6 to start planning an upgrade to the latest supported PostgreSQL version. PostgreSQL Global Development Group (PGDG) supports any major version for 5 years after its initial release. PostgreSQL 9.6 with its initial release on September 29, 2016 is about to become an unsupported version. Its final minor version will …

Upgrading PostgreSQL 9.6 to PostgreSQL 13 Read More »

Announcing PG_DBMS_JOB in PostgreSQL for Oracle DBMS_JOB compatibility

When you are working on Oracle to PostgreSQL migrations, one of the Oracle packages that cause conversion issues is DBMS_JOB. Traditionally, we used extensions like : pg_agent, pg_cron or more recently pg_timetable for scheduling jobs. All of these tools or extensions use a cronjob like scheduling method which does not give a full compatibility of the features provided …

Announcing PG_DBMS_JOB in PostgreSQL for Oracle DBMS_JOB compatibility Read More »

Validate PostgreSQL extension upgrade scripts using pg_validate_extupgrade

A few days ago, I decided to try this new extension called pg_validate_extupgrade written by Julien Rouhaud. This extension looks very interesting for those who are developing PostgreSQL extensions. The point is that when upgrading the extensions that you develop, you have to create upgrade files and, if necessary, downgrade files to go from one installed version to …

Validate PostgreSQL extension upgrade scripts using pg_validate_extupgrade Read More »

CentOS vs Rocky Linux Benchmark with PostgreSQL

In December 2020, you might have seen an article from CentOS about shifting their focus towards CentOS stream, which is the upstream version of the RHEL. CentOS also mentioned that the version 8 would be EOL (end of life) by the end of the 2021. This means that it will no longer receive any updated fixes from it’s …

CentOS vs Rocky Linux Benchmark with PostgreSQL Read More »

Announcing Credcheck extension to enforce username and password checks in PostgreSQL

PostgreSQL includes robust security standards around all aspects such as authentication, authorization, accounting and auditing. User management and role based segregation that satisfy enterprise standards can be implemented at ease. Similarly, organizations may be willing to enforce certain compliance around the password standards such as the minimum upper case characters or minimum number of numbers and special characters …

Announcing Credcheck extension to enforce username and password checks in PostgreSQL Read More »

Scroll to Top