Technical deep dives into SQL, Python, and AI development. I document what I learn building with data and language models.
Join Python developers learning SQL — new tutorial every Monday
Learning Paths
Forging the Truth
Command line for the AI era. The terminal window is a powerful tool that lets you quickly verify what LLMs tell you that they have done
SQL for Python Developers
Learn SQL fundamentals using DuckDB and Python. A practical series for Python developers who want to level up their data skills.
I Vibe Coded and Lived to Tell
What happens when you build real AI tools with AI writing the code? Chaos mostly, but also hard-won lessons about what small models can and can't do.
AWS Data Engineer Associate Certification
My honest, unfiltered experience studying for and taking the AWS Certified Data Engineer – Associate exam. The wins, the setbacks, and everything I learned along the way.
Latest Articles
Optimizing Queries: EXPLAIN for Python Developers
Read EXPLAIN output to understand why queries are slow. Learn when to add indexes and when to stop worrying about performance.
Modifying Data Safely
INSERT, UPDATE, and DELETE with guardrails. Always use WHERE, test with SELECT first, and use transactions to undo mistakes.
Two Sentences
Giving an LLM the keys to your wiki is not a dramatic handoff. It looks like maintenance done quietly, completely, every time.
Creating Tables: DDL for Python Devs
Map Python types to SQL types. Learn CREATE TABLE with primary keys, foreign keys, and constraints like NOT NULL and DEFAULT.
Window Functions: The Feature Python Developers Miss Most
Calculate across rows without collapsing them. Running totals, rankings, and row comparisons that GROUP BY can't do.