Schedule - PGDay/MED 2024
PostgreSQL is all you need
Date: 2024-12-05
Time: 11:15–12:05
Room: Positano
PostgreSQL is often considered "just" a relational database, but this view significantly underestimates its potential. This talk will explore how PostgreSQL can be used far beyond its traditional role, transforming into a versatile Swiss Army knife for our architectures.
Through practical examples and real-world use cases, we'll discover how PostgreSQL can effectively: - Handle data normalization from legacy systems through Change Data Capture (CDC) - Act as an Event Store for domain event persistence - Function as a reliable message queue using LISTEN/NOTIFY
We'll see how, by leveraging triggers, LISTEN/NOTIFY, and PostgreSQL's native features, it's possible to implement complex architectural patterns without introducing additional infrastructure components. This approach not only simplifies the overall architecture but also reduces operational and maintenance costs.
Throughout the session, we'll explore practical implementations and live coding examples that showcase these concepts in action, highlighting both the challenges and the solutions in real-world scenarios.
Whether you're building a new application or modernizing a legacy system, this talk will show you how to leverage PostgreSQL's hidden capabilities to create elegant and efficient solutions.
Takeaways: - Understanding of some PostgreSQL's advanced capabilities - Practical patterns for data normalization and CDC implementation - Strategies for implementing Event Store and message queues - Best practices for using PostgreSQL in unconventional scenarios