Accelerating PL/pgSQL Code Conversion on Migration from Another Database
Presented by:
Deepak Mahto
I am Deepak Mahto, with 15+ years of experience enjoying the challenge of solving complex database problems. I like to call myself your "Database Guy" with expertise in PostgreSQL and Oracle. Currently, I am the Founder of DataCloudGaze Consulting, where I help customers and partners succeed with migration to PostgreSQL.
Previously, I worked at Google Cloud and Amazon Web Services, assisting over 15+ Enterprise Customers in migrating from legacy commercial databases and facilitating the conversion of over 1 million lines of code to PostgreSQL.
I am active on social platforms and advocate for PostgreSQL, migrations, and database internals through my blog.
Social links :- LinkedIn, Twitter , Medium, Planet Postgres Blog, My Talks and More, PostgreSQL Training
No video of the event yet, sorry!
Most of the initial adopters of PostgreSQL are folks moving from another database and code conversion or PL/pgsql development is an critical path. In the session, I will walk through my curated learning I had moving 15+ enterprise customers and large code bases(> 1 million lines of codes) to PostgreSQL with PL/pgsql.
Topics to cover
Subtle art of code conversion, conversion is art not matching code always.
Key difference in PostgreSQL that is unknown to all assessment tools but critical.
How to migrate not only for primary instance but for Read replicas as well
Key Differentiated feature of plpgsql and how to leverage it.
Leverage newer features added in PostgreSQL like alias, unique on null and more.
Avoid surprises around partitions like missing primary keys in partition columns and more.
Why not to Ignore nulls and empty string comparison and what impact it can bring.
Build Code planning and uncover dependency at start of projects.
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.
Slide for reference.
- Date:
- Duration:
- 45 min
- Room:
- Conference:
- PGConf India, 2025
- Language:
- Track:
- Application Developer
- Difficulty:
- Medium