Skip to content
0:00 / 0:00

#postgresql#jsonb#listennotify

When Postgres is enough: solving document storage, pub/sub and distributed queues without more tools

PyData

173K subscribers • 11 videos on Hallway

YouTube
  • Recommended by 1 person: 1 in engineering communities.
  • Presented by Eugen Geist, Software Engineer
  • An opinion. It argues one side of a question engineers disagree on.

Intermediate. Assumes working knowledge.

800 views11 months ago1 recommendation

Databases and dataSoftware designPostgresSimplicity and complexitySoftware architecture

Eugen Geist demonstrates how to use PostgreSQL native features like JSONB, LISTEN/NOTIFY, and SKIP LOCKED to replace MongoDB, Kafka, and Redis.

🔊 Recorded at PyData Berlin 2025, 2025.pycon.de/program/FDBZSR/ 🎓 Discover how PostgreSQL can replace MongoDB, Kafka, and Redis—keeping your stack simpler and your team focused on solving real problems. Speakers: Eugen Geist Description: Software engineer Eugen Geist challenges the impulse to add specialized tools for every new requirement. Instead of reaching for MongoDB for document storage, Kafka for pub/sub, or Redis for queuing, he demonstrates how PostgreSQL's native features can handle these use cases effectively. The talk covers practical implementations using LISTEN/NOTIFY for pub/sub messaging, SELECT FOR UPDATE SKIP LOCKED for distributed queues, and JSONB for flexible document storage. Geist also introduces vector extensions for AI workloads. Through live Python and SQL demonstrations, he shows how these patterns work in real projects. The message isn't that PostgreSQL replaces everything forever, but that it can delay the need for specialized infrastructure until truly necessary. For freelancers, startups, and small teams, this approach means faster iteration, fewer operational headaches, and lower costs. By leveraging existing PostgreSQL installations, teams can focus on solving business problems rather than maintaining complex infrastructure stacks. ⭐️ About PyData Berlin: Since 2014, PyData Berlin has brought together the international Python and data community. With monthly meetups and a yearly conference, it connects data engineers, scientists, and tool-builders to share ideas, explore open-source technologies, and drive innovation together. Follow us: • LinkedIn: linkedin.com/company/pydata-berlin/ • X: x.com/pydataber Links: • Conference website: berlin.pydata.org/ • Other sessions: berlin.pydata.org/conferences/2025/ The conference is organized by • NumFOCUS Inc.: numfocus.org • Pioneers Hub gemeinnützige GmbH: pioneershub.org If you enjoyed this session, please like, comment, and subscribe to our channel for more insightful talks and discussions. Share this video with your network to spread the knowledge! Hashtags: #Python #PyConDE #PyData #OpenSource #AI #DataScience #MachineLearning #SoftwareDevelopment #LLMs #Community Acknowledgements: Special thanks to all the volunteers and sponsors who made this event possible. About: NumFOCUS Inc. supports open-source scientific computing by providing financial and logistical support to key projects like NumPy and Jupyter, promoting sustainable development and collaboration. Pioneers Hub gemeinnützige GmbH: is a non-profit fostering innovation in AI and tech by connecting experts and promoting knowledge exchange through events and collaborative initiatives.

Why it's here

1 person recommends this

What people say. Recommended as one of the top PostgreSQL conference talks of 2025.

u/TechTalksWeeklyin r/PostgreSQL • Recommends

The Awesome List Of Postgres Conference Talks & Podcasts Of 2025 Hello r/postgres! As part of Tech Talks Weekly newsletter, I put together an awesome list of Postgres conference talks & podcasts published in 2025 (so far). This list is based on what popped up in my newsletter throughout the year and I hope you like it! # Conference talks *Ordered by view count* 1. [**"You don't need Elasticsearch! Fuzzy Search with PostgreSQL and Spring Data by Thomas Gräfenstein"**] ⸱ **+7k views** ⸱ 02 Sep 2025 ⸱ 00h 42m 23s 2. **"Bulk data processing and PostgreSQL thingy by Yingkun Bai"** ⸱ **+1k views** ⸱ 20 Jan 2025 ⸱ 00h 51m 58s 3. [**"How to accelerate GenAI projects using Knowledge Bases On P…