Plugins and internals
- New plugin hook: filters_from_request(request, database, table, datasette), which runs on the table page and can be used to support new custom query string parameters that modify the SQL query. (#473)
- Added two additional methods for writing to the database: await db.execute_write_script(sql, block=True) and await db.execute_write_many(sql, params_seq, block=True). (#1570)
- The db.execute_write() internal method now defaults to blocking until the write operation has completed. Previously it defaulted to queuing the write and then continuing to run code while the write was in the queue. (#1579)
- Database write connections now execute the prepare_connection(conn, database, datasette) plugin hook. (#1564)
- The
Datasette()constructor no longer requires thefiles=argument, and is now documented at Datasette class. (#1563) - The tracing feature now traces write queries, not just read queries. (#1568)
- The query string variables exposed by
request.argswill now include blank strings for arguments such asfooin?foo=&bar=1rather than ignoring those parameters entirely. (#1551)
Faceting
- The number of unique values in a facet is now always displayed. Previously it was only displayed if the user specified
?_facet_size=max. (#1556) - Facets of type
dateorarraycan now be configured inmetadata.json, see Facets in metadata.json. Thanks, David Larlet. (#1552) - New
?_nosuggest=1parameter for table views, which disables facet suggestion. (#1557) - Fixed bug where
?_facet_array=tags&_facet=tagswould only display one of the two selected facets. (#625)
Other small fixes
- Made several performance improvements to the database schema introspection code that runs when Datasette first starts up. (#1555)
- Label columns detected for foreign keys are now case-insensitive, so
NameorTITLEwill be detected in the same way asnameortitle. (#1544) - Upgraded Pluggy dependency to 1.0. (#1575)
- Now using Plausible analytics for the Datasette documentation.
explain query planis now allowed with varying amounts of whitespace in the query. (#1588)- New CLI reference page showing the output of
--helpfor each of thedatasettesub-commands. This lead to several small improvements to the help copy. (#1594) - Fixed bug where writable canned queries could not be used with custom templates. (#1547)
- Improved fix for a bug where columns with a underscore prefix could result in unnecessary hidden form fields. (#1527)