Explore a conference talk that delves into PostgreSQL's evolution as a powerful alternative to NoSQL databases. Learn about the latest updates in traditional RDBMS systems, including PostgreSQL's enhanced JSON support, improved scalability features like table partitioning and query parallelism, and a new pub/sub framework. Discover how PostgreSQL has implemented advanced functionalities such as a quorum system for data sync and improved window functions for better time series queryability. Gain insights into how these new features are being utilized in real-world applications at Clever Cloud. Examine topics including Big Data, NoSQL, JSON indexing, multiple extensions, and logic replication to understand why PostgreSQL is becoming a compelling choice for modern database needs.
Overview
Syllabus
Intro
Big Data
NoSQL
PostgreSQL
Why NoSQL
JSON
Index
Workaround
Multiple extensions
Logic replication
Taught by
Devoxx