Got 1,493 results, sorted by newest / oldest
Release: django-sql-dashboard 0.8a2
Correctly sign ?sql= on redirects created using DASHBOARD_UPGRADE_OLD_BASE64_LINKS. #68
Release: django-sql-dashboard 0.8a1
Fixed bug with DASHBOARD_UPGRADE_OLD_BASE64_LINKS setting. #67
Release: django-sql-dashboard 0.8a0
Make it easy to provide a custom base template. #7 Content-Security-Policy: frame-ancestors header. #64 Signing no longer uses base64/json. #45 DASHBOARD_UPGRADE_OLD_BASE64_LINKS mechanism. #65
Release: django-sql-dashboard 0.7a0
SQL textarea now always has at least 5 rows Always strip trailing ; from SQL, fixing bug with "count" links. #56 URLize links in results. #61
Release: airtable-export 0.7.1
Fixed bug with new --http-read-timeout feature
Release: django-sql-dashboard 0.6a0
Fix for bug with columns with identical names. #52 DASHBOARD_ROW_LIMIT setting. #53 Size SQL textarea to fit SQL. #51
Release: airtable-export 0.7
New --http-read-timeout option, thanks Eli Block! #14
Render single selected county on a map Another experiment at the intersection of Datasette and Observable notebooks. This one imports a full Datasette table (3,200 US counties) using streaming CSV and loads that into Observable's new Search and Table filter widgets. Once you select a single county a second Datasette SQL query (this time retuning JSON) fetches a GeoJSON representation of that ...
Last week I mentioned that I've recently started scraping and storing the CDC's per-county vaccination numbers in my cdc-vaccination-history GitHub repository. This week I used an Observable notebook and d3's TopoJSON support to render those numbers on an animated choropleth map. The full code is available at https://observablehq.com/@simonw/us-county-vaccinations-choropleth-map From scraper to D...
Release: airtable-export 0.6
New --user-agent= option for passing a custom user-agent to Airtable. #12
Release: datasette 0.56
Documentation improvements, bug fixes and support for SpatiaLite 5. The SQL editor can now be resized by dragging a handle. (#1236) Fixed a bug with JSON faceting and the __arraycontains filter caused by tables with spaces in their names. (#1239) Upgraded httpx dependency. (#1005) JSON faceting is now suggested even if a column contains blank strings. (#1246) New datasette.add_memory_database() m...
This week I got SpatiaLite 5 working in the Datasette Docker image, improved the CDC vaccination history git scraper, figured out Datasette on Azure and we closed on a new home! SpatiaLite 5 for Datasette SpatiaLite 5 came out earlier this year with a bunch of exciting improvements, most notably an implementation of KNN (K-nearest neighbours) - a way to efficiently answer the question "what are t...
Release: datasette-publish-vercel 0.9.3
Better error message for --project that contains uppercase characters. #37 Documentation on usage with GitHub Actions. #36
Release: sqlite-transform 0.5
--dayfirst and --yearfirst options for parsedate and parsedatetime commands. #12
Release: django-sql-dashboard 0.5a0
Link to dashboard from admin edit page. #48 Better error message for queries with % that needs to be escaped. #41
Release: tableau-to-sqlite 0.2.1
Pin underlying version of TableauScraper library to avoid problems caused by breaking changes. #4
The Accountability Project Datasettes The Accountability Project "curates, standardizes and indexes public data to give journalists, researchers and others a simple way to search across otherwise siloed records" - they have a wide range of useful data, and they've started experimenting with Datasette to provide SQL access to a subset of the information that they have collected.
Release: django-sql-dashboard 0.4a2
Removed unnecessary migration dependency, so this should now install on versions of Django prior to 3.1. Thanks, @jefftriplett. #46
Release: django-sql-dashboard 0.4a1
Serve cache-control: private HTTP header on private dashboards. #43
Release: datasette-publish-vercel 0.9.2
Upgraded to latest @vercel/python builder, fixing a number of bugs involving incorrectly handled querystring characters. #28
Release: datasette-auth-passwords 0.4
Optional support for HTTP Basic authentication. #15
Release: django-sql-dashboard 0.4a0
Documentation now lives at https://django-sql-dashboard.readthedocs.io/ (#36) Ability to copy and paste TSV from the default table display. (#29) Fixed two bugs with the way count links in column headers work. (#31, #32) New permissions system: a saved dashboard can now be made public, private, unlisted, group-only, staff-only or superuser-only. (#27)
Release: django-sql-dashboard 0.3a1
Changed default permission policy: saved dashboards are now inaccessible to the public by default (#37). This will change when permissions are implemented fully in #27.
Release: django-sql-dashboard 0.3a0
Added basic bar chart widget. #10 Added markdown widget. #12 Added html widget. #12
Release: django-sql-dashboard 0.2a2
Bundle widget templates in release.
Release: django-sql-dashboard 0.2a1
Fix for bug where templatetags were not bundled in the release package. #22
Release: django-sql-dashboard 0.2a0
Run tests against read-only 'dashboard' connection, refs #18 Named SQL parameters are now extracted into form fields. #15 Configure URLs using include() pattern. #14 ?sql= params are now signed, must first be created using a POST request. #13 New custom widgets framework #20 Big number widget for displaying a big number. #20
Release: hacker-news-to-sqlite 0.4
Progress display now shows the total as well as the number currently in the queue. % hacker-news-to-sqlite trees hn.db 26440397 done: 1, in queue: 0, total: 1 done: 2, in queue: 28, total: 30 done: 3, in queue: 27, total: 30
Release: django-sql-dashboard 0.1a3
Include templates and migrations in the release. #4
Release: django-sql-dashboard 0.1a2
Workaround for psycopg2 dependency bug on macOS. #3
Release: django-sql-dashboard 0.1a
Initial working alpha.
Django app for building dashboards using raw SQL queries django-sql-dashboard Django app for building dashboards using raw SQL queries Brings a useful subset of Datasette to Django. Currently only works with PostgreSQL. This is very early alpha. You should not yet trust this code, especially with regards to security. Do not run this in production (yet)! Documentation Full documentation is at djang...
Release: datasette-ripgrep 0.7
Use white-space: pre-wrap when displaying lines, so lines now wrap. #21 Long lines in results are now truncated, with a [...] link to expand them to full length. #22
Release: tableau-to-sqlite 0.2
Support importing data from a full URL to a Tableau dashboard hosted somewhere other than public.tableau.com. #2
Release: tableau-to-sqlite 0.1.1
No longer produces tables with single quotes in the name, which can cause bugs when viewed in Datasette. #1
Release: tableau-to-sqlite 0.1
First working version.
Fetch data from Tableau into a SQLite database tableau-to-sqlite Fetch data from Tableau into a SQLite database. A wrapper around TableauScraper. Installation Install this tool using pip: $ pip install tableau-to-sqlite Usage If you have the URL to a Tableau dashboard like this: https://results.mo.gov/t/COVID19/views/VaccinationsDashboard/Vaccinations You can pass that directly to the tool: t...
This week I virtually attended the NICAR data journalism conference and made a ton of progress on the Django backend for VaccinateCA (see last week). NICAR 2021 NICAR stands for the National Institute for Computer Assisted Reporting - an acronym that reflects the age of the organization, which started teaching journalists data-driven reporting back in 1989, long before the term "data journalism" b...
This week I got involved with the VaccinateCA effort. We are trying to end the pandemic a little earlier, by building the most accurate database possible of vaccination locations and availability in California. VaccinateCA I’ve been following this project for a while through Twitter, mainly via Patrick McKenzie - here’s his tweet about the project from January 20th. https://t.co/JrD5mb4TAN calls...