Setting up integration tests with PostgreSQL ft Doğaç Eldenk | September 10 2025 |
Learn how to efficiently reset your PostgreSQL database between integration tests without slowing down your development workflow. In this talk, we introduce a scalable and language-agnostic approach using PL/pgSQL to maintain fast, consistent, and reliable test environments.
Whether you're a backend developer, data engineer, or working with automated testing pipelines, this session will help you improve test performance and eliminate flaky test data issues.
🚀 What You’ll Learn:
Best practices for resetting PostgreSQL databases between tests
Why traditional cleanup methods (truncate/drop) can slow you down
How to use PL/pgSQL functions, triggers, and procedures for automation
Techniques to ensure consistent and isolated test environments
Boosting integration test speed and reliability
👨💻 Who Should Watch:
PostgreSQL Developers
Backend Engineers
QA / Test Engineers
DevOps & Data Engineers
Anyone working with database-driven applications
🔗 Stay Connected with Prairie Postgres:
🌐 Website: https://prairiepostgres.org/
💻 GitHub: https://github.com/prairiepostgres
💼 LinkedIn: / prairie-postgres
📅 Meetup: https://www.meetup.com/illinois-prair...
🎯 Don’t forget to:
👍 Like the video
💬 Comment your questions
🔔 Subscribe for more PostgreSQL talks, tutorials, and community events