Skip to content

Datasette 0.13: foreign key, search and filters
Compare
Choose a tag to compare
@simonw simonw released this 25 Nov 03:44
· 2484 commits to main since this release
0.13
c160f15

0.13 (2017-11-24)

  • Search now applies to current filters.

    Combined search into the same form as filters.

    Closes #133

  • Much tidier design for table view header.

    Closes #147

  • Added ?column__not=blah filter.

    Closes #148

  • Row page now resolves foreign keys.

    Closes #132

  • 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.

    Refs #86

  • Hide FTS-created tables on index pages.

    Closes #129

  • Add publish to heroku support [Jacob Kaplan-Moss]

    datasette publish heroku mydb.db

    Pull request #104

  • Initial implementation of ?_group_count=column.

    URL shortcut for counting rows grouped by one or more columns.

    ?_group_count=column1&_group_count=column2 works 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

    Refs #44

  • Added --build=master option to datasette publish and package.

    The datasette publish and datasette package commands both now
    accept an optional --build argument. If provided, this can be used
    to specify a branch published to GitHub that should be built into
    the container.

    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

  • Implemented ?_search=XXX + UI if a FTS table is detected.

    Closes #131

  • Added datasette --version support.

  • Table views now show expanded foreign key references, if possible.

    If a table has foreign key columns, and those foreign key tables
    have 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 inspect() function,
    which looks for any table that has just two columns - an ID column
    and one other - and sets the label_column to be that second non-ID
    column.

  • Don't prevent tabbing to "Run SQL" button (#117) [Robert
    Gieseke]

    See comment in #115

  • Add keyboard shortcut to execute SQL query (#115) [Robert
    Gieseke]

  • Allow --load-extension to be set via environment variable.

  • Add support for ?field__isnull=1 (#107) [Ray N]

  • Add spatialite, switch to debian and local build (#114) [Ariel
    Núñez]

  • Added --load-extension argument to datasette serve.

    Allows loading of SQLite extensions. Refs #110.

Assets 2
Loading