datasette-ui-extras 0.16

Adds UI enhancements to Datasette

datasette-ui-extras

This plugin aims to be a batteries-included theme that makes Datasette more like a self-hosted Airtable or Notion.

You can share read-only access, while still allowing authenticated users to edit data.

You can see a demo at https://dux-demo.fly.dev/

The plugin tries to use stable Datasette hooks where possible. Some of the features I add aren't natively extensible. In those cases, I do some shenanigans. I try to exercise good judgment so that we can fail gracefully if Datasette makes a breaking change.

Installation

Install this plugin in the same environment as Datasette.

datasette install datasette-ui-extras

Usage

The current version of the plug-in only adds read-only features.

A future version will have configuration knobs to permit read-write of existing tables.

Features

Writing

In progress.

Reading / browsing

The plugin tries to emphasize your data, and de-emphasize any other chrome.

• Tables have sticky headers so you can keep track of columns while scrolling big data sets.

• Facets are rendered in a sidebar, lazy loaded after your core table has been shown.

• The human description for '=' and '!=' against a column that is a foreign key includes the label of the foreign row.

• New facet types:

  • facet by year (2022)
  • facet by year/month (2022-10)
  • statistical summary (min, median, p90, p95, p99, max)

• Pressing / focuses the search box.

• When viewing a single entry's page, we render the data as a vertical column, with one attribute per row.

• Mobile column options: Click the column name to see the column options, for sorting and faceting.

• JSON arrays of strings are displayed as a comma-separated list.

• JSON arrays of strings are 3x faster to filter and 4x faster to facet.

• Advanced export: This control is hidden by default. Click the (Advanced) link to see it.

• Filters: These controls are hidden by default. Click the funnel icon to see them.

• Suggested facets: We no longer suggest facets. Instead, use the cog menu on the column to add facets.

• Table/view definitions: These are hidden.

Development

To set up this plugin locally, first checkout the code. Then create a new virtual environment:

cd datasette-ui-extras
python3 -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest