653 rows

View and edit SQL

Suggested facets: date (date), published_at (date)

rowid repo release date body_markdown published_at topics
195087137 https://github.com/simonw/datasette-auth-github https://github.com/simonw/datasette-auth-github/releases/tag/0.13.1 2021-02-25
  • Deployments that are configured to check organization membership now use read:org scope instead of the more permissive user scope. #73
2021-02-25T06:40:17Z ["asgi", "datasette", "datasette-io", "datasette-plugin"]
342126610 https://github.com/simonw/datasette-block https://github.com/simonw/datasette-block/releases/tag/0.1.1 2021-02-25
  • Fix ASGI lifespan bug. #1
2021-02-25T05:03:45Z ["datasette", "datasette-io", "datasette-plugin"]
342126610 https://github.com/simonw/datasette-block https://github.com/simonw/datasette-block/releases/tag/0.1 2021-02-25
  • First working release
2021-02-25T04:52:07Z ["datasette", "datasette-io", "datasette-plugin"]
175321497 https://github.com/simonw/csv-diff https://github.com/simonw/csv-diff/releases/tag/1.1 2021-02-23
  • Tool now also works against inputs that are JSON files consisting of a list of objects with identical keys, using --format=json. #12
2021-02-23T01:14:25Z ["click", "csv", "datasette-io", "datasette-tool", "diff", "git-scraping"]
219372133 https://github.com/simonw/sqlite-transform https://github.com/simonw/sqlite-transform/releases/tag/0.4 2021-02-22
  • New sqlite-transform jsonsplit for converting foo,bar into ["foo", "bar"]. #10
  • Added --dry-run option to sqlite-tranfsorm lambda for previewing the conversion that is about to be applied. #8
2021-02-22T17:04:53Z ["datasette-io", "datasette-tool", "sqlite"]
291339086 https://github.com/simonw/airtable-export https://github.com/simonw/airtable-export/releases/tag/0.5 2021-02-22
  • New --sqlite database.db export option. #10
2021-02-22T06:02:10Z ["airtable", "airtable-api", "datasette-io", "datasette-tool", "yaml"]
140912432 https://github.com/simonw/sqlite-utils https://github.com/simonw/sqlite-utils/releases/tag/3.6 2021-02-19

This release adds the ability to execute queries joining data from more than one database file - similar to the cross database querying feature introduced in Datasette 0.55.

2021-02-19T05:19:00Z ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.55 2021-02-19

