A short summary of the Year 2022 in the PostgreSQL world
We have earlier posted the summary of the year 2021 in the PostgreSQL world. On behalf of the PostgreSQL community and the team at MigOps, we wish all the readers a very Happy New Year – 2023. The year 2022 has been another great year for PostgreSQL with new features, patches to existing extensions, numerous new extensions and
Oracle vs SQL Server vs PostgreSQL – DATE data type
Migrations to PostgreSQL always allow us to share interesting information about PostgreSQL compared to databases like Oracle and SQL Server. One of such is related to the behavior of the DATE data type in Oracle vs PostgreSQL and SQL Server vs PostgreSQL. PostgreSQL is a database with a rich set of data types that follow standards. For this
Contributions by MigOps to PostgreSQL in 2022
We have earlier published the contributions by MigOps to PostgreSQL in 2021. MigOps has continued its momentum of Contributions to PostgreSQL in 2022. This was with the spirit of supporting users looking to PostgreSQL and adding our share on increasing PostgreSQL adoptions. In the year, 2023, MigOps aims to make more massive contributions, to support migrations of both
Oracle vs PostgreSQL – Transaction control statements
While migrating from Oracle to PostgreSQL, the important fact to consider is that they both are 2 different database engines. The major mistake made by organizations during the course of migration is assuming that the behavior of both Oracle and PostgreSQL are same. One of such areas with differences between Oracle vs PostgreSQL is while working with Transaction
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
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