Simon Willison

Replace "datasette publish --extra-options" with "--setting"

9

See https://github.com/simonw/datasette-publish-now/issues/9#issuecomment-618155764 - the `--extra-options` mechanism is in practice just used to set `--config` options in data that you publish, but that means you end up with pretty messy looking...

Triggered this error while playing with the sort desc checkbox and the apply button that are only visible on this page at mobile screen width: https://latest.datasette.io/fixtures/compound_three_primary_keys?_sort_desc=pk1 Navigate to that page...

Research: demonstrate if parallel SQL queries are worthwhile

31

I added parallel SQL query execution here: - https://github.com/simonw/datasette/issues/1723 My hunch is that this will take advantage of multiple cores, since Python's `sqlite3` module releases the GIL once a query...

Implement ?_extra and new API design for TableView

12

Part of: - #262 - #1518

In #1727 I realized that the SQL tracing was measuring a whole bunch of stuff outside of the SQL query itself. I started experimenting with this fix for that but...

A page talking about how to run Datasette securely, and security concerns to take into account.

Trace from https://latest-with-plugins.datasette.io/github/commits?_facet=repo&_trace=1&_facet=committer  What's going on in that gap? Can I improve the tracing output to show some non-SQL queries to figure that out?

Noticed this while working on: - #1715 This code here isn't showing up in traces: https://github.com/simonw/datasette/blob/579f59dcec43a91dd7d404e00b87a00afd8515f2/datasette/views/table.py#L218-L220 Because those functions don't use the regular trace-instrumented `db.execute()` code path - they work...

Implement plugin hooks: `register_table_extras`, `register_row_extras`, `register_query_extras`

1

Designed in: - #1720 Part of: - #262 - #1709

Add ?_extra= mechanism for requesting extra properties in JSON

27

Datasette views currently work by creating a set of data that should be returned as JSON, then defining an additional, optional `template_data()` function which is called if the view is...