YouTubeQuack & CodeSQL

Fixing SQL Spaghetti : Effective Refactoring Techniques

2024/06/13

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.

Related Videos

YouTube video preview

00:14:18

2024-10-25

pg_duckdb: Postgres analytics just got faster with DuckDB

Postgres 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!

YouTube

Ingestion

SQL

Ecosystem

YouTube video preview

2024-09-24

A new paradigm for data visualization with just SQL + Markdown

Come to this Quack&Code where Mehdi will discuss data visualization with DuckDB/MotherDuck, specifically focusing on Evidence! Archie, who is building evidence.dev, will join us to share his wisdom on charts ;-)

BI & Visualization

YouTube

Quack & Code

YouTube video preview

50:57

2024-08-21

Moving Forward from Ad Hoc Reports with DuckDB and MotherDuck

Learn about ad hoc reporting with DuckDB from experts Mehdi Ouazza and Jacob Matson, creator of the MDS-in-a-Box.

YouTube

BI & Visualization

Quack & Code