Deepak Mahto

POSETTE 2024 Talk

Accelerating PL/pgSQL Code Conversion When Migrating to Postgres

local CEST (Livestream 2)

Most of the adopters of PostgreSQL are folks moving from another database and code conversion or pl\pgsql development is a critical path. It is a session, we will walk through curated learning I had moving customers and large code bases to PostgreSQL with pl\pgsql.

Topics to cover

1. Subtle art of code conversion, conversion is art not matching code always.
2. Key difference in PostgreSQL that is unknown to all assessment tools but critical.
3. How to migrate not only for primary instance but for Read replicas as well
4. Key Differentiated feature of plpgsql and how to leverage it.
5. Leverage newer features added in PostgreSQL like alias, unique on null and more.
6. Avoid surprises around partitions like missing primary keys in partition columns and more.
7. Why not to Ignore nulls and empty string comparison and what impact it can bring.
8. How to Handle Packages in Oracle and how to accelerate its migrations.
9. Build Code planning and uncover dependency at start of projects.
10. Data type mapping and how to automate it using ora2pg. And more.

Key Takeaways for the participant

1. Understand pl\pgsql best practise from a migration perspective.
2. Uncover hidden caveats with code conversion.
3. Tips to accelerate code conversion.