Option in metadata.json to set default sort order for a table

[simonw]

If you access the table page without any ?_sort or ?_sort_desc arguments it currently defaults to order by primary key - would be neat to be able to change that.

[simonw]

I can solve #677 (The first time you click sort by ID it should show you results in reverse order) at the same time.

[simonw]

I'm going to mirror the URL syntax here, so the options in metadata.json will be:

• "sort": "created" to default sort by created
• "sort_desc": "created" to default sort by created descending

It will throw an error if you try to define both.

If I add the ability to sort by multiple columns in the future (#197) I can allow a list of columns here - though I'm not sure how I would represent "sort by created asc, title desc" in that case.

If you want to disable user-specified sorting you can do so using the existing "sortable_columns": [] mechanism.

[simonw]

Documentation: https://datasette.readthedocs.io/en/latest/metadata.html#setting-a-default-sort-order

[simonw]

Found a bug: if you click on a column with a default sort order applied to it you get: "Cannot use _sort and _sort_desc at the same time"

[simonw]

Shipped in 0.39: https://datasette.readthedocs.io/en/latest/changelog.html#v0-39