Pattern Portfolio

Menu patterns

Header for /database/table/row and Messages

Example message

Example message

Example message

.bd for /

Datasette Fixtures

An example SQLite database demonstrating Datasette

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

fixtures

1,258 rows in 24 tables, 206 rows in 5 hidden tables, 4 views

compound_three_primary_keys, sortable, facetable, roadside_attraction_characteristics, simple_primary_key, ...

data

6 rows in 2 tables

names, foo

.bd for /database

fixtures

{% with action_title="Database actions", action_menu_id="pattern-database-actions", action_links=[{"label": "Action one", "href": "#"}, {"label": "Action two", "href": "#"}] %} {% include "_action_menu.html" %} {% endwith %}
Test tables description

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

Custom SQL query

123_starts_with_digits

content

0 rows

Table With Space In Name

pk, content

0 rows

attraction_characteristic

pk, name

2 rows

.bd for /database/table

roadside_attraction_characteristics

{% with action_title="Table actions", action_menu_id="pattern-table-actions", action_links=[{"label": "Action one", "href": "#"}, {"label": "Action two", "href": "#"}] %} {% include "_action_menu.html" %} {% endwith %}

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

3 rows where characteristic_id = 2

Clear filters

2 extra where clauses

View and edit SQL
roadside_attraction_characteristics

Filtered rows where characteristic_id = "2"

TSV All 2 rows
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 2 rows
Comma-separated values, for spreadsheets and other tools
  • JSON All 2 rows
    Rows inside an object, with extra details
    View Download
  • JSON array All 2 rows
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 2 rows
    One JSON object per line
    View Download

Suggested facets

tags array 3

created date >2

city_id 2

Link rowid ▼ attraction_id characteristic_id
1 1 The Mystery Spot 1 Paranormal 2
2 2 Winchester Mystery House 2 Paranormal 2
3 3 Bigfoot Discovery Museum 4 Paranormal 2 
CREATE TABLE roadside_attraction_characteristics (
    attraction_id INTEGER REFERENCES roadside_attractions(pk),
    characteristic_id INTEGER REFERENCES attraction_characteristic(pk)
);

.bd for /database/table/row

roadside_attractions: 2

pk name address latitude longitude
2 Winchester Mystery House 525 South Winchester Boulevard, San Jose, CA 95128 37.3184 -121.9511

Links from other tables

.ft