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: https://www.linkedin.com/company/prairie-postgres/
📅 Meetup: https://www.meetup.com/illinois-prairie-postgresql-user-group/

🎯 Don’t forget to:
👍 Like the video
💬 Comment your questions
🔔 Subscribe for more PostgreSQL talks, tutorials, and community events

Видео Setting up integration tests with PostgreSQL ft Doğaç Eldenk | September 10 2025 | канала Prairie Postgres