pg_duckdb: Postgres analytics just got faster with DuckDB
2024/10/25Postgres analytics 10x faster?! đŸ¤¯ pg_duckdb is here! This open-source extension adds DuckDB's analytics to Postgres, supporting Parquet, CSV, Iceberg reads, and direct MotherDuck queries—all within Postgres!
Related Videos
08:48
2024-12-11
Why web developers should care about analytical databases
You often start your web application with an OLTP database like Postgres, but should you crunch your analytics there? In this video, ‪Mehdi explains what OLAP databases are, when to use them, and more.
YouTube
Wasm
SQL
33:49
2024-11-08
A duck in the hand is worth two in the cloud
What if I told you that you could complete a JSON parse and extract task on your laptop before a distributed compute cluster even finishes booting up?
YouTube
BI & Visualization
AI, ML and LLMs
SQL
Python
Talk
1:03:13
2024-06-13
Fixing SQL Spaghetti : Effective Refactoring Techniques
Lindsay Murphy and Mehdi tackle a big challenge for data professionals: dealing with old SQL scripts. How can we make messy SQL code easier to read and maintain? We'll discuss pragmatics things you can do, and we'll tackle an example.
YouTube
Quack & Code
SQL