Postgres & DuckDB with Josef Machytka

Postgres Meetup for All Jan 8th recording. This talk explores how can DuckDB enhance PostgreSQL workflows for ad-hoc data analysis, ETL processes, cross-database queries, rudimentary migrations and similar tasks. By leveraging DuckDB’s lightweight and efficient architecture, users can simplify complex tasks without the need for extensive setup or specialized tools. Attendees will learn practical techniques to supercharge their data workflows using DuckDB extensions and Python scripts. The focus is on showcasing how DuckDB provides powerful yet very simple solutions for improving agility and productivity in data tasks. Key Takeaways: Small Data Manifesto as the new trend in Data Analysis Understanding of of the main features of DuckDB, its strengths and weaknesses Usage of DuckDB as an very efficient enhancement tool for PostgreSQL Optimization of analytical workload by combining PostgreSQL and DuckDB