Elektrine lite

← Feed

@ham_jansen@mastodon.online

2026-03-02 14:42 UTC

Every query in SQL for Python Devs returned all the rows. That's fine for learning, but it's wasting bandwidth and processing power. WHERE filters rows before they ever leave the database. It's the SQL equivalent of Python's list comprehension if clause: [c for c in customers if c['is_premium']] This week covers WHERE and its friends AND, OR, IN, BETWEEN, LIKE, and the quirky IS NULL syntax. https://jamalhansen.com/blog/where-filtering-your-data #SQL #Python #DuckDB #DataScience #Programming

Replies (0)

No replies.