21st April 2020
TIL
Null case comparisons in SQLite
— I wanted to say "output this transformed value if it's not null, otherwise nothing". The recipe I figured out was:
Recent articles
- Kimi K3, and what we can still learn from the pelican benchmark - 16th July 2026
- The new GPT-5.6 family: Luna, Terra, Sol - 9th July 2026
- sqlite-utils 4.0, now with database schema migrations - 7th July 2026