PostgreSQL PL/pgSQL Development Deep Dive
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!
We will conduct core foundation and considerations when building business logic using PL/pgSQL in PostgreSQL. Session will help application developers to build enterprise scale apps for business critical applications.
In the session we will cover following with samples to try out together as part of on-going trainings.
- PL/pgSQL Foundations
- What is Dollar Quoting and How PL/pgSQL Code is compiled or interpreted.
- Performance and Security Considerations.
- Importance and how to Conduct Code Sanity and Testing.
- Key Extensions as your development buddy.
- Procedure vs Functions Considerations.
- Custom Operators and Aggregator in PL\pgSQL
- and more..
Key takeways will help Database Developer Persona to have key considerations when building critical business logic within PostgreSQL.
- Date:
- Duration:
- 3 h 30 min
- Room:
- Conference:
- PGConf India, 2025
- Language:
- Track:
- Training
- Difficulty: