Jamal Hansen

Hi, I'm Jamal Hansen

I write for developers who know one thing well and are learning the next one. SQL to Python. Python to AI. Local tools to production systems.


New here? Start here, or jump into:

Get new posts by email — plus what I’m reading and building

Latest writing

An empty concrete chess table with two metal chairs on a brick plaza
6 min readHow I Work With AI

I Got Tired of Explaining Myself

Why I stopped writing better prompts and started treating an AI like a new member of my team: write it down once instead of explaining it every time.

A green seedling growing up through dried leaves and wood mulch
7 min readNotes and Knowledge

Six Months of an LLM-Maintained Wiki

I ran a Karpathy-style LLM-maintained wiki for six months. What compounded, what didn't, and the 614 notes I archived.

Title slide: Go Hybrid, Find the Results LIKE Can't
1 min read

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.

A solitary figure stands on a cliff edge overlooking a vast, hazy canyon at sunrise or sunset.
6 min readSQL for Python Developers

Congratulations! What You Can Do Now

Celebrate your new skills with take-home challenges and resources for continued learning. You think in sets now.

A rustic wooden table displays a meal with roasted meats, rice, and various dishes.
6 min readSQL for Python Developers

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.