OpenTelemetry support, a new JavaScript API for creating modal dialogs, and several smaller bug fixes.
OpenTelemetry
Datasette now supports OpenTelemetry traces and metrics for monitoring application performance. Thanks, Alex Garcia. (#1730, #2867)
- Traces cover HTTP requests, database queries and startup, including time spent waiting for SQL threads and queued writes.
- Metrics report query latency, time-limit interruptions, SQL thread usage, write queues and open connections.
- New tools for plugin authors help plugins add their own traces and metrics, with shared registry classes and pytest helpers.
To collect telemetry, configure an OpenTelemetry SDK and exporter, then run Datasette using opentelemetry-instrument. See OpenTelemetry for setup instructions.
Other features
- New DatasetteModal JavaScript API for plugins to create dialogs with Datasette's shared styles, keyboard behavior and focus handling. Datasette's built-in dialogs use the same API. (#2790, #2948)
Bug fixes
- Table pages now show measured query timings instead of always displaying 1.2ms. (#2446)
- Facet loading now ignores unrelated query parameters such as
?_facets=x, instead of returning a 500 error. Thanks, Peng Boyu. (#2949) - Foreign key values no longer link to tables that do not exist. Thanks, Dipak Chaudhari. (#1515, #2952)
- Fixed missing punctuation between table and view counts on the homepage, such as
0 tables1view. Thanks, Dipak Chaudhari. (#2012, #2951) - The sort menu now excludes primary keys that are not included in sortable_columns. Thanks, Sanjay Santhanam. (#1980, #2858)