issue_comments: 709509635

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/datasette/issues/894#issuecomment-709509635 https://api.github.com/repos/simonw/datasette/issues/894 709509635 MDEyOklzc3VlQ29tbWVudDcwOTUwOTYzNQ== 9599 2020-10-15T18:24:57Z 2020-10-15T18:24:57Z OWNER

This does feel like a weird plugin hook just because there aren't really THAT many different use-cases that plugins could solve. The ones I can think of are:

  • Sort numeric
  • Sort by parsed date
  • Sort by FTS rank

Could this work if I just allow _sort_clause=?

One possible solution for the no-arbitrary-SQL case: users can define sort orders in metadata.json/yml. So if you want to enable sort-by-distance without enabling arbitrary SQL you could add something like this:

yaml databases: mydb: tables: museums: sort_clause: bm25(fts)

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 657572753