Support for cross-database SQL queries and built-in support for serving via HTTPS.

  • The new --crossdb command-line option causes Datasette to attach up to ten database files to the same /_memory database connection. This enables cross-database SQL queries, including the ability to use joins and unions to combine data from tables that exist in different database files. See Cross-database queries for details. (#283)
  • --ssl-keyfile and --ssl-certfile options can be used to specify a TLS certificate, allowing Datasette to serve traffic over https:// without needing to run it behind a separate proxy. (#1221)
  • The /:memory: page has been renamed (and redirected) to /_memory for consistency with the new /_internal database introduced in Datasette 0.54. (#1205)
  • Added plugin testing documentation on Using pdb for errors thrown inside Datasette. (#1207)
  • The official Datasette Docker image now uses Python 3.7.10, applying the latest security fix for that Python version. (#1235)
2021-02-19T02:02:29Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
284383265 https://github.com/simonw/datasette-graphql https://github.com/simonw/datasette-graphql/releases/tag/1.4 2021-02-18
  • Fix broken tests against Datasette 0.54. #71
  • Bundle JavaScript and CSS assets for GraphiQL, instead of loading them from a CDN. #73
  • Pin to graphene dependency < 3.0. #72
2021-02-18T23:37:44Z ["datasette", "datasette-io", "datasette-plugin", "graphql", "sqlite"]
335372050 https://github.com/simonw/download-tiles https://github.com/simonw/download-tiles/releases/tag/0.4.1 2021-02-16
  • Fixed bug in released version caused by unnecessary attr import. #6
2021-02-16T04:19:59Z ["datasette-io", "datasette-tool", "mbtiles", "openstreetmap"]
140912432 https://github.com/simonw/sqlite-utils https://github.com/simonw/sqlite-utils/releases/tag/3.5 2021-02-14
  • sqlite-utils insert --sniff option for detecting the delimiter and quote character used by a CSV file, see Alternative delimiters and quote characters. (#230)
  • The table.rows_where(), table.search() and table.search_sql() methods all now take optional offset= and limit= arguments. (#231)
  • New --no-headers option for sqlite-utils insert --csv to handle CSV files that are missing the header row, see CSV files without a header row. (#228)
  • Fixed bug where inserting data with extra columns in subsequent chunks would throw an error. Thanks @nieuwenhoven for the fix. (#234)
  • Fixed bug importing CSV files with columns containing more than 128KB of data. (#229)
  • Test suite now runs in CI against Ubuntu, macOS and Windows. Thanks @nieuwenhoven for the Windows test fixes. (#232)
2021-02-14T22:44:21Z ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"]
303218369 https://github.com/dogsheep/evernote-to-sqlite https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3.1 2021-02-11
  • Explicitly open file using utf-8 encoding - thanks, RiverZhou. #10
  • Fix import error if note has no "updated" element - thanks, Matej Korosec. #8
2021-02-11T22:40:40Z ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"]
303218369 https://github.com/dogsheep/evernote-to-sqlite https://github.com/dogsheep/evernote-to-sqlite/releases/tag/0.3 2021-02-11
  • Correctly handle entities in XHTML notes. #9
  • Fixed a bug importing ENEX files on Windows. Thanks, dskrad. #11
2021-02-11T22:16:20Z ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"]
335175637 https://github.com/simonw/datasette-tiles https://github.com/simonw/datasette-tiles/releases/tag/0.6.1 2021-02-11
  • Fixed bug introduced in 0.6 which caused the non-JavaScript tile explorer to display incorrectly. #22
2021-02-11T00:40:11Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles"]
335175637 https://github.com/simonw/datasette-tiles https://github.com/simonw/datasette-tiles/releases/tag/0.6 2021-02-11

This release breaks backwards compatibility if you are using this as a tile server. Map tiles served by /-/tiles/... now use the OpenStreetMap coordinate system, where y=0 references the upper-most tile on the map. If you wish to continue using the TMS coordinate system you should switch to /-/tiles-tms/... instead. See Tile coordinate systems for more details.

  • Support both OSM and TMS coordinate systems, use OSM by default. #15
  • Hide non-JavaScript map as soon as the JavaScript loads in the tile explorer. #21
2021-02-11T00:25:56Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles"]
174715153 https://github.com/simonw/datasette-jellyfish https://github.com/simonw/datasette-jellyfish/releases/tag/1.0.1 2021-02-06
  • Updated README examples to reflect function name changes in version 1.0. #3
2021-02-06T02:34:18Z ["datasette", "datasette-io", "datasette-plugin"]
140912432 https://github.com/simonw/sqlite-utils https://github.com/simonw/sqlite-utils/releases/tag/3.4.1 2021-02-06
  • Fixed a code import bug that slipped in to 3.4. (#226)
2021-02-06T02:11:15Z ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"]
174715153 https://github.com/simonw/datasette-jellyfish https://github.com/simonw/datasette-jellyfish/releases/tag/1.0 2021-02-06

Renamed two functions for compatibility with the latest Jellyfish - see their documentation for details.

  • jaro_distance(a, b) is now jaro_similarity(a, b)
  • jaro_winkler(a, b) is now jaro_winkler_similarity(a, b)
2021-02-06T02:00:51Z ["datasette", "datasette-io", "datasette-plugin"]
140912432 https://github.com/simonw/sqlite-utils https://github.com/simonw/sqlite-utils/releases/tag/3.4 2021-02-06
2021-02-06T01:38:26Z ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"]
335175637 https://github.com/simonw/datasette-tiles https://github.com/simonw/datasette-tiles/releases/tag/0.5 2021-02-04
2021-02-04T18:16:52Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles"]
335175637 https://github.com/simonw/datasette-tiles https://github.com/simonw/datasette-tiles/releases/tag/0.4 2021-02-03
  • New /-/tiles-stack mechanism for serving tiles from multiple databases. #8
  • "tiles-stack-order" plugin setting, for controlling the order in which tiles are served from the stack.
  • Tile explorer page now also displays metadata for that tile database. #7
  • Tile explorer uses name from metadata if it is available, and provides links to the database and table pages.
  • Tile 404s are now served as blank PNGs. #9
  • Renamed templates from mbtiles_*.html to tiles_*.html. #10
2021-02-03T22:24:18Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles"]
335372050 https://github.com/simonw/download-tiles https://github.com/simonw/download-tiles/releases/tag/0.4 2021-02-03
  • --name= option for setting the name to be written into the metadata table. If you use the --city or --country options without passing the --name the city or country name will be used instead. #5
  • --attribution=osm shortcut for setting the attribution to © OpenStreetMap contributors without having to type that out in full. #4
2021-02-03T03:32:11Z ["datasette-io", "datasette-tool", "mbtiles", "openstreetmap"]
335372050 https://github.com/simonw/download-tiles https://github.com/simonw/download-tiles/releases/tag/0.3 2021-02-03
  • New --attribution option for writing an attribution record to the metadata table. #3
2021-02-03T00:35:59Z ["datasette-io", "datasette-tool", "mbtiles", "openstreetmap"]
335175637 https://github.com/simonw/datasette-tiles https://github.com/simonw/datasette-tiles/releases/tag/0.3 2021-02-02
  • Attribution is now shown on the tile explorer page if it is included in the metadata table. #6
2021-02-02T23:41:32Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles"]
335137108 https://github.com/simonw/datasette-basemap https://github.com/simonw/datasette-basemap/releases/tag/0.2 2021-02-02
  • Database now includes attribution in the metadata table. #3
2021-02-02T23:33:57Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles", "openstreetmap"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.54.1 2021-02-02
  • Fixed a bug where ?_search= and ?_sort= parameters were incorrectly duplicated when the filter form on the table page was re-submitted. (#1214)
2021-02-02T21:30:12Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
335175637 https://github.com/simonw/datasette-tiles https://github.com/simonw/datasette-tiles/releases/tag/0.2 2021-02-02
  • Table and database action menu items linking to the tile explorer. #4
2021-02-02T19:54:11Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles"]
335372050 https://github.com/simonw/download-tiles https://github.com/simonw/download-tiles/releases/tag/0.2 2021-02-02
  • --city and --country options as an alternative to --bbox. #1
2021-02-02T18:24:29Z ["datasette-io", "datasette-tool", "mbtiles", "openstreetmap"]
335372050 https://github.com/simonw/download-tiles https://github.com/simonw/download-tiles/releases/tag/0.1 2021-02-02

Initial working version.

2021-02-02T17:39:35Z ["datasette-io", "datasette-tool", "mbtiles", "openstreetmap"]
335137108 https://github.com/simonw/datasette-basemap https://github.com/simonw/datasette-basemap/releases/tag/0.1 2021-02-02
  • First non-alpha release.
2021-02-02T07:07:43Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles", "openstreetmap"]
335175637 https://github.com/simonw/datasette-tiles https://github.com/simonw/datasette-tiles/releases/tag/0.1.1 2021-02-02
  • Improved README and live demo. #2
2021-02-02T07:05:04Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles"]
335175637 https://github.com/simonw/datasette-tiles https://github.com/simonw/datasette-tiles/releases/tag/0.1 2021-02-02
  • Initial working version, with tile serving and tile explorer. #1
2021-02-02T06:47:44Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles"]
335137108 https://github.com/simonw/datasette-basemap https://github.com/simonw/datasette-basemap/releases/tag/0.1a1 2021-02-02
  • Fixed bug with database bundling. #1
2021-02-02T02:02:51Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles", "openstreetmap"]
335137108 https://github.com/simonw/datasette-basemap https://github.com/simonw/datasette-basemap/releases/tag/0.1a 2021-02-02

Initial release, bundling zoom levels 0-6. #1

2021-02-02T01:59:05Z ["datasette", "datasette-io", "datasette-plugin", "mbtiles", "openstreetmap"]
130236762 https://github.com/simonw/datasette-cluster-map https://github.com/simonw/datasette-cluster-map/releases/tag/0.17.1 2021-02-01
2021-02-01T22:22:25Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
331720824 https://github.com/simonw/datasette-leaflet https://github.com/simonw/datasette-leaflet/releases/tag/0.2.2 2021-02-01
  • Fixed bug where Leaflet marker images were not bundled with the plugin. #6
2021-02-01T22:20:28Z ["datasette", "datasette-io", "datasette-plugin"]
331720824 https://github.com/simonw/datasette-leaflet https://github.com/simonw/datasette-leaflet/releases/tag/0.2.1 2021-01-31
  • Updated README
2021-01-31T07:23:01Z ["datasette", "datasette-io", "datasette-plugin"]
327236119 https://github.com/simonw/datasette-export-notebook https://github.com/simonw/datasette-export-notebook/releases/tag/0.3 2021-01-29
  • Pandas read_csv() streaming example now includes dtype= parameter with correct column types. #8
2021-01-29T22:22:44Z ["datasette-io", "datasette-plugin"]
238339412 https://github.com/simonw/datasette-debug-asgi https://github.com/simonw/datasette-debug-asgi/releases/tag/1.0 2021-01-29
  • Switched to using the register_routes() Datasette plugin hook. #2
2021-01-29T15:31:50Z ["asgi", "datasette-io", "datasette-plugin"]
221802296 https://github.com/simonw/datasette-template-sql https://github.com/simonw/datasette-template-sql/releases/tag/1.0.2 2021-01-29
  • Updated for compatibility with latest Datasette. #3
2021-01-29T02:29:57Z ["datasette", "datasette-io", "datasette-plugin"]
130236762 https://github.com/simonw/datasette-cluster-map https://github.com/simonw/datasette-cluster-map/releases/tag/0.17 2021-01-29
2021-01-29T02:06:19Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
130236762 https://github.com/simonw/datasette-cluster-map https://github.com/simonw/datasette-cluster-map/releases/tag/0.17a0 2021-01-26
2021-01-26T06:33:15Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
135007287 https://github.com/simonw/datasette-leaflet-geojson https://github.com/simonw/datasette-leaflet-geojson/releases/tag/0.8 2021-01-26
2021-01-26T02:41:07Z ["datasette", "datasette-io", "datasette-plugin", "gis", "leaflet"]
331151708 https://github.com/simonw/datasette-leaflet-freedraw https://github.com/simonw/datasette-leaflet-freedraw/releases/tag/0.2.1 2021-01-25
  • Include source map in the bundle. #4
2021-01-25T19:23:59Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
331151708 https://github.com/simonw/datasette-leaflet-freedraw https://github.com/simonw/datasette-leaflet-freedraw/releases/tag/0.2 2021-01-25
2021-01-25T19:05:34Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
331720824 https://github.com/simonw/datasette-leaflet https://github.com/simonw/datasette-leaflet/releases/tag/0.2 2021-01-25
  • Expose URLs to bundled assets as JavaScript global variables datasette.leaflet.JAVASCRIPT_URL and datasette.leaflet.CSS_URL. #4
2021-01-25T19:03:10Z ["datasette", "datasette-io", "datasette-plugin"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.54 2021-01-25

The two big new features in this release are the _internal SQLite in-memory database storing details of all connected databases and tables, and support for JavaScript modules in plugins and additional scripts.

For additional commentary on this release, see Datasette 0.54, the annotated release notes.

The _internal database

As part of ongoing work to help Datasette handle much larger numbers of connected databases and tables (see Datasette Library) Datasette now maintains an in-memory SQLite database with details of all of the attached databases, tables, columns, indexes and foreign keys. (#1150)

This will support future improvements such as a searchable, paginated homepage of all available tables.

You can explore an example of this database by signing in as root to the latest.datasette.io demo instance and then navigating to latest.datasette.io/_internal.

Plugins can use these tables to introspect attached data in an efficient way. Plugin authors should note that this is not yet considered a stable interface, so any plugins that use this may need to make changes prior to Datasette 1.0 if the _internal table schemas change.

Named in-memory database support

As part of the work building the _internal database, Datasette now supports named in-memory databases that can be shared across multiple connections. This allows plugins to create in-memory databases which will persist data for the lifetime of the Datasette server process. (#1151)

The new memory_name= parameter to the Database class can be used to create named, shared in-memory databases.

JavaScript modules

JavaScript modules were introduced in ECMAScript 2015 and provide native browser support for the import and export keywords.

To use modules, JavaScript needs to be included in <script> tags with a type="module" attribute.

Datasette now has the ability to output <script type="module"> in places where you may wish to take advantage of modules. The extra_js_urls option described in Custom CSS and JavaScript can now be used with modules, and module support is also available for the extra_body_script() plugin hook. (#1186, #1187)

datasette-leaflet-freedraw is the first example of a Datasette plugin that takes advantage of the new support for JavaScript modules. See Drawing shapes on a map to query a SpatiaLite database for more on this plugin.

Code formatting with Black and Prettier

Datasette adopted Black for opinionated Python code formatting in June 2019. Datasette now also embraces Prettier for JavaScript formatting, which like Black is enforced by tests in continuous integration. Instructions for using these two tools can be found in the new section on Code formatting in the contributors documentation. (#1167)

Other changes

  • Datasette can now open multiple database files with the same name, e.g. if you run datasette path/to/one.db path/to/other/one.db. (#509)
  • datasette publish cloudrun now sets force_https_urls for every deployment, fixing some incorrect http:// links. (#1178)
  • Fixed a bug in the example nginx configuration in Running Datasette behind a proxy. (#1091)
  • The Datasette Ecosystem documentation page has been reduced in size in favour of the datasette.io tools and plugins directories. (#1182)
  • The request object now provides a request.full_path property, which returns the path including any query string. (#1184)
  • Better error message for disallowed PRAGMA clauses in SQL queries. (#1185)
  • datasette publish heroku now deploys using python-3.8.7.
  • New plugin testing documentation on Testing outbound HTTP calls with pytest-httpx. (#1198)
  • All ?_* query string parameters passed to the table page are now persisted in hidden form fields, so parameters such as ?_size=10 will be correctly passed to the next page when query filters are changed. (#1194)
  • Fixed a bug loading a database file called test-database (1).sqlite. (#1181)
2021-01-25T17:36:30Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
331720824 https://github.com/simonw/datasette-leaflet https://github.com/simonw/datasette-leaflet/releases/tag/0.1 2021-01-24
  • Initial release, bundling Leaflet 1.7.1 as static assets that can be loaded as JavaScript modules.
2021-01-24T18:19:32Z ["datasette", "datasette-io", "datasette-plugin"]
331151708 https://github.com/simonw/datasette-leaflet-freedraw https://github.com/simonw/datasette-leaflet-freedraw/releases/tag/0.1.4 2021-01-24
  • README now includes a demo. #2
  • Note that this currently requires the Datasette 0.54a0 alpha.
2021-01-24T06:46:58Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
195087137 https://github.com/simonw/datasette-auth-github https://github.com/simonw/datasette-auth-github/releases/tag/0.13 2021-01-24

This plugin now builds on the Authentication and permissions mechanism introduced in Datasette 0.44. This means it can be used in combination with other authentication plugins such as datasette-auth-tokens. #62

When a user signs in with GitHub, a signed ds_actor cookie is set with details of their GitHub profile. Fields from this dictionary can be used with Datasette allow blocks to control access to individual databases, tables and queries.

The new load_orgs and load_teams options can be used to check the user's membership of different organization and teams when they first sign in. These memberships will be encoded in the cookie and can be used to control access.

Other changes:

  • The ASGI middleware version of this plugin has been split off into a separate asgi-auth-github package. #63
  • Error messages are now rendered using a datasette_auth_github_error.html template, which can be customized by including a template of the same name in a custom templates directory. #36
  • The /-/auth-callback path is now /-/github-auth-callback - you will need to update this in your GitHub OAuth application settings. #66
2021-01-24T05:53:00Z ["asgi", "datasette", "datasette-io", "datasette-plugin"]
130236762 https://github.com/simonw/datasette-cluster-map https://github.com/simonw/datasette-cluster-map/releases/tag/0.16 2021-01-23
  • Handle cases where columns may have null values. Thanks, Jose Rodriguez-Salinas. #27
  • Now depends on Datasette >= 0.50
2021-01-23T22:50:55Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
195087137 https://github.com/simonw/datasette-auth-github https://github.com/simonw/datasette-auth-github/releases/tag/0.13a2 2021-01-23
  • Renamed /-/auth-callback to /-/github-auth-callback. #66
2021-01-23T00:50:16Z ["asgi", "datasette", "datasette-io", "datasette-plugin"]
195087137 https://github.com/simonw/datasette-auth-github https://github.com/simonw/datasette-auth-github/releases/tag/0.13a1 2021-01-22
  • Removed custom base template - Datasette provides a "logout" link in the default interface now.
  • Added "Sign in with GitHub" menu action. #65
  • Use datasette_datasette_auth_github_error.html template for error messages. #36
2021-01-22T23:22:19Z ["asgi", "datasette", "datasette-io", "datasette-plugin"]
195087137 https://github.com/simonw/datasette-auth-github https://github.com/simonw/datasette-auth-github/releases/tag/0.13a0 2021-01-22

Alpha release. This is a big change - it switches the plugin over to using the authentication plugin mechanism introduced in Datasette 0.44.

2021-01-22T22:36:49Z ["asgi", "datasette", "datasette-io", "datasette-plugin"]
135007287 https://github.com/simonw/datasette-leaflet-geojson https://github.com/simonw/datasette-leaflet-geojson/releases/tag/0.7 2021-01-20
  • Plugin now only shows maps for the first ten rows, with a "Click to view map" prompt for rows past that point. This can be customized using the new default_maps_to_load plugin setting. #16
2021-01-20T20:21:25Z ["datasette", "datasette-io", "datasette-plugin", "gis", "leaflet"]
331151708 https://github.com/simonw/datasette-leaflet-freedraw https://github.com/simonw/datasette-leaflet-freedraw/releases/tag/0.1.3 2021-01-20
  • Fixed bug where polygons drawn at a high zoom level were not correctly re-displayed after submitting the query. #1
2021-01-20T09:29:08Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
331151708 https://github.com/simonw/datasette-leaflet-freedraw https://github.com/simonw/datasette-leaflet-freedraw/releases/tag/0.1.2 2021-01-20
  • Bundle the CSS as well
2021-01-20T01:26:17Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
331151708 https://github.com/simonw/datasette-leaflet-freedraw https://github.com/simonw/datasette-leaflet-freedraw/releases/tag/0.1.1 2021-01-20
  • Added some static files that I missed from the packaging.
2021-01-20T01:20:20Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
331151708 https://github.com/simonw/datasette-leaflet-freedraw https://github.com/simonw/datasette-leaflet-freedraw/releases/tag/0.1 2021-01-20
  • Initial working release.
2021-01-20T00:59:30Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.54a0 2021-01-19

Alpha release. Release notes in progress.

  • Improved support for named in-memory databases. (#1151)
  • New _internal in-memory database tracking attached databases, tables and columns. (#1150)
  • Support for JavaScript modules. (#1186, #1187)
2021-01-19T20:51:13Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
130236762 https://github.com/simonw/datasette-cluster-map https://github.com/simonw/datasette-cluster-map/releases/tag/0.15 2021-01-18
  • Fixed bug where foreign key labels were displayed as [object Object]. #26
2021-01-18T21:49:39Z ["datasette", "datasette-io", "datasette-plugin", "leafletjs"]
219372133 https://github.com/simonw/sqlite-transform https://github.com/simonw/sqlite-transform/releases/tag/0.3.1 2021-01-18
  • Better --help for sqlite-transform lambda. #7
2021-01-18T21:01:06Z ["datasette-io", "datasette-tool", "sqlite"]
205429375 https://github.com/dogsheep/swarm-to-sqlite https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.3.3 2021-01-18
  • Fixed bug where tool could crash with an error about missing columns. #11
2021-01-18T04:36:03Z ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"]
140912432 https://github.com/simonw/sqlite-utils https://github.com/simonw/sqlite-utils/releases/tag/3.3 2021-01-18
2021-01-18T04:29:48Z ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"]
167759846 https://github.com/simonw/markdown-to-sqlite https://github.com/simonw/markdown-to-sqlite/releases/tag/0.2 2021-01-14
  • Upgraded tests for latest dependencies
  • Switched CI to GitHub Actions
2021-01-14T20:21:19Z ["datasette-io", "datasette-tool", "markdown", "sqlite", "yaml"]
140912432 https://github.com/simonw/sqlite-utils https://github.com/simonw/sqlite-utils/releases/tag/3.2.1 2021-01-12
  • Fixed a bug where .add_missing_columns() failed to take case insensitive column names into account. (#221)
2021-01-12T23:23:25Z ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"]
327236119 https://github.com/simonw/datasette-export-notebook https://github.com/simonw/datasette-export-notebook/releases/tag/0.2 2021-01-11
  • Observable export instructions are only shown if Datasette is run with the --cors option. #5
  • Export notebook page links back to view the rows. #6
  • CSV streaming export instructions are provided, if available. #7
2021-01-11T22:29:04Z ["datasette-io", "datasette-plugin"]
327236119 https://github.com/simonw/datasette-export-notebook https://github.com/simonw/datasette-export-notebook/releases/tag/0.1.1 2021-01-09

Improved README with links to a live demo.

2021-01-09T23:57:26Z ["datasette-io", "datasette-plugin"]
327087207 https://github.com/simonw/datasette-css-properties https://github.com/simonw/datasette-css-properties/releases/tag/0.2 2021-01-07
  • .css pages now send the x-content-type-options: nosniff header, to protect against browsers incorrectly rendering the CSS as HTML which could be an XSS security hole. #1
2021-01-07T20:28:40Z ["datasette-io", "datasette-plugin"]
327087207 https://github.com/simonw/datasette-css-properties https://github.com/simonw/datasette-css-properties/releases/tag/0.1.1 2021-01-07
  • Improved README
2021-01-07T19:48:50Z ["datasette-io", "datasette-plugin"]
327236119 https://github.com/simonw/datasette-export-notebook https://github.com/simonw/datasette-export-notebook/releases/tag/0.1 2021-01-06

First working version. #1

2021-01-06T08:12:31Z ["datasette-io", "datasette-plugin"]
327087207 https://github.com/simonw/datasette-css-properties https://github.com/simonw/datasette-css-properties/releases/tag/0.1 2021-01-05

Initial prototype.

2021-01-05T18:39:44Z ["datasette-io", "datasette-plugin"]
140912432 https://github.com/simonw/sqlite-utils https://github.com/simonw/sqlite-utils/releases/tag/3.2 2021-01-03

This release introduces a new mechanism for speeding up count(*) queries using cached table counts, stored in a _counts table and updated by triggers. This mechanism is described in Cached table counts using triggers, and can be enabled using Python API methods or the new enable-counts CLI command. (#212)

  • table.enable_counts() method for enabling these triggers on a specific table.
  • db.enable_counts() method for enabling triggers on every table in the database. (#213)
  • New sqlite-utils enable-counts my.db command for enabling counts on all or specific tables, see Enabling cached counts. (#214)
  • New sqlite-utils triggers command for listing the triggers defined for a database or specific tables, see Listing triggers. (#218)
  • New db.use_counts_table property which, if True, causes table.count to read from the _counts table. (#215)
  • table.has_counts_triggers property revealing if a table has been configured with the new _counts database triggers.
  • db.reset_counts() method and sqlite-utils reset-counts command for resetting the values in the _counts table. (#219)
  • The previously undocumented db.escape() method has been renamed to db.quote() and is now covered by the documentation: Quoting strings for use in SQL. (#217)
  • New table.triggers_dict and db.triggers_dict introspection properties. (#211, #216)
  • sqlite-utils insert now shows a more useful error message for invalid JSON. (#206)
2021-01-03T21:17:37Z ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"]
140912432 https://github.com/simonw/sqlite-utils https://github.com/simonw/sqlite-utils/releases/tag/3.1.1 2021-01-01
  • Fixed failing test caused by optimize sometimes creating larger database files. (#209)
  • Documentation now lives on https://sqlite-utils.datasette.io/
  • README now includes brew install sqlite-utils installation method.
2021-01-01T23:57:07Z ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"]
253632948 https://github.com/simonw/datasette-publish-vercel https://github.com/simonw/datasette-publish-vercel/releases/tag/0.9.1 2020-12-28
  • Fixed a bug with the datasette publish now alias for datasette publish vercel. #31
2020-12-28T19:39:10Z ["datasette", "datasette-io", "datasette-plugin", "vercel", "zeit-now"]
197431109 https://github.com/dogsheep/dogsheep-beta https://github.com/dogsheep/dogsheep-beta/releases/tag/0.10.1 2020-12-19
  • Fix for error if search query contains hyphens such as github-to-sqlite. #31
2020-12-19T06:19:13Z ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"]
197431109 https://github.com/dogsheep/dogsheep-beta https://github.com/dogsheep/dogsheep-beta/releases/tag/0.10 2020-12-16
  • Now depends on sqlite-utils >= 3.0. #30
  • The user's original search term is now passed to the display_sql SQL query as the :q parameter. #29
2020-12-16T21:28:13Z ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"]
207052882 https://github.com/dogsheep/github-to-sqlite https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8.2 2020-12-16
  • --readme now stores null if the README file does not exist, rather than throwing an error. #57
  • README HTML is rewritten to fix broken internal links, e.g. for a table of contents. #58
2020-12-16T19:21:58Z ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"]
253632948 https://github.com/simonw/datasette-publish-vercel https://github.com/simonw/datasette-publish-vercel/releases/tag/0.9 2020-12-14
  • New --setting option for specifying Datasette settings, as a working alternative to --extra-options. #30
2020-12-14T04:03:06Z ["datasette", "datasette-io", "datasette-plugin", "vercel", "zeit-now"]
140912432 https://github.com/simonw/sqlite-utils https://github.com/simonw/sqlite-utils/releases/tag/3.1 2020-12-13
  • New command: sqlite-utils analyze-tables my.db outputs useful information about the table columns in the database, such as the number of distinct values and how many rows are null. See Analyzing tables for documentation. (#207)
  • New table.analyze_column(column) Python method used by the analyze-tables command - see Analyzing a column.
  • The table.update() method now correctly handles values that should be stored as JSON. Thanks, Andreas Madsack. (#204)
2020-12-13T07:31:40Z ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"]
248385299 https://github.com/simonw/datasette-publish-fly https://github.com/simonw/datasette-publish-fly/releases/tag/1.0.1 2020-12-12
  • Fixed various errors that occurred when using latest version of flyctl. #7
2020-12-12T21:11:49Z ["datasette", "datasette-io", "datasette-plugin", "fly"]
279357123 https://github.com/simonw/datasette-auth-passwords https://github.com/simonw/datasette-auth-passwords/releases/tag/0.3.3 2020-12-11
  • Fixed bug where users with a "someusername_password_hash" value defined in metadata.json but no corresponding "actor" record were incorrectly signed in as an actor with "id": "username", when they should have been signed in as an actor with "id": "someusername". #14
2020-12-11T05:29:14Z ["datasette", "datasette-io", "datasette-plugin"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.53 2020-12-11

Datasette has an official project website now, at https://datasette.io/. This release mainly updates the documentation to reflect the new site.

  • New ?column__arraynotcontains= table filter. (#1132)
  • datasette serve has a new --create option, which will create blank database files if they do not already exist rather than exiting with an error. (#1135)
  • New ?_header=off option for CSV export which omits the CSV header row, documented here. (#1133)
  • "Powered by Datasette" link in the footer now links to https://datasette.io/. (#1138)
  • Project news no longer lives in the README - it can now be found at https://datasette.io/news. (#1137)
2020-12-11T01:46:44Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
246108561 https://github.com/simonw/datasette-column-inspect https://github.com/simonw/datasette-column-inspect/releases/tag/0.2a 2020-12-09
  • Correctly parse column links. #3
  • Show a message encouraging mobile users to rotate to landscape. #2
2020-12-09T21:47:38Z ["datasette", "datasette-io", "datasette-plugin"]
167730071 https://github.com/simonw/datasette-pretty-json https://github.com/simonw/datasette-pretty-json/releases/tag/0.2.1 2020-12-09
  • Switched CI to GitHub Actions
2020-12-09T21:22:43Z ["datasette", "datasette-io", "datasette-plugin", "json"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.52.5 2020-12-09
  • Fix for error caused by combining the _searchmode=raw and ?_search_COLUMN parameters. (#1134)
2020-12-09T20:10:23Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
175550127 https://github.com/simonw/yaml-to-sqlite https://github.com/simonw/yaml-to-sqlite/releases/tag/0.3.1 2020-12-07
  • Updated for latest sqlite-utils library
  • Fixed bug where import failed if user did not provide a --pk option
2020-12-07T21:12:55Z ["datasette-io", "datasette-tool", "sqlite", "yaml"]
294706267 https://github.com/simonw/datasette-seaborn https://github.com/simonw/datasette-seaborn/releases/tag/0.2a0 2020-12-07
  • Chart rendering now takes place in a subprocess with a 5 second default time limit. Time limit can be customized using a new render_time_limit plugin configuration option. #4
2020-12-07T01:39:12Z ["datasette", "datasette-io", "datasette-plugin", "seaborn", "visualization"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.52.4 2020-12-05
  • Show pysqlite3 version on /-/versions, if installed. (#1125)
  • Errors output by Datasette (e.g. for invalid SQL queries) now go to stderr, not stdout. (#1131)
  • Fix for a startup error on windows caused by unnecessary from os import EX_CANTCREAT - thanks, Abdussamet Koçak. (#1094)
2020-12-05T19:42:57Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
245856731 https://github.com/simonw/datasette-search-all https://github.com/simonw/datasette-search-all/releases/tag/1.0.1 2020-12-04
  • Form inputs are now wrapped in a paragraph, making form less cramped when displayed next to metadata. #12
2020-12-04T21:12:26Z ["datasette", "datasette-io", "datasette-plugin", "search"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.52.3 2020-12-03
  • Fixed bug where static assets would 404 for Datasette installed on ARM Amazon Linux. (#1124)
2020-12-03T19:08:29Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.52.2 2020-12-03
  • Generated columns from SQLite 3.31.0 or higher are now correctly displayed. (#1116)
  • Error message if you attempt to open a SpatiaLite database now suggests using --load-extension=spatialite if it detects that the extension is available in a common location. (#1115)
  • OPTIONS requests against the /database page no longer raise a 500 error. (#1100)
  • Databases larger than 32MB that are published to Cloud Run can now be downloaded. (#749)
  • Fix for misaligned cog icon on table and database pages. Thanks, Abdussamet Koçak. (#1121)
2020-12-03T00:58:43Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
291359358 https://github.com/simonw/datasette-yaml https://github.com/simonw/datasette-yaml/releases/tag/0.1.1 2020-12-03
  • Depend on datasette without version pinning.
2020-12-03T00:09:35Z ["datasette", "datasette-io", "datasette-plugin", "yaml"]
284383265 https://github.com/simonw/datasette-graphql https://github.com/simonw/datasette-graphql/releases/tag/1.3.1 2020-11-30
  • Fixed bug where in: and notin: filters raised an error when run against lists of integers rather than lists of strings. #68
2020-11-30T19:02:51Z ["datasette", "datasette-io", "datasette-plugin", "graphql", "sqlite"]
284383265 https://github.com/simonw/datasette-graphql https://github.com/simonw/datasette-graphql/releases/tag/1.3 2020-11-30
  • Suggested queries for tables (available from the table actions cog menu) now include foreign key expansions. #67
2020-11-30T18:11:47Z ["datasette", "datasette-io", "datasette-plugin", "graphql", "sqlite"]
207052882 https://github.com/dogsheep/github-to-sqlite https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8.1 2020-11-30
  • README now links to example database tables for each command. #56
  • Added documentation for github-to-sqlite releases.
2020-11-30T04:18:21Z ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"]
207052882 https://github.com/dogsheep/github-to-sqlite https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8 2020-11-30
  • New command: github-to-sqlite workflows, for fetching the YAML configuration used by GitHub Actions workflows and using it to populate new workflows, jobs and steps tables. #54
  • New command: github-to-sqlite pull-requests - thanks, @adamjonas! #48
  • github-to-sqlite issues --issue option can now be used multiple times.
2020-11-30T01:41:38Z ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.52.1 2020-11-29
2020-11-29T19:39:52Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
107914493 https://github.com/simonw/datasette https://github.com/simonw/datasette/releases/tag/0.52 2020-11-28

This release includes a number of changes relating to an internal rebranding effort: Datasette's configuration mechanism (things like datasette --config default_page_size:10) has been renamed to settings.

  • New --setting default_page_size 10 option as a replacement for --config default_page_size:10 (note the lack of a colon). The --config option is deprecated but will continue working until Datasette 1.0. (#992)
  • The /-/config introspection page is now /-/settings, and the previous page redirects to the new one. (#1103)
  • The config.json file in Configuration directory mode is now called settings.json. (#1104)
  • The undocumented datasette.config() internal method has been replaced by a documented .setting(key) method. (#1107)

Also in this release:

  • New plugin hook: database_actions(datasette, actor, database), which adds menu items to a new cog menu shown at the top of the database page. (#1077)
  • datasette publish cloudrun has a new --apt-get-install option that can be used to install additional Ubuntu packages as part of the deployment. This is useful for deploying the new datasette-ripgrep plugin. (#1110)
  • Swept the documentation to remove words that minimize involved difficulty. (#1089)

And some bug fixes:

  • Foreign keys linking to rows with blank label columns now display as a hyphen, allowing those links to be clicked. (#1086)
  • Fixed bug where row pages could sometimes 500 if the underlying queries exceeded a time limit. (#1088)
  • Fixed a bug where the table action menu could appear partially obscured by the edge of the page. (#1084)
2020-11-28T23:57:12Z ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"]
315796015 https://github.com/simonw/datasette-ripgrep https://github.com/simonw/datasette-ripgrep/releases/tag/0.6.1 2020-11-28
  • Improved README with better tagline and better examples.
2020-11-28T22:42:44Z ["codesearch", "datasette", "datasette-io", "datasette-plugin", "ripgrep"]

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW recent_releases AS select
  repos.rowid as rowid,
  repos.html_url as repo,
  releases.html_url as release,
  substr(releases.published_at, 0, 11) as date,
  releases.body as body_markdown,
  releases.published_at,
  coalesce(repos.topics, '[]') as topics
from
  releases
  join repos on repos.id = releases.repo
order by
  releases.published_at desc;