recent_releases (view)
1,054 rows
This data as json, CSV (advanced)
Suggested facets: date (date), published_at (date), topics (array)
| rowid | repo | release | date | body_markdown | published_at | topics |
|---|---|---|---|---|---|---|
| 107914493 | https://github.com/simonw/datasette | https://github.com/simonw/datasette/releases/tag/0.63.1 | 2022-11-11 | - Fixed a bug where Datasette's table filter form would not redirect correctly when run behind a proxy using the [base_url](https://docs.datasette.io/en/stable/settings.html#setting-base-url) setting. ([#1883](https://github.com/simonw/datasette/issues/1883)) - SQL query is now shown wrapped in a `<textarea>` if a query exceeds a time limit. ([#1876](https://github.com/simonw/datasette/issues/1876)) - Fixed an intermittent "Too many open files" error while running the test suite. ([#1843](https://github.com/simonw/datasette/issues/1843)) - New [db.close()](https://docs.datasette.io/en/stable/internals.html#database-close) internal method. | 2022-11-11T07:02:36Z | ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"] |
| 293361514 | https://github.com/eyeseast/geocode-sqlite | https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.8.2 | 2022-11-07 | ## What's Changed * Require requests. More forgiving timeout. by @eyeseast in https://github.com/eyeseast/geocode-sqlite/pull/43 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.8.1...v0.8.2 | 2022-11-07T17:31:06Z | [] |
| 293361514 | https://github.com/eyeseast/geocode-sqlite | https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.8.1 | 2022-11-06 | ## What's Changed * Raw results in geocode_table, too by @eyeseast in https://github.com/eyeseast/geocode-sqlite/pull/42 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.8.0...v0.8.1 | 2022-11-06T17:11:24Z | [] |
| 293361514 | https://github.com/eyeseast/geocode-sqlite | https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.8.0 | 2022-11-06 | ## What's Changed * Just a typo! by @shaver in https://github.com/eyeseast/geocode-sqlite/pull/40 * Capture raw geocoding results by @eyeseast in https://github.com/eyeseast/geocode-sqlite/pull/41 ## New Contributors * @shaver made their first contribution in https://github.com/eyeseast/geocode-sqlite/pull/40 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.7.0...v0.8.0 | 2022-11-06T16:59:21Z | [] |
| 293361514 | https://github.com/eyeseast/geocode-sqlite | https://github.com/eyeseast/geocode-sqlite/releases/tag/v0.7.0 | 2022-10-31 | The [OpenCage](https://opencagedata.com/) geocoding service is now supported. Thanks @sbscully. This library is now tested on Python 3.11. ## What's Changed * Add OpenCage option to CLI by @sbscully in https://github.com/eyeseast/geocode-sqlite/pull/39 ## New Contributors * @sbscully made their first contribution in https://github.com/eyeseast/geocode-sqlite/pull/39 **Full Changelog**: https://github.com/eyeseast/geocode-sqlite/compare/v0.6.1...v0.7.0 | 2022-10-31T15:07:47Z | [] |
| 308930118 | https://github.com/simonw/datasette-edit-templates | https://github.com/simonw/datasette-edit-templates/releases/tag/0.1 | 2022-10-27 | - Now depends on [Datasette 0.63](https://docs.datasette.io/en/stable/changelog.html#v0-63), replacing an ugly plugin hook workaround. | 2022-10-27T22:54:35Z | [] |
| 107914493 | https://github.com/simonw/datasette | https://github.com/simonw/datasette/releases/tag/0.63 | 2022-10-27 | See [Datasette 0.63: The annotated release notes](https://simonwillison.net/2022/Oct/27/datasette-0-63/) for more background on the changes in this release. ## Features - Now tested against Python 3.11. Docker containers used by `datasette publish` and `datasette package` both now use that version of Python. ([#1853](https://github.com/simonw/datasette/issues/1853)) - `--load-extension` option now supports entrypoints. Thanks, Alex Garcia. ([#1789](https://github.com/simonw/datasette/pull/1789)) - Facet size can now be set per-table with the new `facet_size` table metadata option. ([#1804](https://github.com/simonw/datasette/issues/1804)) - The [truncate_cells_html](https://docs.datasette.io/en/stable/settings.html#setting-truncate-cells-html) setting now also affects long URLs in columns. ([#1805](https://github.com/simonw/datasette/issues/1805)) - The non-JavaScript SQL editor textarea now increases height to fit the SQL query. ([#1786](https://github.com/simonw/datasette/issues/1786)) - Facets are now displayed with better line-breaks in long values. Thanks, Daniel Rech. ([#1794](https://github.com/simonw/datasette/pull/1794)) - The `settings.json` file used in [Configuration directory mode](https://docs.datasette.io/en/stable/settings.html#config-dir) is now validated on startup. ([#1816](https://github.com/simonw/datasette/issues/1816)) - SQL queries can now include leading SQL comments, using `/* ... */` or `-- ...` syntax. Thanks, Charles Nepote. ([#1860](https://github.com/simonw/datasette/issues/1860)) - SQL query is now re-displayed when terminated with a time limit error. ([#1819](https://github.com/simonw/datasette/issues/1819)) - The [inspect data](https://docs.datasette.io/en/stable/performance.html#performance-inspect) mechanism is now used to speed up server startup - thanks, Forest Gregg. ([#1834](https://github.com/simonw/datasette/issues/1834)) - In [Configuration directory mode](https://docs.datasette.io/en/stable/settings.html#config-dir) databases with filenames ending in `.s… | 2022-10-27T22:13:32Z | ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"] |
| 140912432 | https://github.com/simonw/sqlite-utils | https://github.com/simonw/sqlite-utils/releases/tag/3.30 | 2022-10-25 | - Now tested against Python 3.11. ([#502](https://github.com/simonw/sqlite-utils/issues/502)) - New `table.search_sql(include_rank=True)` option, which adds a `rank` column to the generated SQL. Thanks, Jacob Chapman. ([#480](https://github.com/simonw/sqlite-utils/pull/480)) - Progress bars now display for newline-delimited JSON files using the `--nl` option. Thanks, Mischa Untaga. ([#485](https://github.com/simonw/sqlite-utils/issues/485)) - New `db.close()` method. ([#504](https://github.com/simonw/sqlite-utils/issues/504)) - Conversion functions passed to [table.convert(...)](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-convert) can now return lists or dictionaries, which will be inserted into the database as JSON strings. ([#495](https://github.com/simonw/sqlite-utils/issues/495)) - `sqlite-utils install` and `sqlite-utils uninstall` commands for installing packages into the same virtual environment as `sqlite-utils`, [described here](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-install). ([#483](https://github.com/simonw/sqlite-utils/issues/483)) - New [sqlite_utils.utils.flatten()](https://sqlite-utils.datasette.io/en/stable/reference.html#reference-utils-flatten) utility function. ([#500](https://github.com/simonw/sqlite-utils/issues/500)) - Documentation on [using Just](https://sqlite-utils.datasette.io/en/stable/contributing.html#contributing-just) to run tests, linters and build documentation. - Documentation now covers the [Release process](https://sqlite-utils.datasette.io/en/stable/contributing.html#release-process) for this package. | 2022-10-25T22:34:48Z | ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"] |
| 312934001 | https://github.com/simonw/datasette-indieauth | https://github.com/simonw/datasette-indieauth/releases/tag/1.2.1 | 2022-10-25 | - Upgraded for compatibility with latest Datasette. [#24](https://github.com/simonw/datasette-indieauth/issues/24), [#25](https://github.com/simonw/datasette-indieauth/issues/25) - Dropped support for Python 3.6. | 2022-10-25T01:34:47Z | ["datasette", "datasette-io", "datasette-plugin", "indieauth"] |
| 467679579 | https://github.com/simonw/shot-scraper | https://github.com/simonw/shot-scraper/releases/tag/1.0.1 | 2022-10-24 | - [shot-scraper.datasette.io](https://shot-scraper.datasette.io/) homepage now includes an example screenshot. [#97](https://github.com/simonw/shot-scraper/issues/97) | 2022-10-24T23:07:59Z | ["playwright", "playwright-python", "scraping", "screenshot-utility", "screenshots"] |
| 107914493 | https://github.com/simonw/datasette | https://github.com/simonw/datasette/releases/tag/0.63a1 | 2022-10-24 | - SQL query is now re-displayed when terminated with a time limit error. ([#1819](https://github.com/simonw/datasette/issues/1819)) - New documentation on [Running Datasette using OpenRC](https://docs.datasette.io/en/latest/deploying.html#deploying-openrc) - thanks, Adam Simpson. ([#1825](https://github.com/simonw/datasette/pull/1825)) - The [inspect data](https://docs.datasette.io/en/latest/performance.html#performance-inspect) mechanism is now used to speed up server startup - thanks, Forest Gregg. ([#1834](https://github.com/simonw/datasette/issues/1834)) - In [Configuration directory mode](https://docs.datasette.io/en/latest/settings.html#config-dir) databases with filenames ending in `.sqlite` or `.sqlite3` are now automatically added to the Datasette instance. ([#1646](https://github.com/simonw/datasette/issues/1646)) - Breadcrumb navigation display now respects the current user's permissions. ([#1831](https://github.com/simonw/datasette/issues/1831)) - Screenshots in the documentation are now maintained using [shot-scraper](https://shot-scraper.datasette.io/), as described in [Automating screenshots for the Datasette documentation using shot-scraper](https://simonwillison.net/2022/Oct/14/automating-screenshots/). ([#1844](https://github.com/simonw/datasette/issues/1844)) - The [datasette.check_visibility()](https://docs.datasette.io/en/latest/internals.html#datasette-check-visibility) method now accepts an optional `permissions=` list, allowing it to take multiple permissions into account at once when deciding if something should be shown as public or private. This has been used to correctly display padlock icons in more places in the Datasette interface. ([#1829](https://github.com/simonw/datasette/issues/1829)) | 2022-10-24T03:11:47Z | ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"] |
| 555992212 | https://github.com/simonw/datasette-gunicorn | https://github.com/simonw/datasette-gunicorn/releases/tag/0.1 | 2022-10-22 | - Initial release. `datasette gunicorn my.db -w 4` starts Datasette using [Gunicorn](https://gunicorn.org/) with four workers. [#1](https://github.com/simonw/datasette-gunicorn/issues/1) | 2022-10-22T20:57:44Z | ["datasette", "datasette-plugin"] |
| 474473836 | https://github.com/hydrosquall/datasette-nteract-data-explorer | https://github.com/hydrosquall/datasette-nteract-data-explorer/releases/tag/0.5.1 | 2022-10-19 | ## What's Changed * docs: Update the release action trigger guidelines in CONTRIBUTING.md by @hydrosquall in https://github.com/hydrosquall/datasette-nteract-data-explorer/pull/33 * fix: reverse inverted boolean for datasette membership test by @hydrosquall in https://github.com/hydrosquall/datasette-nteract-data-explorer/pull/34 **Full Changelog**: https://github.com/hydrosquall/datasette-nteract-data-explorer/compare/0.5.0...0.5.1 | 2022-10-19T00:07:29Z | ["automatic-viz", "datasette", "datasette-plugin", "dataviz"] |
| 474473836 | https://github.com/hydrosquall/datasette-nteract-data-explorer | https://github.com/hydrosquall/datasette-nteract-data-explorer/releases/tag/0.5.0 | 2022-10-18 | ## What's Changed * feat: disable URL state sync feature when running in datasette-lite by @hydrosquall in https://github.com/hydrosquall/datasette-nteract-data-explorer/pull/30 **Full Changelog**: https://github.com/hydrosquall/datasette-nteract-data-explorer/compare/0.4.2...0.5.0 | 2022-10-18T23:54:42Z | ["automatic-viz", "datasette", "datasette-plugin", "dataviz"] |
| 467679579 | https://github.com/simonw/shot-scraper | https://github.com/simonw/shot-scraper/releases/tag/1.0 | 2022-10-15 | - New `shot-scraper html URL` command ([documented here](https://shot-scraper.datasette.io/en/stable/html.html)) for outputting the final HTML of a page, after JavaScript has been executed. [#96](https://github.com/simonw/shot-scraper/issues/96) - `shot-scraper javascript` has a new `-r/--raw` option for outputting the result of the JavaScript expression as a raw string rather than JSON encoded ([shot-scraper javascript documentation](https://shot-scraper.datasette.io/en/stable/javascript.html)). [#95](https://github.com/simonw/shot-scraper/issues/95) - Tutorial: [Automating screenshots for the Datasette documentation using shot-scraper](https://simonwillison.net/2022/Oct/14/automating-screenshots/). | 2022-10-15T19:46:37Z | ["playwright", "playwright-python", "scraping", "screenshot-utility", "screenshots"] |
| 467679579 | https://github.com/simonw/shot-scraper | https://github.com/simonw/shot-scraper/releases/tag/0.17 | 2022-10-14 | - New `shot-scraper multi -o` option for specifying a subset of one or more output files to execute that are defined in the YAML. This is useful for testing a larger `shots.yml` file without re-taking every screenshot every time the command is run. [#94](https://github.com/simonw/shot-scraper/issues/94) | 2022-10-14T19:32:23Z | ["playwright", "playwright-python", "scraping", "screenshot-utility", "screenshots"] |
| 545764894 | https://github.com/simonw/datasette-public | https://github.com/simonw/datasette-public/releases/tag/0.2 | 2022-10-07 | - Fix compatibility bug when installed alongside `datasette-leaflet-geojson`. [#4](https://github.com/simonw/datasette-public/issues/4) - The `execute-sql` permission check now checks to see if the user has the `view-database` permission. [#3](https://github.com/simonw/datasette-public/issues/3) | 2022-10-07T22:34:48Z | [] |
| 547039866 | https://github.com/ocdtrekkie/datasette-external-links-new-tabs | https://github.com/ocdtrekkie/datasette-external-links-new-tabs/releases/tag/0.1 | 2022-10-07 | Initial release | 2022-10-07T04:42:30Z | [] |
| 236867027 | https://github.com/simonw/datasette-sentry | https://github.com/simonw/datasette-sentry/releases/tag/0.3 | 2022-10-06 | - Sentry errors now include information about the HTTP request again. [#4](https://github.com/simonw/datasette-sentry/issues/4) - New `sample_rate` plugin configuration option for setting the [Sentry sample rate](https://docs.sentry.io/platforms/python/configuration/sampling/) - accepts a floating point number between 0.0 and 1.0. [#2](https://github.com/simonw/datasette-sentry/issues/2) | 2022-10-06T22:31:29Z | ["datasette", "datasette-io", "datasette-plugin", "sentry"] |
| 245856731 | https://github.com/simonw/datasette-search-all | https://github.com/simonw/datasette-search-all/releases/tag/1.1 | 2022-10-05 | - Plugin now checks table permissions, and only attempts to search tables that the user has permission to view. [#16](https://github.com/simonw/datasette-search-all/issues/16) - Now requires Datasette 0.61 or higher | 2022-10-05T01:53:33Z | ["datasette", "datasette-io", "datasette-plugin", "search"] |
| 545764894 | https://github.com/simonw/datasette-public | https://github.com/simonw/datasette-public/releases/tag/0.1 | 2022-10-05 | - Initial release. Provides a mechanism for toggling specific tables public even if the overall Datasette instance is private. [#1](https://github.com/simonw/datasette-public/issues/1) | 2022-10-05T00:05:59Z | [] |
| 248385299 | https://github.com/simonw/datasette-publish-fly | https://github.com/simonw/datasette-publish-fly/releases/tag/1.2 | 2022-09-29 | - New `-o/--org` option for specifying the Fly organization to deploy to - defaults to "personal". [#22](https://github.com/simonw/datasette-publish-fly/issues/22) - Fixed bug where port no needs to be specified as an integer. [#21](https://github.com/simonw/datasette-publish-fly/issues/21) | 2022-09-29T17:25:15Z | ["datasette", "datasette-io", "datasette-plugin", "fly"] |
| 167730071 | https://github.com/simonw/datasette-pretty-json | https://github.com/simonw/datasette-pretty-json/releases/tag/0.2.2 | 2022-09-28 | - Fix for compatibility with latest Jinja. [#2](https://github.com/simonw/datasette-pretty-json/issues/2) | 2022-09-28T21:06:31Z | ["datasette", "datasette-io", "datasette-plugin", "json"] |
| 107914493 | https://github.com/simonw/datasette | https://github.com/simonw/datasette/releases/tag/0.63a0 | 2022-09-26 | - The [prepare_jinja2_environment(env, datasette)](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-prepare-jinja2-environment) plugin hook now accepts an optional `datasette` argument. Hook implementations can also now return an `async` function which will be awaited automatically. ([#1809](https://github.com/simonw/datasette/issues/1809)) - `--load-extension` option now supports entrypoints. Thanks, Alex Garcia. ([#1789](https://github.com/simonw/datasette/pull/1789)) - New tutorial: [Cleaning data with sqlite-utils and Datasette](https://datasette.io/tutorials/clean-data). - Facet size can now be set per-table with the new `facet_size` table metadata option. ([#1804](https://github.com/simonw/datasette/issues/1804)) - `truncate_cells_html` setting now also affects long URLs in columns. ([#1805](https://github.com/simonw/datasette/issues/1805)) - `Database(is_mutable=)` now defaults to `True`. ([#1808](https://github.com/simonw/datasette/issues/1808)) - Non-JavaScript textarea now increases height to fit the SQL query. ([#1786](https://github.com/simonw/datasette/issues/1786)) - More detailed command descriptions on the [CLI reference](https://docs.datasette.io/en/latest/cli-reference.html#cli-reference) page. ([#1787](https://github.com/simonw/datasette/issues/1787)) - Datasette no longer enforces upper bounds on its depenedencies. ([#1800](https://github.com/simonw/datasette/issues/1800)) - Facets are now displayed with better line-breaks in long values. Thanks, Daniel Rech. ([#1794](https://github.com/simonw/datasette/pull/1794)) - The `settings.json` file used in [Configuration directory mode](https://docs.datasette.io/en/latest/settings.html#config-dir) is now validated on startup. ([#1816](https://github.com/simonw/datasette/issues/1816)) | 2022-09-26T21:56:30Z | ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"] |
| 534735639 | https://github.com/simonw/datasette-sandstorm-support | https://github.com/simonw/datasette-sandstorm-support/releases/tag/0.2 | 2022-09-16 | - Additional permissions. Thanks, [@ocdtrekkie](https://github.com/ocdtrekkie). [#3](https://github.com/simonw/datasette-sandstorm-support/pull/3) | 2022-09-16T17:14:12Z | [] |
| 423984522 | https://github.com/simonw/s3-credentials | https://github.com/simonw/s3-credentials/releases/tag/0.14 | 2022-09-15 | - `s3-credentials put-objects` command ([docs](https://s3-credentials.readthedocs.io/en/stable/other-commands.html#put-objects)) for uploading more than one file or directory to an S3 bucket at a time. [#68](https://github.com/simonw/s3-credentials/issues/68) - `s3-credentials get-objects` command ([docs](https://s3-credentials.readthedocs.io/en/stable/other-commands.html#get-objects)) for downloading multiple files from an S3 bucket. [#78](https://github.com/simonw/s3-credentials/issues/78) | 2022-09-15T23:43:10Z | ["aws", "boto3", "s3"] |
| 467679579 | https://github.com/simonw/shot-scraper | https://github.com/simonw/shot-scraper/releases/tag/0.16 | 2022-09-15 | - Fixed error message displayed when attempting to use `--log-requests` on a page that includes a redirect. [#90](https://github.com/simonw/shot-scraper/issues/90) - `--log-requests` output now includes a `"status": 200` field indicating the HTTP status code returned by that response. | 2022-09-15T03:18:44Z | ["playwright", "playwright-python", "scraping", "screenshot-utility", "screenshots"] |
| 308930118 | https://github.com/simonw/datasette-edit-templates | https://github.com/simonw/datasette-edit-templates/releases/tag/0.1a0 | 2022-09-14 | - Initial alpha release. [#1](https://github.com/simonw/datasette-edit-templates/issues/1) | 2022-09-14T21:03:20Z | [] |
| 534735639 | https://github.com/simonw/datasette-sandstorm-support | https://github.com/simonw/datasette-sandstorm-support/releases/tag/0.1 | 2022-09-14 | - Initial release. | 2022-09-14T04:09:51Z | [] |
| 467679579 | https://github.com/simonw/shot-scraper | https://github.com/simonw/shot-scraper/releases/tag/0.15.1 | 2022-09-13 | - Fix error message shown when `--log-requests` tries to log a request with an unknown response size. [#89](https://github.com/simonw/shot-scraper/issues/89) | 2022-09-13T17:15:53Z | ["playwright", "playwright-python", "scraping", "screenshot-utility", "screenshots"] |
| 467679579 | https://github.com/simonw/shot-scraper | https://github.com/simonw/shot-scraper/releases/tag/0.15 | 2022-09-12 | - New [--log-requests option](https://shot-scraper.datasette.io/en/stable/screenshots.html#logging-all-requests) for logging out newline-delimited JSON showing all requests made while rendering a page, including image and asset loads. [#88](https://github.com/simonw/shot-scraper/issues/88) - New [shot-scraper pdf](https://shot-scraper.datasette.io/en/stable/pdf.html) formatting options: `--format`, `--width`, `--height`, `--scale` and `--print-background`. Thanks, Eddie Chapman. [#87](https://github.com/simonw/shot-scraper/pull/87) - Removed `-h` shortcut for help - use `--help` instead. `-h` was clashing with the shorter version of `--height`. Thanks, Matthew Bafford. [#84](https://github.com/simonw/shot-scraper/pull/84) | 2022-09-12T20:57:07Z | ["playwright", "playwright-python", "scraping", "screenshot-utility", "screenshots"] |
| 489156146 | https://github.com/simonw/datasette-upload-dbs | https://github.com/simonw/datasette-upload-dbs/releases/tag/0.1.2 | 2022-09-09 | - Uploaded databases are now treated as mutable - previously they were incorrectly configured to be immutable. [#6](https://github.com/simonw/datasette-upload-dbs/issues/6) | 2022-09-09T15:58:38Z | [] |
| 234825790 | https://github.com/simonw/datasette-upload-csvs | https://github.com/simonw/datasette-upload-csvs/releases/tag/0.8.2 | 2022-09-08 | - Removed debug print statement which would otherwise show up in log output. | 2022-09-08T20:15:33Z | ["csvs", "datasette", "datasette-io", "datasette-plugin"] |
| 234825790 | https://github.com/simonw/datasette-upload-csvs | https://github.com/simonw/datasette-upload-csvs/releases/tag/0.8.1 | 2022-09-08 | - Fixed compatibility bug where running this plugin at the same time as [datasette-upload-dbs](https://datasette.io/plugins/datasette-upload-dbs) could trigger errors. [#30](https://github.com/simonw/datasette-upload-csvs/issues/30) | 2022-09-08T19:51:53Z | ["csvs", "datasette", "datasette-io", "datasette-plugin"] |
| 234825790 | https://github.com/simonw/datasette-upload-csvs | https://github.com/simonw/datasette-upload-csvs/releases/tag/0.8 | 2022-09-08 | - The user now gets to confirm the name of the table to be created before uploading the file. [#17](https://github.com/simonw/datasette-upload-csvs/issues/17) - Column types are automatically detected based on the uploaded data. Previously all columns were TEXT columns. [#26](https://github.com/simonw/datasette-upload-csvs/issues/26) - If a table with the desired name already exists, a suffix of `_2` or higher is appended. [#29](https://github.com/simonw/datasette-upload-csvs/issues/29) - Fixed a bug where usage alongside a custom `base.html` template with `extra_head` content would be ignored. [#27](https://github.com/simonw/datasette-upload-csvs/issues/27) | 2022-09-08T17:07:41Z | ["csvs", "datasette", "datasette-io", "datasette-plugin"] |
| 532404547 | https://github.com/simonw/datasette-render-image-tags | https://github.com/simonw/datasette-render-image-tags/releases/tag/0.1 | 2022-09-04 | - Initial release. Cells containing a URL that end in an image extension will be converted into image tags with a width of 200 pixels. | 2022-09-04T00:48:32Z | [] |
| 530399214 | https://github.com/simonw/datasette-sitemap | https://github.com/simonw/datasette-sitemap/releases/tag/1.0 | 2022-08-30 | - This plugin now interacts correctly with the [datasette-block-robots](https://datasette.io/plugins/datasette-block-robots) plugin, adding the `Sitemap:` reference to the existing `robots.txt` file if that other plugin is installed. [#4](https://github.com/simonw/datasette-sitemap/issues/4) - Now registers a new [sitemap_extra_paths() plugin hook](https://github.com/simonw/datasette-sitemap/blob/1.0/README.md#adding-paths-to-the-sitemap-from-other-plugins) which other plugins can use to contribute to `/sitemap.xml`. [#5](https://github.com/simonw/datasette-sitemap/issues/5) | 2022-08-30T17:59:53Z | [] |
| 274293597 | https://github.com/simonw/datasette-block-robots | https://github.com/simonw/datasette-block-robots/releases/tag/1.1 | 2022-08-30 | - Now registers a new [block_robots_extra_lines() plugin hook](https://github.com/simonw/datasette-block-robots/blob/1.1/README.md#extending-this-with-other-plugins) which other plugins can use to contribute to `/robots.txt`. [#6](https://github.com/simonw/datasette-block-robots/issues/6) | 2022-08-30T16:25:38Z | ["datasette", "datasette-io", "datasette-plugin", "robots-txt"] |
| 530399214 | https://github.com/simonw/datasette-sitemap | https://github.com/simonw/datasette-sitemap/releases/tag/0.1.1 | 2022-08-29 | - Fixed error on `/robot.txt` page. [#2](https://github.com/simonw/datasette-sitemap/issues/2) | 2022-08-29T22:36:22Z | [] |
| 530399214 | https://github.com/simonw/datasette-sitemap | https://github.com/simonw/datasette-sitemap/releases/tag/0.1 | 2022-08-29 | - Initial release: configure a SQL query to return a `/sitemap.xml` for your site. [#1](https://github.com/simonw/datasette-sitemap/issues/1) | 2022-08-29T22:19:49Z | [] |
| 140912432 | https://github.com/simonw/sqlite-utils | https://github.com/simonw/sqlite-utils/releases/tag/3.29 | 2022-08-28 | - The `sqlite-utils query`, `memory` and `bulk` commands now all accept a new `--functions` option. This can be passed a string of Python code, and any callable objects defined in that code will be made available to SQL queries as custom SQL functions. See [Defining custom SQL functions](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-query-functions) for details. ([#471](https://github.com/simonw/sqlite-utils/issues/471)) - `db[table].create(...)` method now accepts a new `transform=True` parameter. If the table already exists it will be transform to match the schema configuration options passed to the function. This may result in columns being added or dropped, column types being changed, column order being updated or not null and default values for columns being set. ([#467](https://github.com/simonw/sqlite-utils/issues/467)) - Related to the above, the `sqlite-utils create-table` command now accepts a `--transform` option. - New introspection property: `table.default_values` returns a dictionary mapping each column name with a default value to the configured default value. ([#475](https://github.com/simonw/sqlite-utils/issues/475)) - The `--load-extension` option can now be provided a path to a compiled SQLite extension module accompanied by the name of an entrypoint, separated by a colon - for example `--load-extension ./lines0:sqlite3_lines0_noread_init`. This feature is modelled on code first [contributed to Datasette](https://github.com/simonw/datasette/pull/1789) by Alex Garcia. ([#470](https://github.com/simonw/sqlite-utils/issues/470)) - Functions registered using the [db.register_function()](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-register-function) method can now have a custom name specified using the new `db.register_function(fn, name=...)` parameter. ([#458](https://github.com/simonw/sqlite-utils/issues/458)) - [sqlite-utils rows](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-rows) has a new `--order` option for specifying the sort order for … | 2022-08-28T03:50:29Z | ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"] |
| 474473836 | https://github.com/hydrosquall/datasette-nteract-data-explorer | https://github.com/hydrosquall/datasette-nteract-data-explorer/releases/tag/0.4.2 | 2022-08-27 | ## What's Changed * fix(demo): build updated demo JS statics as part of build pipeline by @hydrosquall in https://github.com/hydrosquall/datasette-nteract-data-explorer/pull/24 * feat: proof of concept initialization hook for instantiating JS plugins in datasette-lite by @hydrosquall in https://github.com/hydrosquall/datasette-nteract-data-explorer/pull/26 * bump: version 0.4.2 by @hydrosquall in https://github.com/hydrosquall/datasette-nteract-data-explorer/pull/27 **Full Changelog**: https://github.com/hydrosquall/datasette-nteract-data-explorer/compare/0.4.1...0.4.2 | 2022-08-27T16:31:11Z | ["automatic-viz", "datasette", "datasette-plugin", "dataviz"] |
| 528611541 | https://github.com/simonw/datasette-multiline-links | https://github.com/simonw/datasette-multiline-links/releases/tag/0.1 | 2022-08-24 | - Initial working version. | 2022-08-24T22:31:53Z | [] |
| 253632948 | https://github.com/simonw/datasette-publish-vercel | https://github.com/simonw/datasette-publish-vercel/releases/tag/0.14.2 | 2022-08-24 | - Fixed bug where using boolean settings such as `--setting allow_downloads 0` would cause deployments to serve 500 errors. [#61](https://github.com/simonw/datasette-publish-vercel/issues/61) | 2022-08-24T17:43:41Z | ["datasette", "datasette-io", "datasette-plugin", "vercel", "zeit-now"] |
| 247527438 | https://github.com/simonw/datasette-edit-schema | https://github.com/simonw/datasette-edit-schema/releases/tag/0.5.1 | 2022-08-22 | - Fixed error trying to add new floating point columns to a table. [#34](https://github.com/simonw/datasette-edit-schema/issues/34) | 2022-08-22T22:45:58Z | ["datasette", "datasette-io", "datasette-plugin"] |
| 213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.2 | 2022-08-22 | - `-a` is now the shortcut for `--auth` - previously it was duplicated as a shortcut for `--all`. Thanks, [Thomas Lockney](https://github.com/tlockney). [#7](https://github.com/dogsheep/pocket-to-sqlite/issues/7) - `pocket-to-sqlite auth` command now updates the existing `auth.json` file rather than over-writing it. [#10](https://github.com/dogsheep/pocket-to-sqlite/issues/10) | 2022-08-22T16:21:34Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
| 526978148 | https://github.com/simonw/datasette-mp3-audio | https://github.com/simonw/datasette-mp3-audio/releases/tag/0.2 | 2022-08-20 | - Added a "Play all MP3s" button to any table page listing more than one MP3. [#2](https://github.com/simonw/datasette-mp3-audio/issues/2) | 2022-08-20T23:14:56Z | [] |
| 526978148 | https://github.com/simonw/datasette-mp3-audio | https://github.com/simonw/datasette-mp3-audio/releases/tag/0.1 | 2022-08-20 | - Initial release. Adds `<audio>` players to any table cell containing the URL to a `.mp3` file. [#1](https://github.com/simonw/datasette-mp3-audio/issues/1) | 2022-08-20T16:45:42Z | [] |
| 195145678 | https://github.com/simonw/sqlite-diffable | https://github.com/simonw/sqlite-diffable/releases/tag/0.5 | 2022-08-18 | - `sqlite-diffable objects path-to/table.ndjson` command for converting a newline-delimited file of JSON arrays into a sequence of JSON objects. [#7](https://github.com/simonw/sqlite-diffable/issues/7) | 2022-08-18T22:49:30Z | ["datasette-io", "datasette-tool", "sqlite"] |
| 236867027 | https://github.com/simonw/datasette-sentry | https://github.com/simonw/datasette-sentry/releases/tag/0.2 | 2022-08-14 | - Now uses the new [handle_exception()](https://docs.datasette.io/en/stable/plugin_hooks.html#handle-exception-datasette-request-exception) plugin hook introduced in [Datasette 0.62](https://docs.datasette.io/en/stable/changelog.html#v0-62). [#3](https://github.com/simonw/datasette-sentry/issues/3) | 2022-08-14T23:00:36Z | ["datasette", "datasette-io", "datasette-plugin", "sentry"] |
| 236867027 | https://github.com/simonw/datasette-sentry | https://github.com/simonw/datasette-sentry/releases/tag/0.2a1 | 2022-08-14 | - Preview of 0.2 for final testing. [#3](https://github.com/simonw/datasette-sentry/issues/3) | 2022-08-14T20:55:21Z | ["datasette", "datasette-io", "datasette-plugin", "sentry"] |
| 107914493 | https://github.com/simonw/datasette | https://github.com/simonw/datasette/releases/tag/0.62 | 2022-08-14 | Datasette can now run entirely in your browser using WebAssembly. Try out [Datasette Lite](https://lite.datasette.io/), take a look [at the code](https://github.com/simonw/datasette-lite) or read more about it in [Datasette Lite: a server-side Python web application running in a browser](https://simonwillison.net/2022/May/4/datasette-lite/). Datasette now has a [Discord community](https://discord.gg/ktd74dm5mw) for questions and discussions about Datasette and its ecosystem of projects. ## Features - Datasette is now compatible with [Pyodide](https://pyodide.org/). This is the enabling technology behind [Datasette Lite](https://lite.datasette.io/). ([#1733](https://github.com/simonw/datasette/issues/1733)) - Database file downloads now implement conditional GET using ETags. ([#1739](https://github.com/simonw/datasette/issues/1739)) - HTML for facet results and suggested results has been extracted out into new templates `_facet_results.html` and `_suggested_facets.html`. Thanks, M. Nasimul Haque. ([#1759](https://github.com/simonw/datasette/pull/1759)) - Datasette now runs some SQL queries in parallel. This has limited impact on performance, see [this research issue](https://github.com/simonw/datasette/issues/1727) for details. - New `--nolock` option for ignoring file locks when opening read-only databases. ([#1744](https://github.com/simonw/datasette/issues/1744)) - Spaces in the database names in URLs are now encoded as `+` rather than `~20`. ([#1701](https://github.com/simonw/datasette/issues/1701)) - `<Binary: 2427344 bytes>` is now displayed as `<Binary: 2,427,344 bytes>` and is accompanied by tooltip showing "2.3MB". ([#1712](https://github.com/simonw/datasette/issues/1712)) - The base Docker image used by `datasette publish cloudrun`, `datasette package` and the [official Datasette image](https://hub.docker.com/datasetteproject/datasette) has been upgraded to `3.10.6-slim-bullseye`. ([#1768](https://github.com/simonw/datasette/issues/1768)) - Canned writable queries again… | 2022-08-14T17:43:05Z | ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"] |
| 423984522 | https://github.com/simonw/s3-credentials | https://github.com/simonw/s3-credentials/releases/tag/0.13 | 2022-08-12 | - Documentation now lives on a dedicated documentation website: https://s3-credentials.readthedocs.io/ [#71](https://github.com/simonw/s3-credentials/issues/71) - `s3-credentials create ... --website --create-bucket` now creates an S3 bucket that is configured to act as a website, with `index.html` an the index page and `error.html` as the page used for any errors. [#21](https://github.com/simonw/s3-credentials/issues/21) - `s3-credentials list-buckets --details` now returns the bucket region and the URL to the website, if it is configured to act as a website. [#77](https://github.com/simonw/s3-credentials/issues/77) - Fixed a bug where `list-bucket` would return an error if the bucket (or specified `--prefix`) was empty. [#76](https://github.com/simonw/s3-credentials/issues/76) | 2022-08-12T18:21:02Z | ["aws", "boto3", "s3"] |
| 508461227 | https://github.com/simonw/s3-ocr | https://github.com/simonw/s3-ocr/releases/tag/0.6.3 | 2022-08-10 | - Pages with no OCR text on them are now recorded as rows with empty strings, instead of being skipped entirely. [#23](https://github.com/simonw/s3-ocr/issues/23) | 2022-08-10T04:43:17Z | ["ocr", "s3", "textract"] |
| 508461227 | https://github.com/simonw/s3-ocr | https://github.com/simonw/s3-ocr/releases/tag/0.6.2 | 2022-08-09 | - Fixed bug where commands were sometimes not properly registered. [#26](https://github.com/simonw/s3-ocr/issues/26) | 2022-08-09T20:35:32Z | ["ocr", "s3", "textract"] |
| 508461227 | https://github.com/simonw/s3-ocr | https://github.com/simonw/s3-ocr/releases/tag/0.6.1 | 2022-08-09 | - Now pins to `click>=8.0`, which should avoid a bug where installing this on a machine with an older version of Click present would lead to the commands failing to register. [#25](https://github.com/simonw/s3-ocr/issues/25) - `s3-ocr --help` now includes links to the documentation and changelog. | 2022-08-09T19:40:19Z | ["ocr", "s3", "textract"] |
| 474473836 | https://github.com/hydrosquall/datasette-nteract-data-explorer | https://github.com/hydrosquall/datasette-nteract-data-explorer/releases/tag/0.4.1 | 2022-08-08 | ## What's Changed * feat: add demo site landing page by @hydrosquall in https://github.com/hydrosquall/datasette-nteract-data-explorer/pull/14 * feature: synchronize graph state to URL parameters, enabling permalinking + sharing graphs by @hydrosquall in https://github.com/hydrosquall/datasette-nteract-data-explorer/pull/19 * Added PR templates + Issue contributing guide **Full Changelog**: https://github.com/hydrosquall/datasette-nteract-data-explorer/compare/0.3.1...0.4.1 | 2022-08-08T20:02:05Z | ["automatic-viz", "datasette", "datasette-plugin", "dataviz"] |
| 474473836 | https://github.com/hydrosquall/datasette-nteract-data-explorer | https://github.com/hydrosquall/datasette-nteract-data-explorer/releases/tag/0.4.0 | 2022-08-08 | _ignore_ - see 0.4.1. | 2022-08-08T19:50:34Z | ["automatic-viz", "datasette", "datasette-plugin", "dataviz"] |
| 508461227 | https://github.com/simonw/s3-ocr | https://github.com/simonw/s3-ocr/releases/tag/0.6 | 2022-08-07 | - `s3-ocr start` now automatically pauses and then retries if Textract complains that there are too many jobs running. This can be turned into an early exit with an error message using the new `--no-retry` option. [#21](https://github.com/simonw/s3-ocr/issues/21) - New `s3-ocr start --dry-run` option for displaying what would happen without starting the OCR process. [#22](https://github.com/simonw/s3-ocr/issues/22) - Textract now runs in the same region as the S3 bucket it is writing to, avoiding an error. [#24](https://github.com/simonw/s3-ocr/issues/24) | 2022-08-07T17:42:07Z | ["ocr", "s3", "textract"] |
| 506026919 | https://github.com/simonw/datasette-scale-to-zero | https://github.com/simonw/datasette-scale-to-zero/releases/tag/0.2 | 2022-08-05 | - New `"max-age": "10h"` configuration setting, which causes the server to exit after the specified amount of time whether or not it has received any traffic. [#3](https://github.com/simonw/datasette-scale-to-zero/issues/3) | 2022-08-05T22:29:17Z | ["datasette", "datasette-plugin"] |
| 467679579 | https://github.com/simonw/shot-scraper | https://github.com/simonw/shot-scraper/releases/tag/0.14.3 | 2022-08-02 | - Improved example workflow in [Optimizing PNGs using Oxipng](https://shot-scraper.datasette.io/en/stable/github-actions.html#optimizing-pngs-using-oxipng). - Fixed typos in README and documentation. [#83](https://github.com/simonw/shot-scraper/pull/83) | 2022-08-02T23:41:37Z | ["playwright", "playwright-python", "scraping", "screenshot-utility", "screenshots"] |
| 423984522 | https://github.com/simonw/s3-credentials | https://github.com/simonw/s3-credentials/releases/tag/0.12.1 | 2022-08-01 | - Using the `--policy` or `--statement` options now implies `--user-permissions-boundary=none`. Previously it was easy to use these options to accidentally create credentials that did not work as expected since they would have a default permissions boundary that locked them down to only being able to access S3. [#74](https://github.com/simonw/s3-credentials/issues/74) - The `s3-credentials.AmazonS3FullAccess` role created by this tool in order to issue temporary credentials previously used the default `MaxSessionDuration` value of 3600, preventing it from creating credentials that could last more than an hour. This has been increased to 12 hours. See [this issue comment](https://github.com/simonw/s3-credentials/issues/75#issuecomment-1201643771) for instructions on fixing your existing role if this bug is affecting your account. [#75](https://github.com/simonw/s3-credentials/issues/75) | 2022-08-01T19:50:53Z | ["aws", "boto3", "s3"] |
| 163790822 | https://github.com/simonw/datasette-sqlite-fts4 | https://github.com/simonw/datasette-sqlite-fts4/releases/tag/0.3.2 | 2022-07-31 | - Now depends on [sqlite-fts4 1.0.3](https://github.com/simonw/sqlite-fts4/releases/tag/1.0.3) | 2022-07-31T14:46:26Z | ["datasette", "datasette-io", "datasette-plugin", "plugin"] |
| 467679579 | https://github.com/simonw/shot-scraper | https://github.com/simonw/shot-scraper/releases/tag/0.14.2 | 2022-07-28 | - Documentation improvements. [0.14.1...0.14.2](https://github.com/simonw/shot-scraper/compare/0.14.1...0.14.2) | 2022-07-28T18:32:10Z | ["playwright", "playwright-python", "scraping", "screenshot-utility", "screenshots"] |
| 163790822 | https://github.com/simonw/datasette-sqlite-fts4 | https://github.com/simonw/datasette-sqlite-fts4/releases/tag/0.3.1 | 2022-07-28 | - Now depends on [sqlite-fts4 1.0.2](https://github.com/simonw/sqlite-fts4/releases/tag/1.0.2) for compatibility with big-endian systems. | 2022-07-28T16:47:54Z | ["datasette", "datasette-io", "datasette-plugin", "plugin"] |
| 253632948 | https://github.com/simonw/datasette-publish-vercel | https://github.com/simonw/datasette-publish-vercel/releases/tag/0.14.1 | 2022-07-23 | - Fix for 500 error when run with latest `@vercel/python` [#58](https://github.com/simonw/datasette-publish-vercel/issues/58) | 2022-07-23T02:58:36Z | ["datasette", "datasette-io", "datasette-plugin", "vercel", "zeit-now"] |
| 280500027 | https://github.com/simonw/datasette-insert | https://github.com/simonw/datasette-insert/releases/tag/0.8 | 2022-07-22 | - Now serves CORS headers if Datasette is started with the `--cors` option. [#17](https://github.com/simonw/datasette-insert/issues/17) | 2022-07-22T17:52:23Z | ["datasette", "datasette-io", "datasette-plugin"] |
| 508461227 | https://github.com/simonw/s3-ocr | https://github.com/simonw/s3-ocr/releases/tag/0.5 | 2022-07-19 | - Ability to run OCR against just the PDF files contained within a specific folder in the S3 bucket, using `s3-ocr start my-bucket --prefix my-prefix/`. [#20](https://github.com/simonw/s3-ocr/issues/20) - New command: `s3-ocr dedupe my-bucket` - scans the bucket for any new files that are duplicates of files that have already been OCRd and writes out job results to reuse existing OCR results and avoid processing them a second time in the future. [#19](https://github.com/simonw/s3-ocr/issues/19) | 2022-07-19T02:35:36Z | ["ocr", "s3", "textract"] |
| 284383265 | https://github.com/simonw/datasette-graphql | https://github.com/simonw/datasette-graphql/releases/tag/2.1.1 | 2022-07-18 | - Simplified example code in the documentation for the `graphql_extra_fields()` hook. - Workaround for a bug where some tables could cause a 500 error on the regular table view page. [#90](https://github.com/simonw/datasette-graphql/issues/90) | 2022-07-18T21:13:34Z | ["datasette", "datasette-io", "datasette-plugin", "graphql", "sqlite"] |
| 236867027 | https://github.com/simonw/datasette-sentry | https://github.com/simonw/datasette-sentry/releases/tag/0.2a0 | 2022-07-18 | - Use new `handle_exception()` hook added in Datasette 0.61a1. [#1](https://github.com/simonw/datasette-sentry/issues/1) | 2022-07-18T20:30:04Z | ["datasette", "datasette-io", "datasette-plugin", "sentry"] |
| 107914493 | https://github.com/simonw/datasette | https://github.com/simonw/datasette/releases/tag/0.62a1 | 2022-07-18 | - New plugin hook: [handle_exception()](https://docs.datasette.io/en/stable/plugin_hooks.html#plugin-hook-handle-exception), for custom handling of exceptions caught by Datasette. ([#1770](https://github.com/simonw/datasette/issues/1770)) - The [render_cell()](https://docs.datasette.io/en/stable/plugin_hooks.html#plugin-hook-render-cell) plugin hook is now also passed a `row` argument, representing the `sqlite3.Row` object that is being rendered. ([#1300](https://github.com/simonw/datasette/issues/1300)) - New `--nolock` option for ignoring file locks when opening read-only databases. ([#1744](https://github.com/simonw/datasette/issues/1744)) - Documentation now uses the [Furo](https://github.com/pradyunsg/furo) Sphinx theme. ([#1746](https://github.com/simonw/datasette/issues/1746)) - Datasette now has a [Discord community](https://discord.gg/ktd74dm5mw). - Database file downloads now implement conditional GET using ETags. ([#1739](https://github.com/simonw/datasette/issues/1739)) - Examples in the documentation now include a copy-to-clipboard button. ([#1748](https://github.com/simonw/datasette/issues/1748)) - HTML for facet results and suggested results has been extracted out into new templates `_facet_results.html` and `_suggested_facets.html`. Thanks, M. Nasimul Haque. ([#1759](https://github.com/simonw/datasette/pull/1759)) | 2022-07-18T01:09:05Z | ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"] |
| 140912432 | https://github.com/simonw/sqlite-utils | https://github.com/simonw/sqlite-utils/releases/tag/3.28 | 2022-07-15 | - New [table.duplicate(new_name)](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-duplicate) method for creating a copy of a table with a matching schema and row contents. Thanks, [David](https://github.com/davidleejy). ([#449](https://github.com/simonw/sqlite-utils/issues/449)) - New `sqlite-utils duplicate data.db table_name new_name` CLI command for [Duplicating tables](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-duplicate-table). ([#454](https://github.com/simonw/sqlite-utils/issues/454)) - `sqlite_utils.utils.rows_from_file()` is now a [documented API](https://sqlite-utils.datasette.io/en/stable/reference.html#reference-utils-rows-from-file). It can be used to read a sequence of dictionaries from a file-like object containing CSV, TSV, JSON or newline-delimited JSON. It can be passed an explicit format or can attempt to detect the format automatically. ([#443](https://github.com/simonw/sqlite-utils/issues/443)) - `sqlite_utils.utils.TypeTracker` is now a documented API for detecting the likely column types for a sequence of string rows, see [Detecting column types using TypeTracker](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-typetracker). ([#445](https://github.com/simonw/sqlite-utils/issues/445)) - `sqlite_utils.utils.chunks()` is now a documented API for [splitting an iterator into chunks](https://sqlite-utils.datasette.io/en/stable/reference.html#reference-utils-chunks). ([#451](https://github.com/simonw/sqlite-utils/issues/451)) - `sqlite-utils enable-fts` now has a `--replace` option for replacing the existing FTS configuration for a table. ([#450](https://github.com/simonw/sqlite-utils/issues/450)) - The `create-index`, `add-column` and `duplicate` commands all now take a `--ignore` option for ignoring errors should the database not be in the right state for them to operate. ([#450](https://github.com/simonw/sqlite-utils/issues/450)) | 2022-07-15T23:02:45Z | ["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.14 | 2022-07-13 | - Fixed bug caused by removal of `--no-clipboard` option in [Vercel 27.0.0](https://github.com/vercel/vercel/releases/tag/vercel%4027.0.0). [#57](https://github.com/simonw/datasette-publish-vercel/issues/57) - Errors that occur when running the `vercel` command are now reflected in the exit status of `datasette publish vercel`. | 2022-07-13T15:48:22Z | ["datasette", "datasette-io", "datasette-plugin", "vercel", "zeit-now"] |
| 399308604 | https://github.com/simonw/datasette-app | https://github.com/simonw/datasette-app/releases/tag/0.2.2 | 2022-07-13 | - Fixed bug where application could crash on launch. Thanks, [Michael C](https://github.com/simonw/datasette-app-support/pull/20). [#139](https://github.com/simonw/datasette-app/issues/139) - Upgraded to Electron 19 and latest Datasette | 2022-07-13T01:08:17Z | ["datasette"] |
| 399308604 | https://github.com/simonw/datasette-app | https://github.com/simonw/datasette-app/releases/tag/0.2.2 | 2022-07-13 | - Fixed bug where application could crash on launch. Thanks, [Michael C](https://github.com/simonw/datasette-app-support/pull/20). [#139](https://github.com/simonw/datasette-app/issues/139) - Upgraded to Electron 19 and latest Datasette | 2022-07-13T00:20:06Z | ["datasette"] |
| 511787166 | https://github.com/simonw/sqlite-comprehend | https://github.com/simonw/sqlite-comprehend/releases/tag/0.2.2 | 2022-07-12 | - Improvements to the documentation. | 2022-07-12T14:21:43Z | [] |
| 243710733 | https://github.com/simonw/datasette-ics | https://github.com/simonw/datasette-ics/releases/tag/0.5.2 | 2022-07-12 | - Fix `ImportError` bug by upgrading to `ics` 0.7.2. [#6](https://github.com/simonw/datasette-ics/issues/6) | 2022-07-12T02:08:11Z | ["datasette", "datasette-io", "datasette-plugin", "icalendar", "ics"] |
| 511787166 | https://github.com/simonw/sqlite-comprehend | https://github.com/simonw/sqlite-comprehend/releases/tag/0.2.1 | 2022-07-11 | - Fixed bug where commands failed to be correctly registered on Linux systems. [#11](https://github.com/simonw/sqlite-comprehend/issues/11) | 2022-07-11T19:33:28Z | [] |
| 511787166 | https://github.com/simonw/sqlite-comprehend | https://github.com/simonw/sqlite-comprehend/releases/tag/0.2 | 2022-07-11 | - `sqlite-comprehend entities --strip-tags` option for stripping HTML tags before sending content to the entity extraction API. [#9](https://github.com/simonw/sqlite-comprehend/issues/9) | 2022-07-11T19:13:02Z | [] |
| 195145678 | https://github.com/simonw/sqlite-diffable | https://github.com/simonw/sqlite-diffable/releases/tag/0.4 | 2022-07-11 | - `sqlite-diffable load ... --replace` option to replace tables that already exist in the destination database file. [#6](https://github.com/simonw/sqlite-diffable/issues/6) | 2022-07-11T16:48:46Z | ["datasette-io", "datasette-tool", "sqlite"] |
| 195145678 | https://github.com/simonw/sqlite-diffable | https://github.com/simonw/sqlite-diffable/releases/tag/0.3 | 2022-07-08 | - New `sqlite-diffable load` command for restoring a previously dumped database. [#3](https://github.com/simonw/sqlite-diffable/issues/3) | 2022-07-08T23:33:16Z | ["datasette-io", "datasette-tool", "sqlite"] |
| 511787166 | https://github.com/simonw/sqlite-comprehend | https://github.com/simonw/sqlite-comprehend/releases/tag/0.1 | 2022-07-08 | - Documentation, in the [README](https://github.com/simonw/sqlite-comprehend/blob/main/README.md). [#3](https://github.com/simonw/sqlite-comprehend/issues/3) - New schema design, with a separate `comprehend_entities` table. [#4](https://github.com/simonw/sqlite-comprehend/issues/4) - Running the command multiple times will not re-submit rows that have already been processed. [#7](https://github.com/simonw/sqlite-comprehend/issues/7) - Errors from the Comprehend API are now logged to standard error. [#8](https://github.com/simonw/sqlite-comprehend/issues/8) | 2022-07-08T20:01:38Z | [] |
| 511787166 | https://github.com/simonw/sqlite-comprehend | https://github.com/simonw/sqlite-comprehend/releases/tag/0.1a0 | 2022-07-08 | - Initial prototype. [#1](https://github.com/simonw/sqlite-comprehend/issues/1) | 2022-07-08T06:30:05Z | [] |
| 430224716 | https://github.com/simonw/datasette-redirect-to-https | https://github.com/simonw/datasette-redirect-to-https/releases/tag/0.2 | 2022-07-04 | - Optional support for `x-forwarded-proto: http` headers, using a new configuration setting. [#2](https://github.com/simonw/datasette-redirect-to-https/issues/2) | 2022-07-04T01:02:25Z | ["asgi", "datasette", "datasette-io", "datasette-plugin"] |
| 510136835 | https://github.com/simonw/datasette-expose-env | https://github.com/simonw/datasette-expose-env/releases/tag/0.1 | 2022-07-03 | - Initial release: configure this plugin to expose specific environment variables at `/-/env`. [#1](https://github.com/simonw/datasette-expose-env/issues/1) | 2022-07-03T21:28:55Z | ["datasette", "datasette-plugin"] |
| 234825790 | https://github.com/simonw/datasette-upload-csvs | https://github.com/simonw/datasette-upload-csvs/releases/tag/0.7.2 | 2022-07-03 | - Fixed bug where encoding of file was not correctly detected if non-ASCII characters occurred after the first 2KB. The tool now inspects the first 2MB of content (as originally intended) and also upgrades ASCII to `latin-1` since ASCII is a complete subset of `latin-1` and using `latin-1` increases the chance of a successful import. [#25](https://github.com/simonw/datasette-upload-csvs/issues/25) | 2022-07-03T20:59:48Z | ["csvs", "datasette", "datasette-io", "datasette-plugin"] |
| 474176116 | https://github.com/simonw/datasette-packages | https://github.com/simonw/datasette-packages/releases/tag/0.2 | 2022-07-03 | - Now exposes a `packages` GraphQL field if you also have version 2.1 or higher of the [datasette-graphql plugin](https://datasette.io/plugins/datasette-graphql) installed. [#4](https://github.com/simonw/datasette-packages/issues/4) | 2022-07-03T02:29:02Z | [] |
| 284383265 | https://github.com/simonw/datasette-graphql | https://github.com/simonw/datasette-graphql/releases/tag/2.1 | 2022-07-03 | - New [graphql_extra_fields() plugin hook](https://datasette.io/plugins/datasette-graphql#user-content-adding-custom-fields-with-plugins) allowing other plugins to add extra fields to the GraphQL schema. [#69](https://github.com/simonw/datasette-graphql/issues/69) | 2022-07-03T01:19:01Z | ["datasette", "datasette-io", "datasette-plugin", "graphql", "sqlite"] |
| 499911426 | https://github.com/eyeseast/datasette-query-files | https://github.com/eyeseast/datasette-query-files/releases/tag/v0.1.1 | 2022-07-02 | 2022-07-02T20:40:51Z | ["datasette", "datasette-plugin", "python", "sql", "sqlite"] | |
| 247527438 | https://github.com/simonw/datasette-edit-schema | https://github.com/simonw/datasette-edit-schema/releases/tag/0.5 | 2022-07-01 | - More human-friendly labels for column types. [#29](https://github.com/simonw/datasette-edit-schema/issues/29) - `edit-schema` permission check now considers the database name. [#32](https://github.com/simonw/datasette-edit-schema/issues/32) - Now depends on `datasette>=0.59` [#30](https://github.com/simonw/datasette-edit-schema/issues/30) and `sqlite-utils>=3.10`. [#33](https://github.com/simonw/datasette-edit-schema/issues/33) | 2022-07-01T23:15:59Z | ["datasette", "datasette-io", "datasette-plugin"] |
| 508461227 | https://github.com/simonw/s3-ocr | https://github.com/simonw/s3-ocr/releases/tag/0.4 | 2022-06-30 | - New command: `s3-ocr inspect-job <job_id>` returns information about the status of a specific job. [#15](https://github.com/simonw/s3-ocr/issues/15) - Added a live demo at [s3-ocr-demo.datasette.io](https://s3-ocr-demo.datasette.io/). [#16](https://github.com/simonw/s3-ocr/issues/16) | 2022-06-30T21:03:44Z | ["ocr", "s3", "textract"] |
| 423984522 | https://github.com/simonw/s3-credentials | https://github.com/simonw/s3-credentials/releases/tag/0.12 | 2022-06-30 | - New `--statement JSON` option for both the `s3-credentials create` and `s3-credentials policy` commands, allowing one or more additional policy statements (provided as JSON strings) to be added to the generated IAM policy. [#72](https://github.com/simonw/s3-credentials/issues/72) | 2022-06-30T20:02:53Z | ["aws", "boto3", "s3"] |
| 508461227 | https://github.com/simonw/s3-ocr | https://github.com/simonw/s3-ocr/releases/tag/0.3 | 2022-06-30 | First non-alpha release. - Breaking change: the order of arguments for `s3-ocr index <bucket> <database_file>` has been swapped, for consistency with other commands. [#9](https://github.com/simonw/s3-ocr/issues/9) - Breaking change: the `start` command no longer defaults to processing every `.pdf` file in the bucket. It now accepts a list of keys, or use the `--all` option to process every PDF file. [#10](https://github.com/simonw/s3-ocr/issues/10) - New `s3-ocr fetch <bucket> <path>` command for fetching the raw OCR JSON data for that file. [#7](https://github.com/simonw/s3-ocr/issues/7) - New `s3-ocr text <bucket> <path>` command for outputting just the extracted OCR text for a specified file. [#8](https://github.com/simonw/s3-ocr/issues/8) | 2022-06-30T00:44:10Z | ["ocr", "s3", "textract"] |
| 508461227 | https://github.com/simonw/s3-ocr | https://github.com/simonw/s3-ocr/releases/tag/0.2a0 | 2022-06-29 | - New `s3-ocr index database.db name-of-bucket` command for creating a SQLite database containing the OCR results that have been written to the bucket. [#2](https://github.com/simonw/s3-ocr/issues/2) | 2022-06-29T19:35:21Z | ["ocr", "s3", "textract"] |
| 508461227 | https://github.com/simonw/s3-ocr | https://github.com/simonw/s3-ocr/releases/tag/0.1a0 | 2022-06-29 | - `s3-ocr start <bucket>` command for triggering OCR runs using [Textract](https://aws.amazon.com/textract/) for every PDF file in a bucket. [#1](https://github.com/simonw/s3-ocr/issues/1) - `s3-ocr status <bucket>` command for checking on the status of the ongoing OCR tasks. | 2022-06-29T02:53:10Z | ["ocr", "s3", "textract"] |
| 506026919 | https://github.com/simonw/datasette-scale-to-zero | https://github.com/simonw/datasette-scale-to-zero/releases/tag/0.1.2 | 2022-06-23 | - No longer logs a traceback on server exit. [#2](https://github.com/simonw/datasette-scale-to-zero/issues/2) | 2022-06-23T00:06:21Z | ["datasette", "datasette-plugin"] |
| 506026919 | https://github.com/simonw/datasette-scale-to-zero | https://github.com/simonw/datasette-scale-to-zero/releases/tag/0.1.1 | 2022-06-22 | - Reduced log output when server exits. [#2](https://github.com/simonw/datasette-scale-to-zero/issues/2) | 2022-06-22T00:07:40Z | ["datasette", "datasette-plugin"] |
| 506026919 | https://github.com/simonw/datasette-scale-to-zero | https://github.com/simonw/datasette-scale-to-zero/releases/tag/0.1 | 2022-06-21 | - Initial release. Can be configured to cause Datasette to exit if it has not received traffic in a specified time period. [#1](https://github.com/simonw/datasette-scale-to-zero/issues/1) | 2022-06-21T22:51:59Z | ["datasette", "datasette-plugin"] |
| 501303242 | https://github.com/simonw/datasette-socrata | https://github.com/simonw/datasette-socrata/releases/tag/0.3 | 2022-06-17 | - Any errors that occur during an import are now stored in the `errors` column of the `socrata_imports` table, and displayed by the JavaScript progress indicator. [#12](https://github.com/simonw/datasette-socrata/issues/12) - CSV imports with long field values no longer trigger an error. [#13](https://github.com/simonw/datasette-socrata/issues/13) - Progress bars now show the number of records imported and remaining, and hint to refresh the page when the import is complete. [#10](https://github.com/simonw/datasette-socrata/issues/10) - Checks for low disk space using the plugin hook provided by [datasette-low-disk-space-hook](https://github.com/simonw/datasette-low-disk-space-hook). [#4](https://github.com/simonw/datasette-socrata/issues/4) | 2022-06-17T20:29:53Z | [] |
| 140912432 | https://github.com/simonw/sqlite-utils | https://github.com/simonw/sqlite-utils/releases/tag/3.27 | 2022-06-15 | See also [the annotated release notes](https://simonwillison.net/2022/Jun/19/weeknotes/#sqlite-utils-3-27) for this release. - Documentation now uses the [Furo](https://github.com/pradyunsg/furo) Sphinx theme. ([#435](https://github.com/simonw/sqlite-utils/issues/435)) - Code examples in documentation now have a "copy to clipboard" button. ([#436](https://github.com/simonw/sqlite-utils/issues/436)) - `sqlite_utils.utils.utils.rows_from_file()` is now a documented API, see [Reading rows from a file](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-rows-from-file). ([#443](https://github.com/simonw/sqlite-utils/issues/443)) - `rows_from_file()` has two new parameters to help handle CSV files with rows that contain more values than are listed in that CSV file's headings: `ignore_extras=True` and `extras_key="name-of-key"`. ([#440](https://github.com/simonw/sqlite-utils/issues/440)) - `sqlite_utils.utils.maximize_csv_field_size_limit()` helper function for increasing the field size limit for reading CSV files to its maximum, see [Setting the maximum CSV field size limit](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-maximize-csv-field-size-limit). ([#442](https://github.com/simonw/sqlite-utils/issues/442)) - `table.search(where=, where_args=)` parameters for adding additional `WHERE` clauses to a search query. The `where=` parameter is available on `table.search_sql(...)` as well. See [Searching with table.search()](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-fts-search). ([#441](https://github.com/simonw/sqlite-utils/issues/441)) - Fixed bug where `table.detect_fts()` and other search-related functions could fail if two FTS-enabled tables had names that were prefixes of each other. ([#434](https://github.com/simonw/sqlite-utils/issues/434)) | 2022-06-15T04:34:45Z | ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"] |
Advanced export
JSON shape: default, array, newline-delimited
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;