Go Hybrid: Find the Results LIKE Can't
Companion page for my PyOhio 2026 talk. Slides, code, and the dog-spa dataset for searching free text beyond LIKE with BM25, vectors, and hybrid.
Sql
Congratulations! What You Can Do Now
Celebrate your new skills with take-home challenges and resources for continued learning. You think in sets now.
Advanced SQL Topics Sampler
Quick tastes of CASE statements, JSON functions, date manipulation, set operations, and recursive CTEs. Enough to know what to learn next.
The Makefile was Lying to Me
Gemini saw a wall of green checkmarks and declared 27 tools verified. The Makefile printed FAIL and exited 0. How we made it loud, annoying and honest.
Testing SQL Code
Test queries like Python code using in-memory databases, fixtures, and pytest. Fresh data per test, no state leakage.
ORM vs Raw SQL: Decision Framework
It's not either/or. Use ORMs for CRUD and migrations; use raw SQL for analytics and complex queries. A practical decision guide.
Parameterized Queries & Security
String formatting in SQL is dangerous. Learn parameterized queries to keep user input safe and prevent SQL injection attacks.
Python + DuckDB: Real ETL Patterns
Build a complete pipeline - fetch from an API, load into DuckDB, transform with SQL, export results. A capstone putting it all together.
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.