18th January 2022
TIL
json_extract() path syntax in SQLite
— Several of the [SQLite JSON functions](), such as `json_extract()` and `json_array_length()`, take a path argument. This uses custom syntax along the lines of `$.a[2].b`, as described [in the documentation here](https://sqlite.org/json1.html#path_arguments).
Recent articles
- Claude's new system prompt really doesn't want to reproduce song lyrics - 2nd September 2026
- Claude Fable 5.1 made me a really nice animated pelican - 1st September 2026
- Understanding ChatGPT Work - 30th August 2026