Daily Dose of Data Science

Daily Dose of Data Science

Home
Sponsor
Premium
Archive
Leaderboard
About

SQL

Big moment for Postgres!
A 100% open-source solution that fixes a major issue with AI coding Agents.
 • Avi Chawla
Semi, Anti, and Natural Joins in DuckDB SQL
Exploring three more elegant SQL Joins.
 • Avi Chawla
Use SQL "NOT IN" With Caution
An unexpected error that can take hours to debug.
 • Avi Chawla
GROUPING SETS in SQL
A lesser-known way to run multiple aggregations.
 • Avi Chawla
Grouping Sets, Rollup and Cube in SQL
Three lesser-known grouping operations.
 • Avi Chawla
15 Pandas ↔ Polars ↔ SQL ↔ PySpark Translations
Become a Quadrilingual Data Scientist.
 • Avi Chawla
What are Semi, Anti, and Natural Joins in SQL?
Exploring three more elegant SQL Joins.
 • Avi Chawla
Deepnote: The AI-Powered Jupyter Notebook That Data Scientists Were Looking For
A 20x better Jupyter notebook experience.
 • Avi Chawla
A Silent Mistake That Many SQL Users Commit and Take Hours to Debug
...and 2 ways to avoid it.
 • Avi Chawla
GROUPING SETS — A HIGHLY Underrated Technique to Run Multiple Aggregations While Scanning the Table Only Once
A lesser-known and much efficient way to run multiple aggregations.
 • Avi Chawla
Vanna: The Supercharged Text-to-SQL Tool All Data Scientists Were Looking For
Write complex SQL in seconds.
 • Avi Chawla
Become a Trilingual Data Scientist with These 15 Pandas ↔ Polars ↔ SQL Translations
Pandas to Polars to SQL translations in a single frame.
 • Avi Chawla
© 2026 Avi Chawla · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture