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
- The new GPT-5.6 family: Luna, Terra, Sol - 9th July 2026
- sqlite-utils 4.0, now with database schema migrations - 7th July 2026
- sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25) - 5th July 2026