Search now applies to current filters.
Combined search into the same form as filters.
Much tidier design for table view header.
Row page now resolves foreign keys.
Further tweaks to select/input filter styling.
Refs [#86]() - thanks for the help, @natbat!
Show linked foreign key in table cells.
Added UI for editing table filters.
Hide FTS-created tables on index pages.
Add publish to heroku support [Jacob Kaplan-Moss]
datasette publish heroku mydb.db
Pull request [#104]()
Initial implementation of
URL shortcut for counting rows grouped by one or more columns.
?_group_count=column1&_group_count=column2works as well.
SQL generated looks like this:
select "qSpecies", count(*) as "count" from Street_Tree_List group by "qSpecies" order by "count" desc limit 100
Or for two columns like this:
select "qSpecies", "qSiteInfo", count(*) as "count" from Street_Tree_List group by "qSpecies", "qSiteInfo" order by "count" desc limit 100
--build=masteroption to datasette publish and package.
datasette packagecommands both now
accept an optional
--buildargument. If provided, this can be used
to specify a branch published to GitHub that should be built into
This makes it easier to test code that has not yet been officially
released to PyPI, e.g.:
datasette publish now mydb.db --branch=master
?_search=XXX+ UI if a FTS table is detected.
Table views now show expanded foreign key references, if possible.
If a table has foreign key columns, and those foreign key tables
label_columns, the TableView will now query those other
tables for the corresponding values and display those values as
links in the corresponding table cells.
label_columns are currently detected by the
which looks for any table that has just two columns - an ID column
and one other - and sets the
label_columnto be that second non-ID
Don't prevent tabbing to "Run SQL" button ([#117]()) [Robert
See comment in [#115]()
Add keyboard shortcut to execute SQL query ([#115]()) [Robert
--load-extensionto be set via environment variable.
Add support for
?field__isnull=1([#107]()) [Ray N]
Add spatialite, switch to debian and local build ([#114]()) [Ariel
--load-extensionargument to datasette serve.
Allows loading of SQLite extensions. Refs [#110]().