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.
Duckdb
(All) Databases Are Just Files. Postgres Too.
DuckDB's file-native design is a first-class feature, not a limitation. File-native is good design. This article makes that clearer by pulling back the curtain...
Don't forget to save! Persisting your DuckDB database
Your in-memory database disappears when Python exits. Let's fix that with a one-line change that saves everything to disk.
Generate Practice Data with faker
Real SQL practice needs real-looking data. Generate hundreds of customers with Python's Faker library without downloading a single CSV
Zero-Setup SQL: Run your first SQL query in under 5 minutes with DuckDB
Install DuckDB with pip, create your first table, insert data, and run a SQL query - all in Python, all in under 5 minutes, zero configuration required
I know Python; Why learn SQL
Learning SQL makes you a better Python developer, even if you use pandas and ORMs. The first post in a series that teaches it with DuckDB and Python.