Weeknotes: Spinning back up on Datasette
25th May 2021
I’ve been somewhat distracted from Datasette for the past couple of months, thanks to my work on VIAL and the accompanying open source project django-sql-dashboard. This week I scraped back some time to work on Datasette.
?_facet_size=100
This was a feature suggestion by Marjorie Roswell. Datasette defaults to showing a maximum of 30 results for a requested facet, which can be inconvenient if you are faceting on something like U.S. states where you’d ideally like to see all 50 at once.
You can customize this with the default_facet_size setting, but now you can also customize it for a specific page using the new ?_facet_size=100
query string parameter. You can request up to max_returned_rows results, which defaults to 1000.
You can try this feature out, along with a bunch of dependency upgrades and a minor bug fix, in the new 0.57a0 alpha release.
apt-get install now works in the Docker container
The datasetteproj/datasette
Docker container had a bug in it where it was not possible to use apt-get install
to add extra packages to containers that used it as a base—a problem if you want to use a plugin such as datasette-ripgrep which depends on ripgrep
being available.
Brandon Roberts pointed this out along with a suggested fix, which I’ve adopted and will become available after the next non-alpha Datasette release.
Show/hide columns
I’m developing this in a branch at the moment, but I’m finally getting close to a fix for issue #615 (opened in November 2019) that will let the Datasette table view show and hide specific columns, using new ?_col=
and ?_nocol=
query string arguments. Here’s an animated demo of my work so far:
Releases this week
-
django-sql-dashboard: 0.15—(29 releases total)—2021-05-25
Django app for building dashboards using raw SQL queries -
datasette: 0.57a0—(86 releases total)—2021-05-23
An open source multi-tool for exploring and publishing data -
geojson-to-sqlite: 0.3.1—(7 releases total)—2021-05-20
CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
TIL this week
More recent articles
- Weeknotes: Llama 3, AI for Data Journalism, llm-evals and datasette-secrets - 23rd April 2024
- Options for accessing Llama 3 from the terminal using LLM - 22nd April 2024
- AI for Data Journalism: demonstrating what we can do with this stuff right now - 17th April 2024
- Three major LLM releases in 24 hours (plus weeknotes) - 10th April 2024
- Building files-to-prompt entirely using Claude 3 Opus - 8th April 2024
- Running OCR against PDFs and images directly in your browser - 30th March 2024
- llm cmd undo last git commit - a new plugin for LLM - 26th March 2024
- Building and testing C extensions for SQLite with ChatGPT Code Interpreter - 23rd March 2024
- Claude and ChatGPT for ad-hoc sidequests - 22nd March 2024
- Weeknotes: the aftermath of NICAR - 16th March 2024