Fixing SQL Spaghetti : Effective Refactoring Techniques
2024/06/13Lindsay 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
00: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
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
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