{
  "@context":[
    "https://www.w3.org/ns/activitystreams",
    {"Hashtag":"as:Hashtag"}
  ],
  "published":"2024-07-02T13:22:56.710Z",
  "attributedTo":"https://k.matthias.org/actors/relistan",
  "to":["https://www.w3.org/ns/activitystreams#Public"],
  "cc":["https://k.matthias.org/actors/relistan/followers"],
  "content":"<p>I just realized today that <a href=\"https://www.sqlite.org/json1.html#jex\">SQLite actually has `json_extract()`!</a> This is potentially pretty huge for one of our use cases. Combined with <a href=\"https://www.sqlite.org/expridx.html\">indexes on expressions</a>, this is pretty powerful. I use json_extract() all the time on Athena and Trino. Didn't realized SQLite had it.</p>",
  "mediaType":"text/html",
  "attachment":[],
  "type":"Note",
  "id":"https://k.matthias.org/objects/tVnQZqNIyGQ"
}