Ability to set custom default _size on a per-table basis

[simonw]

I have some tables where I'd like the default page size to be 10, without affecting the rest of my Datasette instance.

[simonw]

Relevant code:

datasette/datasette/views/table.py

Lines 519 to 520 in 07e208c

	# Handle ?_size=500
	page_size = _size or request.raw_args.get("_size")

[simonw]

Syntax suggestion:

{
    "databases": {
        "mydatabase": {
            "tables": {
                "example_table": {
                    "sort": "created",
                    "size": 10
                }
            }
        }
    }
}

[simonw]

I'm calling it "size" for consistency with the querystring parameter _size=, even though "page_size" might be a more accurate name.

[simonw]

Documentation: https://datasette.readthedocs.io/en/latest/metadata.html#setting-a-custom-page-size