recent_releases (view)
234 rows where topics contains "python" sorted by body_markdown
This data as json, CSV (advanced)
Suggested facets: rowid, repo, topics, date (date), published_at (date)
topics (array) 15 ✖
- datasette 234
- datasette-io 234
- python · 234 ✖
- sqlite 234
- asgi 126
- automatic-api 126
- csv 126
- datasets 126
- docker 126
- json 126
- sql 126
- cli 108
- click 108
- datasette-tool 108
- sqlite-database 108
rowid | repo | release | date | body_markdown ▼ | published_at | topics |
---|---|---|---|---|---|---|
107914493 | https://github.com/simonw/datasette | https://github.com/simonw/datasette/releases/tag/0.45a5 | 2020-07-01 | 2020-07-01T04:27:08Z | ["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.45a4 | 2020-06-29 | 2020-06-29T02:33:02Z | ["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.45a3 | 2020-06-28 | 2020-06-28T03:27:12Z | ["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.45a2 | 2020-06-24 | 2020-06-24T04:32:12Z | ["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.45a1 | 2020-06-19 | 2020-06-19T00:02: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.45a0 | 2020-06-18 | 2020-06-18T21:14:00Z | ["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.16 | 2018-04-13 | - Better mechanism for handling errors; 404s for missing table/database New error mechanism closes [#193](https://github.com/simonw/datasette/issues/193) 404s for missing tables/databases closes [#184](https://github.com/simonw/datasette/issues/184) - long\_description in markdown for the new PyPI - Hide Spatialite system tables. \[Russ Garrett\] - Allow `explain select` / `explain query plan select` [#201](https://github.com/simonw/datasette/issues/201) - Datasette inspect now finds primary\_keys [#195](https://github.com/simonw/datasette/issues/195) - Ability to sort using form fields (for mobile portrait mode) [#199](https://github.com/simonw/datasette/issues/199) We now display sort options as a select box plus a descending checkbox, which means you can apply sort orders even in portrait mode on a mobile phone where the column headers are hidden. | 2018-04-13T21:10:53Z | ["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.13 | 2017-11-25 | # 0.13 (2017-11-24) - Search now applies to current filters. Combined search into the same form as filters. Closes [\#133](https://github.com/simonw/datasette/issues/133) - Much tidier design for table view header. Closes [\#147](https://github.com/simonw/datasette/issues/147) - Added `?column__not=blah` filter. Closes [\#148](https://github.c) - Row page now resolves foreign keys. Closes [\#132]() - Further tweaks to select/input filter styling. Refs [\#86]() - thanks for the help, @natbat\! - Show linked foreign key in table cells. - Added UI for editing table filters. Refs [\#86]() - Hide FTS-created tables on index pages. Closes [\#129]() - Add publish to heroku support \[Jacob Kaplan-Moss\] `datasette publish heroku mydb.db` Pull request [\#104]() - Initial implementation of `?_group_count=column`. URL shortcut for counting rows grouped by one or more columns. `?_group_count=column1&_group_count=column2` works as well. SQL generated looks like this: select "qSpecies", count(*) as "count" from Street_Tree_List group by "qSpecies" order by "count" desc limit 100 Or for two columns like this: select "qSpecies", "qSiteInfo", count(*) as "count" from Street_Tree_List group by "qSpecies", "qSiteInfo" order by "count" desc limit 100 Refs [\#44]() - Added `--build=master` option to datasette publish and package. The `datasette publish` and `datasette package` commands both now accept an optional `--build` argument. If provided, this can be used to specify a branch published to GitHub that should be built into the container. This makes it easier to test code that has not yet been officially released to PyPI, e.g.: datasette publish now mydb.db --branch=master … | 2017-11-25T03:44:46Z | ["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.60 | 2022-01-14 | ### Plugins and internals - New plugin hook: [filters_from_request(request, database, table, datasette)](https://docs.datasette.io/en/stable/plugin_hooks.html#plugin-hook-filters-from-request), which runs on the table page and can be used to support new custom query string parameters that modify the SQL query. ([#473](https://github.com/simonw/datasette/issues/473)) - Added two additional methods for writing to the database: [await db.execute_write_script(sql, block=True)](https://docs.datasette.io/en/stable/internals.html#database-execute-write-script) and [await db.execute_write_many(sql, params_seq, block=True)](https://docs.datasette.io/en/stable/internals.html#database-execute-write-many). ([#1570](https://github.com/simonw/datasette/issues/1570)) - The [db.execute_write()](https://docs.datasette.io/en/stable/internals.html#database-execute-write) internal method now defaults to blocking until the write operation has completed. Previously it defaulted to queuing the write and then continuing to run code while the write was in the queue. ([#1579](https://github.com/simonw/datasette/issues/1579)) - Database write connections now execute the [prepare_connection(conn, database, datasette)](https://docs.datasette.io/en/stable/plugin_hooks.html#plugin-hook-prepare-connection) plugin hook. ([#1564](https://github.com/simonw/datasette/issues/1564)) - The `Datasette()` constructor no longer requires the `files=` argument, and is now documented at [Datasette class](https://docs.datasette.io/en/stable/internals.html#internals-datasette). ([#1563](https://github.com/simonw/datasette/issues/1563)) - The tracing feature now traces write queries, not just read queries. ([#1568](https://github.com/simonw/datasette/issues/1568)) - The query string variables exposed by `request.args` will now include blank strings for arguments such as `foo` in `?foo=&bar=1` rather than ignoring those parameters entirely. ([#1551](https://github.com/simonw/datasette/issues/1551)) ### Faceting - The number of uni… | 2022-01-14T01:41:28Z | ["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/2.9.1 | 2020-05-11 | * Added custom project links to the [PyPI listing](https://pypi.org/project/sqlite-utils/). | 2020-05-11T19:21:24Z | ["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/2.10.1 | 2020-06-23 | * Added documentation for the `table.pks` introspection property. #116 | 2020-06-23T21:04:50Z | ["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.35 | 2020-02-05 | * Added five new plugins and one new conversion tool to the [The Datasette Ecosystem](https://datasette.readthedocs.io/en/latest/ecosystem.html#ecosystem). * The `Datasette` class has a new `render_template()` method which can be used by plugins to render templates using Datasette’s pre-configured [Jinja](https://jinja.palletsprojects.com/) templating library. * You can now execute SQL queries that start with a `-- comment` - thanks, Jay Graves (#653) https://datasette.readthedocs.io/en/latest/changelog.html#v0-35 | 2020-02-05T02:32:34Z | ["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.29.2 | 2019-09-03 | * Bumped Uvicorn to 0.8.4, fixing a bug where the querystring was not included in the server logs. (#559) * Fixed bug where the navigation breadcrumbs were not displayed correctly on the page for a custom query. (#558) * Fixed bug where custom query names containing unicode characters caused errors. https://datasette.readthedocs.io/en/stable/changelog.html#v0-29-2 | 2019-09-03T00:33:35Z | ["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/2.4.3 | 2020-03-23 | * Column type suggestion code is no longer confused by null values. (#94) | 2020-03-23T20:00:25Z | ["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.40 | 2020-04-22 | * Datasette [Metadata](https://datasette.readthedocs.io/en/latest/metadata.html) can now be provided as a YAML file as an optional alternative to JSON. See [Using YAML for metadata](https://datasette.readthedocs.io/en/latest/metadata.html#metadata-yaml). (#713) * Removed support for `datasette publish now`, which used the the now-retired Zeit Now v1 hosting platform. A new plugin, [datasette-publish-now](https://github.com/simonw/datasette-publish-now), can be installed to publish data to Zeit ([now Vercel](https://vercel.com/blog/zeit-is-now-vercel)) Now v2. (#710) * Fixed a bug where the `extra_template_vars(request, view_name)` plugin hook was not receiving the correct `view_name`. (#716) * Variables added to the template context by the `extra_template_vars()` plugin hook are now shown in the `?_context=1` debugging mode (see [template_debug](https://datasette.readthedocs.io/en/latest/config.html#config-template-debug)). (#693) * Fixed a bug where the “templates considered” HTML comment was no longer being displayed. (#689) * Fixed a `datasette publish` bug where `--plugin-secret` would over-ride plugin configuration in the provided `metadata.json` file. (#724) * Added a new CSS class for customizing the canned query page. (#727) | 2020-04-22T04:06:51Z | ["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.37.1 | 2020-03-03 | * Don’t attempt to count table rows to display on the index page for databases > 100MB. (#688) * Print exceptions if they occur in the write thread rather than silently swallowing them. * Handle the possibility of `scope["path"]` being a string rather than bytes * Better documentation for the [extra_template_vars(template, database, table, view_name, request, datasette)](https://datasette.readthedocs.io/en/stable/plugins.html#plugin-hook-extra-template-vars) plugin hook. | 2020-03-03T03:46:17Z | ["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.50.2 | 2020-10-10 | * Fixed another bug introduced in 0.50 where column header links on the table page were broken. (#1011) | 2020-10-10T03:59:18Z | ["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/2.4.4 | 2020-03-23 | * Fixed bug where columns with only null values were not correctly created. (#95) | 2020-03-23T20:34:18Z | ["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.39 | 2020-03-25 | * New [base_url](https://datasette.readthedocs.io/en/latest/config.html#config-base-url) configuration setting for serving up the correct links while running Datasette under a different URL prefix. (#394) * New metadata settings `"sort"` and `"sort_desc"` for setting the default sort order for a table. See [Setting a default sort order](https://datasette.readthedocs.io/en/latest/metadata.html#metadata-default-sort). (#702) * Sort direction arrow now displays by default on the primary key. This means you only have to click once (not twice) to sort in reverse order. (#677) * New `await Request(scope, receive).post_vars()` method for accessing POST form variables. (#700) * Plugin hooks documentation now links to example uses of each plugin. (#709) | 2020-03-25T04:11:35Z | ["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/2.7 | 2020-04-30 | * New `columns=` argument for the `.insert()`, `.insert_all()`, `.upsert()` and `.upsert_all()` methods, for over-riding the auto-detected types for columns and specifying additional columns that should be added when the table is created. See [Custom column order and column types](https://sqlite-utils.readthedocs.io/en/stable/python-api.html#python-api-custom-columns). (#100) | 2020-04-30T18:33:20Z | ["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/2.8 | 2020-05-03 | * New `sqlite-utils create-table` command, see [Creating tables](https://sqlite-utils.readthedocs.io/en/latest/cli.html#creating-tables). (#27) * New `sqlite-utils create-view` command, see [Creating views](https://sqlite-utils.readthedocs.io/en/latest/cli.html#creating-views). (#107) | 2020-05-03T15:41:31Z | ["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/2.7.1 | 2020-05-01 | * New `sqlite-utils views my.db` command for listing views in a database, see [Listing views](https://sqlite-utils.readthedocs.io/en/latest/cli.html#cli-views). (#105) * `sqlite-utils tables` (and `views`) has a new `--schema` option which outputs the table/view schema, see [Listing tables](https://sqlite-utils.readthedocs.io/en/latest/cli.html#cli-tables). (#104) * Nested structures containing invalid JSON values (e.g. Python bytestrings) are now serialized using `repr()` instead of throwing an error. (#102) | 2020-05-01T22:11:19Z | ["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/2.6 | 2020-04-16 | * New `table.rows_where(..., order_by="age desc")` argument, see [Listing rows](https://sqlite-utils.readthedocs.io/en/stable/python-api.html#listing-rows). (#76) | 2020-04-16T03:14:48Z | ["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/2.5 | 2020-04-13 | * Panda’s Timestamp is now stored as a SQLite TEXT column. Thanks, b0b5h4rp13! (#96) * `table.last_pk` is now only available for inserts or upserts of a single record. (#98) * New `Database(filepath, recreate=True)` parameter for deleting and recreating the database. (#97) | 2020-04-13T03:54:08Z | ["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.37 | 2020-02-26 | * Plugins now have a supported mechanism for writing to a database, using the new `.execute_write()` and `.execute_write_fn()` methods. [Documentation](https://datasette.readthedocs.io/en/stable/internals.html#database-execute-write). (#682) * Immutable databases that have had their rows counted using the `inspect` command now use the calculated count more effectively - thanks, Kevin Keogh. (#666) * `--reload` no longer restarts the server if a database file is modified, unless that database was opened immutable mode with `-i`. (#494) * New `?_searchmode=raw` option turns off escaping for FTS queries in `?_search=` allowing full use of SQLite’s [FTS5 query syntax](https://www.sqlite.org/fts5.html#full_text_query_syntax). (#676) | 2020-02-26T03:44:07Z | ["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.38 | 2020-03-08 | * The [Docker build](https://hub.docker.com/r/datasetteproject/datasette) of Datasette now uses SQLite 3.31.1, upgraded from 3.26. (#695) * `datasette publish cloudrun` now accepts an optional `--memory=2Gi` flag for setting the Cloud Run allocated memory to a value other than the default (256Mi). (#694) * Fixed bug where templates that shipped with plugins were sometimes not being correctly loaded. (#697) | 2020-03-08T23:42:36Z | ["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.36 | 2020-02-22 | * The `datasette` object passed to plugins now has API documentation: [Datasette class](https://datasette.readthedocs.io/en/latest/datasette.html#datasette). (#576) * New methods on `datasette`: `.add_database()` and `.remove_database()` - [documentation](https://datasette.readthedocs.io/en/latest/datasette.html#datasette-add-database). (#671) * `prepare_connection()` plugin hook now takes optional `datasette` and `database` arguments - [prepare_connection(conn, database, datasette)](https://datasette.readthedocs.io/en/latest/plugins.html#plugin-hook-prepare-connection). (#678) * Added three new plugins and one new conversion tool to the [The Datasette Ecosystem](https://datasette.readthedocs.io/en/latest/ecosystem.html#ecosystem). https://datasette.readthedocs.io/en/latest/changelog.html#v0-36 | 2020-02-22T03:24:50Z | ["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.25.2 | 2018-12-16 | * `datasette publish heroku` now uses the `python-3.6.7` runtime * Added documentation on [how to build the documentation](https://datasette.readthedocs.io/en/stable/contributing.html#editing-and-building-the-documentation) * Added documentation covering [our release process](https://datasette.readthedocs.io/en/stable/contributing.html#release-process) * Upgraded to pytest 4.0.2 | 2018-12-16T21:45:39Z | ["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/2.7.2 | 2020-05-02 | * `db.create_view(...)` now has additional parameters `ignore=True` or `replace=True`, see [Creating views](https://sqlite-utils.readthedocs.io/en/latest/python-api.html#creating-views). (#106) | 2020-05-02T16:10:11Z | ["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.33 | 2019-12-22 | * `rowid` is now included in dropdown menus for filtering tables (#636) * Columns are now only suggested for faceting if they have at least one value with more than one record (#638) * Queries with no results now display “0 results” (#637) * Improved documentation for the `--static` option (#641) * asyncio task information is now included on the `/-/threads` debug page * Bumped Uvicorn dependency 0.11 * You can now use `--port 0` to listen on an available port * New `template_debug` setting for debugging templates, e.g. https://latest.datasette.io/fixtures/roadside_attractions?_context=1 (#654) https://datasette.readthedocs.io/en/latest/changelog.html#v0-33 | 2019-12-22T16:43:31Z | ["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/2.4.2 | 2020-03-14 | * `table.column_dicts` now works with all column types - previously it would throw errors on types other than `TEXT`, `BLOB`, `INTEGER` or `FLOAT`. (#92) * Documentation for `NotFoundError` thrown by `table.get(pk)` - see [Retrieving a specific record](https://sqlite-utils.readthedocs.io/en/latest/python-api.html#python-api-get). | 2020-03-14T20:13:18Z | ["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/2.4 | 2020-02-27 | * `table.disable_fts()` can now be used to remove FTS tables and triggers that were created using `table.enable_fts(...)`. (#88) * The `sqlite-utils disable-fts` command can be used to remove FTS tables and triggers from the command-line. (#88) * Trying to create table columns with square braces ([ or ]) in the name now raises an error. (#86) * Subclasses of `dict`, `list` and `tuple` are now detected as needing a JSON column. (#87) | 2020-02-27T04:58:25Z | ["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/2.4.1 | 2020-03-14 | * `table.enable_fts()` now works with columns that contain spaces. (#90) | 2020-03-14T20:06:08Z | ["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.54a0 | 2021-01-19 | **Alpha release**. Release notes in progress. - Improved support for named in-memory databases. ([#1151](https://github.com/simonw/datasette/issues/1151)) - New `_internal` in-memory database tracking attached databases, tables and columns. ([#1150](https://github.com/simonw/datasette/issues/1150)) - Support for JavaScript modules. ([#1186](https://github.com/simonw/datasette/issues/1186), [#1187](https://github.com/simonw/datasette/issues/1187)) | 2021-01-19T20:51:13Z | ["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.57 | 2021-06-05 | **Warning**: This release fixes a [reflected cross-site scripting](https://owasp.org/www-community/attacks/xss/#reflected-xss-attacks) security hole with the `?_trace=1` feature. You should upgrade to this version, or to Datasette 0.56.1, as soon as possible. ([#1360](https://github.com/simonw/datasette/issues/1360)) In addition to the security fix, this release includes `?_col=` and `?_nocol=` options for controlling which columns are displayed for a table, `?_facet_size=` for increasing the number of facet results returned, re-display of your SQL query should an error occur and numerous bug fixes. ### New features - If an error occurs while executing a user-provided SQL query, that query is now re-displayed in an editable form along with the error message. ([#619](https://github.com/simonw/datasette/issues/619)) - New `?_col=` and `?_nocol=` parameters to show and hide columns in a table, plus an interface for hiding and showing columns in the column cog menu. ([#615](https://github.com/simonw/datasette/issues/615)) - A new `?_facet_size=` parameter for customizing the number of facet results returned on a table or view page. ([#1332](https://github.com/simonw/datasette/issues/1332)) - `?_facet_size=max` sets that to the maximum, which defaults to 1,000 and is controlled by the the [max_returned_rows](https://docs.datasette.io/en/stable/settings.html#setting-max-returned-rows) setting. If facet results are truncated the ... at the bottom of the facet list now links to this parameter. ([#1337](https://github.com/simonw/datasette/issues/1337)) - `?_nofacet=1` option to disable all facet calculations on a page, used as a performance optimization for CSV exports and `?_shape=array/object`. ([#1349](https://github.com/simonw/datasette/issues/1349), [#263](https://github.com/simonw/datasette/issues/263)) - `?_nocount=1` option to disable full query result counts. ([#1353](https://github.com/simonw/datasette/issues/1353)) - `?_trace=1` debugging option is now controlled by the new [trace_d… | 2021-06-05T22:11:18Z | ["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.46 | 2020-08-09 | **Warning:** This release contains a security fix related to authenticated writable canned queries. If you are using this feature you should upgrade as soon as possible. - **Security fix:** CSRF tokens were incorrectly included in read-only canned query forms, which could allow them to be leaked to a sophisticated attacker. See [issue 918](https://github.com/simonw/datasette/issues/918) for details. - Datasette now supports GraphQL via the new [datasette-graphql](https://github.com/simonw/datasette-graphql) plugin - see [GraphQL in Datasette with the new datasette-graphql plugin](https://simonwillison.net/2020/Aug/7/datasette-graphql/). - Principle git branch has been renamed from `master` to `main`. ([#849](https://github.com/simonw/datasette/issues/849)) - New debugging tool: `/-/allow-debug tool` ([demo here](https://latest.datasette.io/-/allow-debug)) helps test allow blocks against actors, as described in [Defining permissions with "allow" blocks](https://datasette.readthedocs.io/en/stable/authentication.html#authentication-permissions-allow). ([#908](https://github.com/simonw/datasette/issues/908)) - New logo for the documentation, and a new project tagline: "An open source multi-tool for exploring and publishing data". - Whitespace in column values is now respected on display, using `white-space: pre-wrap`. ([#896](https://github.com/simonw/datasette/issues/896)) - New `await request.post_body()` method for accessing the raw POST body, see [Request object](https://datasette.readthedocs.io/en/stable/internals.html#internals-request). ([#897](https://github.com/simonw/datasette/issues/897)) - Database file downloads now include a `content-length` HTTP header, enabling download progress bars. ([#905](https://github.com/simonw/datasette/issues/905)) - File downloads now also correctly set the suggested file name using a `content-disposition` HTTP header. ([#909](https://github.com/simonw/datasette/issues/909)) - `tests` are now excluded from the Datasette package properly - than… | 2020-08-09T16:10:47Z | ["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.12 | 2017-11-16 | - Added `__version__`, now displayed as tooltip in page footer (#108). - Added initial docs, including a changelog (#99). - Turned on auto-escaping in Jinja. - Added a UI for editing named parameters (#96). You can now construct a custom SQL statement using SQLite named parameters (e.g. `:name`) and datasette will display form fields for editing those parameters. [Here's an example](https://australian-dogs.now.sh/australian-dogs-3ba9628?sql=select+name%2C+count%28*%29+as+n+from+%28%0D%0A%0D%0Aselect+upper%28%22Animal+name%22%29+as+name+from+%5BAdelaide-City-Council-dog-registrations-2013%5D+where+Breed+like+%3Abreed%0D%0A%0D%0Aunion+all%0D%0A%0D%0Aselect+upper%28Animal_Name%29+as+name+from+%5BAdelaide-City-Council-dog-registrations-2014%5D+where+Breed_Description+like+%3Abreed%0D%0A%0D%0Aunion+all+%0D%0A%0D%0Aselect+upper%28Animal_Name%29+as+name+from+%5BAdelaide-City-Council-dog-registrations-2015%5D+where+Breed_Description+like+%3Abreed%0D%0A%0D%0Aunion+all%0D%0A%0D%0Aselect+upper%28%22AnimalName%22%29+as+name+from+%5BCity-of-Port-Adelaide-Enfield-Dog_Registrations_2016%5D+where+AnimalBreed+like+%3Abreed%0D%0A%0D%0Aunion+all%0D%0A%0D%0Aselect+upper%28%22Animal+Name%22%29+as+name+from+%5BMitcham-dog-registrations-2015%5D+where+Breed+like+%3Abreed%0D%0A%0D%0Aunion+all%0D%0A%0D%0Aselect+upper%28%22DOG_NAME%22%29+as+name+from+%5Bburnside-dog-registrations-2015%5D+where+DOG_BREED+like+%3Abreed%0D%0A%0D%0Aunion+all+%0D%0A%0D%0Aselect+upper%28%22Animal_Name%22%29+as+name+from+%5Bcity-of-playford-2015-dog-registration%5D+where+Breed_Description+like+%3Abreed%0D%0A%0D%0Aunion+all%0D%0A%0D%0Aselect+upper%28%22Animal+Name%22%29+as+name+from+%5Bcity-of-prospect-dog-registration-details-2016%5D+where%22Breed+Description%22+like+%3Abreed%0D%0A%0D%0A%29+group+by+name+order+by+n+desc%3B&breed=pug) which lets you see the most popular names for dogs of different species registered through various dog registration schemes in Australia. - Pin to specific Jinja version. (#100). - Default to 127.0.0.1 n… | 2017-11-16T16:01:35Z | ["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.22.1 | 2022-01-26 | - All commands now include example usage in their `--help` - see [CLI reference](https://sqlite-utils.datasette.io/en/stable/cli-reference.html#cli-reference). ([#384](https://github.com/simonw/sqlite-utils/issues/384)) - Python library documentation has a new [Getting started](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-getting-started) section. ([#387](https://github.com/simonw/sqlite-utils/issues/387)) - Documentation now uses [Plausible analytics](https://plausible.io/). ([#389](https://github.com/simonw/sqlite-utils/issues/389)) | 2022-01-26T03:29:24Z | ["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.50a1 | 2020-10-06 | - Column action menu now shows the column type. ([#993](https://github.com/simonw/datasette/issues/993)) - Column action sort links now correctly link to the first page of sorted results. ([#989](https://github.com/simonw/datasette/issues/989)) - [Publishing to Google Cloud Run](https://docs.datasette.io/en/latest/publish.html#publish-cloud-run) documentation now covers Google Cloud SDK options. Thanks, Geoffrey Hing. ([#995](https://github.com/simonw/datasette/pull/995)) | 2020-10-06T20:52:49Z | ["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.59a2 | 2021-08-28 | - Columns can now have associated metadata descriptions in `metadata.json`, see [Column descriptions](https://docs.datasette.io/en/latest/metadata.html#metadata-column-descriptions). ([#942](https://github.com/simonw/datasette/issues/942)) - New [register_commands()](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-register-commands) plugin hook allows plugins to register additional Datasette CLI commands, e.g. `datasette mycommand file.db`. ([#1449](https://github.com/simonw/datasette/issues/1449)) - Adding `?_facet_size=max` to a table page now shows the number of unique values in each facet. ([#1423](https://github.com/simonw/datasette/issues/1423)) - Code that figures out which named parameters a SQL query takes in order to display form fields for them is no longer confused by strings that contain colon characters. ([#1421](https://github.com/simonw/datasette/issues/1421)) - Renamed `--help-config` option to `--help-settings`. ([#1431](https://github.com/simonw/datasette/issues/1431)) - `datasette.databases` property is now a documented API. ([#1443](https://github.com/simonw/datasette/issues/1443)) - Datasette base template now wraps everything other than the `<footer>` in a `<div class="not-footer">` element, to help with advanced CSS customization. ([#1446](https://github.com/simonw/datasette/issues/1446)) | 2021-08-28T01:57:38Z | ["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.59 | 2021-10-14 | - Columns can now have associated metadata descriptions in `metadata.json`, see [Column descriptions](https://docs.datasette.io/en/stable/metadata.html#metadata-column-descriptions). ([#942](https://github.com/simonw/datasette/issues/942)) - New [register_commands()](https://docs.datasette.io/en/stable/plugin_hooks.html#plugin-hook-register-commands) plugin hook allows plugins to register additional Datasette CLI commands, e.g. `datasette mycommand file.db`. ([#1449](https://github.com/simonw/datasette/issues/1449)) - Adding `?_facet_size=max` to a table page now shows the number of unique values in each facet. ([#1423](https://github.com/simonw/datasette/issues/1423)) - Upgraded dependency [httpx 0.20](https://github.com/encode/httpx/releases/tag/0.20.0) - the undocumented `allow_redirects=` parameter to [datasette.client](https://docs.datasette.io/en/stable/internals.html#internals-datasette-client) is now `follow_redirects=`, and defaults to `False` where it previously defaulted to `True`. ([#1488](https://github.com/simonw/datasette/issues/1488)) - The `--cors` option now causes Datasette to return the `Access-Control-Allow-Headers: Authorization` header, in addition to `Access-Control-Allow-Origin: *`. ([#1467](https://github.com/simonw/datasette/pull/1467)) - Code that figures out which named parameters a SQL query takes in order to display form fields for them is no longer confused by strings that contain colon characters. ([#1421](https://github.com/simonw/datasette/issues/1421)) - Renamed `--help-config` option to `--help-settings`. ([#1431](https://github.com/simonw/datasette/issues/1431)) - `datasette.databases` property is now a documented API. ([#1443](https://github.com/simonw/datasette/issues/1443)) - The `base.html` template now wraps everything other than the `<footer>` in a `<div class="not-footer">` element, to help with advanced CSS customization. ([#1446](https://github.com/simonw/datasette/issues/1446)) - The [render_cell()](https://docs.datasette.io/en/stable/pl… | 2021-10-14T19:31:56Z | ["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.60a1 | 2021-12-19 | - Database write connections now execute the [prepare_connection(conn, database, datasette)](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-prepare-connection) plugin hook. ([#1564](https://github.com/simonw/datasette/issues/1564)) - The `Datasette()` constructor no longer requires the `files=` argument, and is now documented at [Datasette class](https://docs.datasette.io/en/latest/internals.html#internals-datasette). ([#1563](https://github.com/simonw/datasette/issues/1563)) - The tracing feature now traces write queries, not just read queries. ([#1568](https://github.com/simonw/datasette/issues/1568)) - Added two methods for writing to the database: [await db.execute_write_script(sql, block=False)](https://docs.datasette.io/en/latest/internals.html#database-execute-write-script) and [await db.execute_write_many(sql, params_seq, block=False)](https://docs.datasette.io/en/latest/internals.html#database-execute-write-many). ([#1570](https://github.com/simonw/datasette/issues/1570)) - Made several performance improvements to the database schema introspection code that runs when Datasette first starts up. ([#1555](https://github.com/simonw/datasette/issues/1555)) - Fixed bug where writable canned queries could not be used with custom templates. ([#1547](https://github.com/simonw/datasette/issues/1547)) | 2021-12-19T22:11:16Z | ["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.48 | 2020-08-16 | - Datasette documentation now lives at [docs.datasette.io](https://docs.datasette.io/). - `db.is_mutable` property is now documented and tested, see [Database introspection](https://docs.datasette.io/en/stable/internals.html#internals-database-introspection). - The `extra_template_vars`, `extra_css_urls`, `extra_js_urls` and `extra_body_script` plugin hooks now all accept the same arguments. See [extra_template_vars(template, database, table, columns, view_name, request, datasette)](https://docs.datasette.io/en/stable/plugin_hooks.html#plugin-hook-extra-template-vars) for details. ([#939](https://github.com/simonw/datasette/issues/939)) - Those hooks now accept a new `columns` argument detailing the table columns that will be rendered on that page. ([#938](https://github.com/simonw/datasette/issues/938)) - Fixed bug where plugins calling `db.execute_write_fn()` could hang Datasette if the connection failed. ([#935](https://github.com/simonw/datasette/issues/935)) - Fixed bug with the `?_nl=on` output option and binary data. ([#914](https://github.com/simonw/datasette/issues/914)) | 2020-08-16T18:58:34Z | ["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.47 | 2020-08-12 | - Datasette now has [a GitHub discussions forum](https://github.com/simonw/datasette/discussions) for conversations about the project that go beyond just bug reports and issues. - Datasette can now be installed on macOS using Homebrew! Run `brew install simonw/datasette/datasette`. See [Using Homebrew](https://datasette.readthedocs.io/en/stable/installation.html#installation-homebrew). ([#335](https://github.com/simonw/datasette/issues/335)) - Two new commands: `datasette install name-of-plugin` and `datasette uninstall name-of-plugin`. These are equivalent to `pip install` and `pip uninstall` but automatically run in the same virtual environment as Datasette, so users don't have to figure out where that virtual environment is - useful for installations created using Homebrew or `pipx`. See [Installing plugins](https://datasette.readthedocs.io/en/stable/plugins.html#plugins-installing). ([#925](https://github.com/simonw/datasette/issues/925)) - A new command-line option, `datasette --get`, accepts a path to a URL within the Datasette instance. It will run that request through Datasette (without starting a web server) and print out the repsonse. See [datasette --get](https://datasette.readthedocs.io/en/stable/getting_started.html#getting-started-datasette-get) for an example. ([#926](https://github.com/simonw/datasette/issues/926)) | 2020-08-12T00:44: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.62a0 | 2022-05-02 | - 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. - Datasette should now be compatible with Pyodide. ([#1733](https://github.com/simonw/datasette/issues/1733)) - `datasette publish cloudrun` has a new `--timeout` option which can be used to increase the time limit applied by the Google Cloud build environment. Thanks, Tim Sherratt. ([#1717](https://github.com/simonw/datasette/pull/1717)) - Spaces in database names 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)) - Don't show the facet option in the cog menu if faceting is not allowed. ([#1683](https://github.com/simonw/datasette/issues/1683)) - Code examples in the documentation are now all formatted using Black. ([#1718](https://github.com/simonw/datasette/issues/1718)) - `Request.fake()` method is now documented, see [Request object](https://docs.datasette.io/en/latest/internals.html#internals-request). | 2022-05-02T21: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.1 | 2020-11-29 | - Documentation on [Testing plugins](https://docs.datasette.io/en/stable/testing_plugins.html#testing-plugins) now recommends using [datasette.client](https://docs.datasette.io/en/stable/internals.html#internals-datasette-client). ([#1102](https://github.com/simonw/datasette/issues/1102)) - Fix bug where compound foreign keys produced broken links. ([#1098](https://github.com/simonw/datasette/issues/1098)) - `datasette --load-module=spatialite` now also checks for `/usr/local/lib/mod_spatialite.so`. Thanks, Dan Peterson. ([#1114](https://github.com/simonw/datasette/issues/1114)) | 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.59.1 | 2021-10-24 | - Fix compatibility with Python 3.10. ([#1482](https://github.com/simonw/datasette/issues/1482)) - Documentation on how to use [Named parameters](https://docs.datasette.io/en/stable/sql_queries.html#sql-parameters) with integer and floating point values. ([#1496](https://github.com/simonw/datasette/issues/1496)) | 2021-10-24T22:32:25Z | ["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.5 | 2020-12-09 | - Fix for error caused by combining the `_searchmode=raw` and `?_search_COLUMN` parameters. ([#1134](https://github.com/simonw/datasette/issues/1134)) | 2020-12-09T20:10:23Z | ["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.63.2 | 2022-11-19 | - Fixed a bug in `datasette publish heroku` where deployments failed due to an older version of Python being requested. ([#1905](https://github.com/simonw/datasette/issues/1905)) - New `datasette publish heroku --generate-dir <dir>` option for generating a Heroku deployment directory without deploying it. | 2022-11-19T00:58:27Z | ["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.60.2 | 2022-02-07 | - Fixed a bug where Datasette would open the same file twice with two different database names if you ran `datasette file.db file.db`. ([#1632](https://github.com/simonw/datasette/issues/1632)) | 2022-02-07T23:49:38Z | ["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.2.1 | 2021-01-12 | - Fixed a bug where `.add_missing_columns()` failed to take case insensitive column names into account. ([#221](https://github.com/simonw/sqlite-utils/issues/221)) | 2021-01-12T23:23:25Z | ["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.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](https://github.com/simonw/datasette/issues/1214)) | 2021-02-02T21:30:12Z | ["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.47.1 | 2020-08-12 | - Fixed a bug where the `sdist` distribution of Datasette was not correctly including the template files. ([#930](https://github.com/simonw/datasette/issues/930)) | 2020-08-12T02:38:00Z | ["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.51a0 | 2020-10-20 | - Fixed a bunch of issues relating to the [base_url](https://docs.datasette.io/en/latest/config.html#config-base-url) setting. ([#1023](https://github.com/simonw/datasette/issues/1023)) - New `datasette.urls` URL builder for plugins, see [Building URLs within plugins](https://docs.datasette.io/en/latest/writing_plugins.html#writing-plugins-building-urls). ([#904](https://github.com/simonw/datasette/issues/904)) - Removed `--debug` option, which didn't do anything. ([#814](https://github.com/simonw/datasette/issues/814)) - `Link:` HTTP header pagination. ([#1014](https://github.com/simonw/datasette/issues/1014)) - `x` button for clearing filters. ([#1016](https://github.com/simonw/datasette/issues/1016)) - Edit SQL button on canned queries, ([#1019](https://github.com/simonw/datasette/issues/1019)) - `--load-extension=spatialite` shortcut. ([#1028](https://github.com/simonw/datasette/issues/1028)) | 2020-10-20T05:33:01Z | ["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.4.1 | 2021-02-06 | - Fixed a code import bug that slipped in to 3.4. ([#226](https://github.com/simonw/sqlite-utils/issues/226)) | 2021-02-06T02:11:15Z | ["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.9.1 | 2021-06-13 | - Fixed bug when using `table.upsert_all()` to create a table with only a single column that is treated as the primary key. ([#271](https://github.com/simonw/sqlite-utils/issues/271)) | 2021-06-13T03:00:45Z | ["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.59.4 | 2021-11-30 | - Fixed bug where columns with a leading underscore could not be removed from the interactive filters list. ([#1527](https://github.com/simonw/datasette/issues/1527)) - Fixed bug where columns with a leading underscore were not correctly linked to by the "Links from other tables" interface on the row page. ([#1525](https://github.com/simonw/datasette/issues/1525)) - Upgraded dependencies `aiofiles`, `black` and `janus`. | 2021-11-30T06:50:48Z | ["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.1.1 | 2021-01-01 | - Fixed failing test caused by `optimize` sometimes creating larger database files. ([#209](https://github.com/simonw/sqlite-utils/issues/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"] |
107914493 | https://github.com/simonw/datasette | https://github.com/simonw/datasette/releases/tag/0.59.3 | 2021-11-20 | - Fixed numerous bugs when running Datasette [behind a proxy](https://docs.datasette.io/en/stable/deploying.html#deploying-proxy) with a prefix URL path using the [base_url](https://docs.datasette.io/en/stable/settings.html#setting-base-url) setting. A live demo of this mode is now available at [datasette-apache-proxy-demo.datasette.io/prefix/](https://datasette-apache-proxy-demo.datasette.io/prefix/). ([#1519](https://github.com/simonw/datasette/issues/1519), [#838](https://github.com/simonw/datasette/issues/838)) - `?column__arraycontains=` and `?column__arraynotcontains=` table parameters now also work against SQL views. ([#448](https://github.com/simonw/datasette/issues/448)) - `?_facet_array=column` no longer returns incorrect counts if columns contain the same value more than once. | 2021-11-20T23:41:33Z | ["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.57.1 | 2021-06-08 | - Fixed visual display glitch with global navigation menu. ([#1367](https://github.com/simonw/datasette/issues/1367)) - No longer truncates the list of table columns displayed on the `/database` page. ([#1364](https://github.com/simonw/datasette/issues/1364)) | 2021-06-08T16:28:31Z | ["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](https://github.com/simonw/datasette/issues/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](https://github.com/simonw/datasette/issues/1115)) - `OPTIONS` requests against the `/database` page no longer raise a 500 error. ([#1100](https://github.com/simonw/datasette/issues/1100)) - Databases larger than 32MB that are published to Cloud Run can now be downloaded. ([#749](https://github.com/simonw/datasette/issues/749)) - Fix for misaligned cog icon on table and database pages. Thanks, Abdussamet Koçak. ([#1121](https://github.com/simonw/datasette/issues/1121)) | 2020-12-03T00:58:43Z | ["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.22 | 2022-01-11 | - New [CLI reference](https://sqlite-utils.datasette.io/en/stable/cli-reference.html#cli-reference) documentation page, listing the output of `--help` for every one of the CLI commands. ([#383](https://github.com/simonw/sqlite-utils/issues/383)) - `sqlite-utils rows` now has `--limit` and `--offset` options for paginating through data. ([#381](https://github.com/simonw/sqlite-utils/issues/381)) - `sqlite-utils rows` now has `--where` and `-p` options for filtering the table using a `WHERE` query, see [Returning all rows in a table](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-rows). ([#382](https://github.com/simonw/sqlite-utils/issues/382)) | 2022-01-11T23:49:28Z | ["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.12 | 2021-06-25 | - New [db.query(sql, params)](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-query) method, which executes a SQL query and returns the results as an iterator over Python dictionaries. ([#290](https://github.com/simonw/sqlite-utils/issues/290)) - This project now uses `flake8` and has started to use `mypy`. ([#291](https://github.com/simonw/sqlite-utils/issues/291)) - New documentation on [contributing](https://sqlite-utils.datasette.io/en/stable/contributing.html#contributing) to this project. ([#292](https://github.com/simonw/sqlite-utils/issues/292)) | 2021-06-25T18:00:18Z | ["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.51a2 | 2020-10-30 | - New [load_template(template, request, datasette)](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-load-template) plugin hook. ([#1042](https://github.com/simonw/datasette/issues/1042)) - New [debug-menu](https://docs.datasette.io/en/latest/authentication.html#permissions-debug-menu) permission. ([#1068](https://github.com/simonw/datasette/issues/1068)) | 2020-10-30T17:57:53Z | ["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"] |
140912432 | https://github.com/simonw/sqlite-utils | https://github.com/simonw/sqlite-utils/releases/tag/2.22 | 2020-10-16 | - New `--encoding` option for processing CSV and TSV files that use a non-utf-8 encoding, for both the `insert` and `update` commands. ([#182](https://github.com/simonw/sqlite-utils/issues/182)) - The `--load-extension` option is now available to many more commands. ([#137](https://github.com/simonw/sqlite-utils/issues/137)) - `--load-extension=spatialite` can be used to load SpatiaLite from common installation locations, if it is available. ([#136](https://github.com/simonw/sqlite-utils/issues/136)) - Tests now also run against Python 3.9. ([#184](https://github.com/simonw/sqlite-utils/issues/184)) - Passing `pk=["id"]` now has the same effect as passing `pk="id"`. ([#181](https://github.com/simonw/sqlite-utils/issues/181)) | 2020-10-16T19:31:45Z | ["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/2.11 | 2020-07-08 | - New `--truncate` option to `sqlite-utils insert`, and `truncate=True` argument to `.insert_all()`. Thanks, Thomas Sibley. ([#118](https://github.com/simonw/sqlite-utils/pull/118)) - The `sqlite-utils query` command now runs updates in a transaction. Thanks, Thomas Sibley. ([#120](https://github.com/simonw/sqlite-utils/pull/120)) | 2020-07-08T17:36:45Z | ["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/2.15 | 2020-08-10 | - New `db.enable_wal()` and `db.disable_wal()` methods for enabling and disabling [Write-Ahead Logging](https://www.sqlite.org/wal.html) for a database file - see [WAL mode](https://sqlite-utils.readthedocs.io/en/stable//python-api.html#python-api-wal) in the Python API documentation. - Also `sqlite-utils enable-wal file.db` and `sqlite-utils disable-wal file.db` commands for doing the same thing on the command-line, see [WAL mode (CLI)](https://sqlite-utils.readthedocs.io/en/stable/cli.html#cli-wal). ([#132](https://github.com/simonw/sqlite-utils/issues/132)) | 2020-08-10T19:07:27Z | ["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.26 | 2022-04-13 | - New `errors=r.IGNORE/r.SET_NULL` parameter for the `r.parsedatetime()` and `r.parsedate()` [convert recipes](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-convert-recipes). ([#416](https://github.com/simonw/sqlite-utils/issues/416)) - Fixed a bug where `--multi` could not be used in combination with `--dry-run` for the [convert](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-convert) command. ([#415](https://github.com/simonw/sqlite-utils/issues/415)) - New documentation: [Using a convert() function to execute initialization](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-convert-complex). ([#420](https://github.com/simonw/sqlite-utils/issues/420)) - More robust detection for whether or not `deterministic=True` is supported. ([#425](https://github.com/simonw/sqlite-utils/issues/425)) | 2022-04-13T22:53:36Z | ["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.25 | 2022-03-02 | - New `hash_id_columns=` parameter for creating a primary key that's a hash of the content of specific columns - see [Setting an ID based on the hash of the row contents](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-hash) for details. ([#343](https://github.com/simonw/sqlite-utils/issues/343)) - New [db.sqlite_version](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-sqlite-version) property, returning a tuple of integers representing the version of SQLite, for example `(3, 38, 0)`. - Fixed a bug where [register_function(deterministic=True)](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-register-function) caused errors on versions of SQLite prior to 3.8.3. ([#408](https://github.com/simonw/sqlite-utils/issues/408)) - New documented [hash_record(record, keys=...)](https://sqlite-utils.datasette.io/en/stable/reference.html#reference-utils-hash-record) function. | 2022-03-02T06:35:18Z | ["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/2.19 | 2020-09-20 | - New `sqlite-utils add-foreign-keys` command for [Adding multiple foreign keys at once](https://sqlite-utils.readthedocs.io/en/stable/cli.html#cli-add-foreign-keys). ([#157](https://github.com/simonw/sqlite-utils/issues/157)) - New `table.enable_fts(..., replace=True)` argument for replacing an existing FTS table with a new configuration. ([#160](https://github.com/simonw/sqlite-utils/issues/160)) - New `table.add_foreign_key(..., ignore=True)` argument for ignoring a foreign key if it already exists. ([#112](https://github.com/simonw/sqlite-utils/issues/112)) | 2020-09-20T22:24:04Z | ["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/2.9 | 2020-05-11 | - New `sqlite-utils drop-table` command, see [Dropping tables](https://sqlite-utils.readthedocs.io/en/2.9/cli.html#cli-drop-table). ([#111](https://github.com/simonw/sqlite-utils/issues/111)) - New `sqlite-utils drop-view` command, see [Dropping views](https://sqlite-utils.readthedocs.io/en/2.9/cli.html#cli-drop-view). - Python `decimal.Decimal` objects are now stored as `FLOAT`. ([#110](https://github.com/simonw/sqlite-utils/issues/110)) | 2020-05-11T01:57:11Z | ["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.8 | 2021-06-03 | - New `sqlite-utils indexes` command to list indexes in a database, see [Listing indexes](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-indexes). ([#263](https://github.com/simonw/sqlite-utils/issues/263)) - `table.xindexes` introspection property returning more details about that table's indexes, see [.xindexes](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-introspection-xindexes). ([#261](https://github.com/simonw/sqlite-utils/issues/261)) | 2021-06-03T05:17:33Z | ["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.11 | 2021-06-20 | - New `sqlite-utils memory data.csv --schema` option, for outputting the schema of the in-memory database generated from one or more files. See [--schema, --dump and --save](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-memory-schema-dump-save). ([#288](https://github.com/simonw/sqlite-utils/issues/288)) - Added [installation instructions](https://sqlite-utils.datasette.io/en/stable/installation.html#installation). ([#286](https://github.com/simonw/sqlite-utils/issues/286)) | 2021-06-20T18:53:09Z | ["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.9 | 2021-06-12 | - New `sqlite-utils schema` command showing the full SQL schema for a database, see [Showing the schema (CLI)](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-schema). ([#268](https://github.com/simonw/sqlite-utils/issues/268)) - `db.schema` introspection property exposing the same feature to the Python library, see [Showing the schema (Python library)](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-schema). | 2021-06-12T02:08:03Z | ["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.7 | 2021-05-29 | - New `table.pks_and_rows_where()` method returning `(primary_key, row_dictionary)` tuples - see [Listing rows with their primary keys](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-pks-and-rows-where). ([#240](https://github.com/simonw/sqlite-utils/issues/240)) - Fixed bug with *table.add_foreign_key()* against columns containing spaces. ([#238](https://github.com/simonw/sqlite-utils/issues/238)) - `table_or_view.drop(ignore=True)` option for avoiding errors if the table or view does not exist. ([#237](https://github.com/simonw/sqlite-utils/issues/237)) - `sqlite-utils drop-view --ignore` and `sqlite-utils drop-table --ignore` options. ([#237](https://github.com/simonw/sqlite-utils/issues/237)) - Fixed a bug with inserts of nested JSON containing non-ascii strings - thanks, Dylan Wu. ([#257](https://github.com/simonw/sqlite-utils/issues/257)) - Suggest `--alter` if an error occurs caused by a missing column. ([#259](https://github.com/simonw/sqlite-utils/issues/259)) - Support creating indexes with columns in descending order, see [API documentation](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-create-index) and [CLI documentation](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-create-index). ([#260](https://github.com/simonw/sqlite-utils/issues/260)) - Correctly handle CSV files that start with a UTF-8 BOM. ([#250](https://github.com/simonw/sqlite-utils/issues/250)) | 2021-05-29T05:49:59Z | ["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.50a0 | 2020-10-01 | - New column action menu - table columns now show a cog icon which provides a contextual menu for that column. ([#981](https://github.com/simonw/datasette/issues/981)) - New `datasette -o` option which opens your browser as soon as Datasette starts up. ([#970](https://github.com/simonw/datasette/issues/970) - `sqlite3.enable_callback_tracebacks(True)` so errors in custom SQL functions will now display tracebacks. ([#891](https://github.com/simonw/datasette/issues/891)) - Fixed two rendering bugs with column headers in portrait mobile view. ([#978](https://github.com/simonw/datasette/issues/978), [#980](https://github.com/simonw/datasette/issues/980)) | 2020-10-01T23:35:54Z | ["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.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](https://sqlite-utils.readthedocs.io/en/stable/cli.html#cli-analyze-tables) for documentation. ([#207](https://github.com/simonw/sqlite-utils/issues/207)) - New `table.analyze_column(column)` Python method used by the `analyze-tables` command - see [Analyzing a column](https://sqlite-utils.readthedocs.io/en/stable/python-api.html#python-api-analyze-column). - The `table.update()` method now correctly handles values that should be stored as JSON. Thanks, Andreas Madsack. ([#204](https://github.com/simonw/sqlite-utils/pull/204)) | 2020-12-13T07:31:40Z | ["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.60a0 | 2021-12-17 | - New plugin hook: [filters_from_request(request, database, table, datasette)](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-filters-from-request), which runs on the table page and can be used to support new custom query string parameters that modify the SQL query. ([#473](https://github.com/simonw/datasette/issues/473)) - The number of unique values in a facet is now always displayed. Previously it was only displayed if the user specified `?_facet_size=max`. ([#1556](https://github.com/simonw/datasette/issues/1556)) - Fixed bug where `?_facet_array=tags&_facet=tags` would only display one of the two selected facets. ([#625](https://github.com/simonw/datasette/issues/625)) - Facets of type `date` or `array` can now be configured in `metadata.json`, see [Facets in metadata.json](https://docs.datasette.io/en/latest/facets.html#facets-metadata). Thanks, David Larlet. ([#1552](https://github.com/simonw/datasette/issues/1552)) - New `?_nosuggest=1` parameter for table views, which disables facet suggestion. ([#1557](https://github.com/simonw/datasette/issues/1557)) - Label columns detected for foreign keys are now case-insensitive, so `Name` or `TITLE` will be detected in the same way as `name` or `title`. ([#1544](https://github.com/simonw/datasette/issues/1544)) - The query string variables exposed by `request.args` will now include blank strings for arguments such as `foo` in `?foo=&bar=1` rather than ignoring those parameters entirely. ([#1551](https://github.com/simonw/datasette/issues/1551)) | 2021-12-17T19:15:38Z | ["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.58a1 | 2021-06-24 | - New plugin hook: [skip_csrf(datasette, scope)](https://docs.datasette.io/en/latest//plugin_hooks.html#plugin-hook-skip-csrf), for opting out of CSRF protection based on the incoming request. ([#1377](https://github.com/simonw/datasette/issues/1377)) - `POST` requests to endpoints that do not support that HTTP verb now return a 405 error. - `db.path` can now be provided as a `pathlib.Path` object, useful when writing unit tests for plugins. Thanks, Chris Amico. ([#1365](https://github.com/simonw/datasette/issues/1365)) | 2021-06-24T16:29:09Z | ["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.15.1 | 2021-08-10 | - Python library now includes type annotations on almost all of the methods, plus detailed docstrings describing each one. ([#311](https://github.com/simonw/sqlite-utils/issues/311)) - New [API Reference](https://sqlite-utils.datasette.io/en/stable/reference.html) documentation page, powered by those docstrings. - Fixed bug where `.add_foreign_keys()` failed to raise an error if called against a `View`. ([#313](https://github.com/simonw/sqlite-utils/issues/313)) - Fixed bug where `.delete_where()` returned a `[]` instead of returning `self` if called against a non-existant table. ([#315](https://github.com/simonw/sqlite-utils/issues/315)) | 2021-08-10T23:55:38Z | ["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.61a0 | 2022-03-20 | - Removed hashed URL mode from Datasette. The new `datasette-hashed-urls` plugin can be used to achieve the same result, see [datasette-hashed-urls](https://docs.datasette.io/en/latest/performance.html#performance-hashed-urls) for details. ([#1661](https://github.com/simonw/datasette/issues/1661)) - Databases can now have a custom path within the Datasette instance that is indpendent of the database name, using the `db.route` property. ([#1668](https://github.com/simonw/datasette/issues/1668)) - URLs within Datasette now use a different encoding scheme for tables or databases that include "special" characters outside of the range of `a-zA-Z0-9_-`. This scheme is explained here: [Tilde encoding](https://docs.datasette.io/en/latest/internals.html#internals-tilde-encoding). ([#1657](https://github.com/simonw/datasette/issues/1657)) - Table and row HTML pages now include a `<link rel="alternate" type="application/json+datasette" href="...">` element and return a `Link: URL; rel="alternate"; type="application/json+datasette"` HTTP header pointing to the JSON version of those pages. ([#1533](https://github.com/simonw/datasette/issues/1533)) - `Access-Control-Expose-Headers: Link` is now added to the CORS headers, allowing remote JavaScript to access that header. - Canned queries are now shown at the top of the database page, directly below the SQL editor. Previously they were shown at the bottom, below the list of tables. ([#1612](https://github.com/simonw/datasette/issues/1612)) - Datasette now has a default favicon. ([#1603](https://github.com/simonw/datasette/issues/1603)) - `sqlite_stat` tables are now hidden by default. ([#1587](https://github.com/simonw/datasette/issues/1587)) - SpatiaLite tables `data_licenses`, `KNN` and `KNN2` are now hidden by default. ([#1601](https://github.com/simonw/datasette/issues/1601)) - Python 3.6 is no longer supported. ([#1577](https://github.com/simonw/datasette/issues/1577)) - Tests now run against Python 3.11-dev. ([#1621](https://github.com/simon… | 2022-03-20T01:16:41Z | ["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.4 | 2020-12-05 | - Show [pysqlite3](https://github.com/coleifer/pysqlite3) version on `/-/versions`, if installed. ([#1125](https://github.com/simonw/datasette/issues/1125)) - Errors output by Datasette (e.g. for invalid SQL queries) now go to `stderr`, not `stdout`. ([#1131](https://github.com/simonw/datasette/issues/1131)) - Fix for a startup error on windows caused by unnecessary `from os import EX_CANTCREAT` - thanks, Abdussamet Koçak. ([#1094](https://github.com/simonw/datasette/issues/1094)) | 2020-12-05T19:42:57Z | ["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.24 | 2022-02-16 | - SpatiaLite helpers for the `sqlite-utils` command-line tool - thanks, Chris Amico. ([#398](https://github.com/simonw/sqlite-utils/issues/398)) - [sqlite-utils create-database](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-create-database) `--init-spatialite` option for initializing SpatiaLite on a newly created database. - [sqlite-utils add-geometry-column](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-spatialite) command for adding geometry columns. - [sqlite-utils create-spatial-index](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-spatialite-indexes) command for adding spatial indexes. - `db[table].create(..., if_not_exists=True)` option for [creating a table](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-explicit-create) only if it does not already exist. ([#397](https://github.com/simonw/sqlite-utils/issues/397)) - `Database(memory_name="my_shared_database")` parameter for creating a [named in-memory database](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-connect) that can be shared between multiple connections. ([#405](https://github.com/simonw/sqlite-utils/issues/405)) - Documentation now describes [how to add a primary key to a rowid table](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-transform-table-add-primary-key-to-rowid) using `sqlite-utils transform`. ([#403](https://github.com/simonw/sqlite-utils/issues/403)) | 2022-02-16T01:41:50Z | ["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/2.14 | 2020-08-01 | - The [insert-files command](https://sqlite-utils.readthedocs.io/en/stable/cli.html#cli-insert-files) can now read from standard input: `cat dog.jpg | sqlite-utils insert-files dogs.db pics - --name=dog.jpg`. ([#127](https://github.com/simonw/sqlite-utils/issues/127)) - You can now specify a full-text search tokenizer using the new `tokenize=` parameter to [enable_fts()](https://sqlite-utils.readthedocs.io/en/stable/python-api.html#python-api-fts). This means you can enable Porter stemming on a table by running `db["articles"].enable_fts(["headline", "body"], tokenize="porter")`. ([#130](https://github.com/simonw/sqlite-utils/issues/130)) - You can also set a custom tokenizer using the [sqlite-utils enable-fts](https://sqlite-utils.readthedocs.io/en/stable/cli.html#cli-fts) CLI command, via the new `--tokenize` option. | 2020-08-01T21:00:31Z | ["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.58a0 | 2021-06-10 | - The [menu_links()](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-menu-links), [table_actions()](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-table-actions) and [database_actions()](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-database-actions) plugin hooks all gained a new optional `request` argument providing access to the current request. ([#1371](https://github.com/simonw/datasette/issues/1371)) | 2021-06-10T04:52:45Z | ["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.59a1 | 2021-08-09 | - The [render_cell()](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-render-cell) plugin hook can now return an awaitable function. This means the hook can execute SQL queries. ([#1425](https://github.com/simonw/datasette/issues/1425)) | 2021-08-09T01:14:06Z | ["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.17 | 2021-08-24 | - The [sqlite-utils memory](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-memory) command has a new `--analyze` option, which runs the equivalent of the [analyze-tables](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-analyze-tables) command directly against the in-memory database created from the incoming CSV or JSON data. ([#320](https://github.com/simonw/sqlite-utils/issues/320)) - [sqlite-utils insert-files](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-insert-files) now has the ability to insert file contents in to `TEXT` columns in addition to the default `BLOB`. Pass the `--text` option or use `content_text` as a column specifier. ([#319](https://github.com/simonw/sqlite-utils/issues/319)) | 2021-08-24T23:42:22Z | ["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.19 | 2021-11-21 | - The [table.lookup() method](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-lookup-tables) now accepts keyword arguments that match those on the underlying `table.insert()` method: `foreign_keys=`, `column_order=`, `not_null=`, `defaults=`, `extracts=`, `conversions=` and `columns=`. You can also now pass `pk=` to specify a different column name to use for the primary key. ([#342](https://github.com/simonw/sqlite-utils/issues/342)) | 2021-11-21T04:42:24Z | ["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.47.3 | 2020-08-15 | - The `datasette --get` command-line mechanism now ensures any plugins using the `startup()` hook are correctly executed. ([#934](https://github.com/simonw/datasette/issues/934)) | 2020-08-15T21:03:58Z | ["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.3 | 2021-01-18 | - The `table.m2m()` method now accepts an optional `alter=True` argument to specify that any missing columns should be added to the referenced table. See [Working with many-to-many relationships](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-m2m). ([#222](https://github.com/simonw/sqlite-utils/issues/222)) | 2021-01-18T04:29:48Z | ["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.16 | 2021-08-18 | - Type signatures added to more methods, including `table.resolve_foreign_keys()`, `db.create_table_sql()`, `db.create_table()` and `table.create()`. ([#314](https://github.com/simonw/sqlite-utils/issues/314)) - New `db.quote_fts(value)` method, see [Quoting characters for use in search](https://sqlite-utils.datasette.io/en/stable/python-api.html#python-api-quote-fts) - thanks, Mark Neumann. ([#246](https://github.com/simonw/sqlite-utils/issues/246)) - `table.search()` now accepts an optional `quote=True` parameter. ([#296](https://github.com/simonw/sqlite-utils/issues/296)) - CLI command `sqlite-utils search` now accepts a `--quote` option. ([#296](https://github.com/simonw/sqlite-utils/issues/296)) - Fixed bug where `--no-headers` and `--tsv` options to [sqlite-utils insert](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-insert-csv-tsv) could not be used together. ([#295](https://github.com/simonw/sqlite-utils/issues/295)) - Various small improvements to [API reference](https://sqlite-utils.datasette.io/en/stable/reference.html#reference) documentation. | 2021-08-18T22:37:55Z | ["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.49a1 | 2020-09-14 | - Upgraded [CodeMirror](https://codemirror.net/) to 5.57.0. ([#948](https://github.com/simonw/datasette/issues/948)) - Upgraded code style to Black 20.8b1. ([#958](https://github.com/simonw/datasette/issues/958)) - New `datasette --pdb` option. ([#962](https://github.com/simonw/datasette/issues/962)) - `datasette --get` exit code now reflects the internal HTTP status code. ([#947](https://github.com/simonw/datasette/issues/947)) - Fixed bug where selected facets were not correctly persisted in hidden form fields on the table page. ([#963](https://github.com/simonw/datasette/issues/963)) - New mechanism for defining page templates with custom path parameters. ([#944](https://github.com/simonw/datasette/issues/944)) | 2020-09-14T02:48:19Z | ["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.49 | 2020-09-14 | - Writable canned queries now expose a JSON API, see [JSON API for writable canned queries](https://docs.datasette.io/en/stable/sql_queries.html#canned-queries-json-api). ([#880](https://github.com/simonw/datasette/issues/880)) - New mechanism for defining page templates with custom path parameters - a template file called `pages/about/{slug}.html` will be used to render any requests to `/about/something`. See [Path parameters for pages](https://docs.datasette.io/en/stable/custom_templates.html#custom-pages-parameters). ([#944](https://github.com/simonw/datasette/issues/944)) - `register_output_renderer()` render functions can now return a `Response`. ([#953](https://github.com/simonw/datasette/issues/953)) - New `--upgrade` option for `datasette install`. ([#945](https://github.com/simonw/datasette/issues/945)) - New `datasette --pdb` option. ([#962](https://github.com/simonw/datasette/issues/962)) - `datasette --get` exit code now reflects the internal HTTP status code. ([#947](https://github.com/simonw/datasette/issues/947)) - New `raise_404()` template function for returning 404 errors. ([#964](https://github.com/simonw/datasette/issues/964)) - `datasette publish heroku` now deploys using Python 3.8.5 - Upgraded [CodeMirror](https://codemirror.net/) to 5.57.0. ([#948](https://github.com/simonw/datasette/issues/948)) - Upgraded code style to Black 20.8b1. ([#958](https://github.com/simonw/datasette/issues/958)) - Fixed bug where selected facets were not correctly persisted in hidden form fields on the table page. ([#963](https://github.com/simonw/datasette/issues/963)) - Renamed the default error template from `500.html` to `error.html`. - Custom error pages are now documented, see [Custom error pages](https://docs.datasette.io/en/stable/custom_templates.html#custom-pages-errors). ([#965](https://github.com/simonw/datasette/issues/965)) | 2020-09-14T21:40:11Z | ["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.59a0 | 2021-08-07 | - [register_routes(datasette)](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-register-routes) plugin hook now accepts an optional `datasette` argument. ([#1404](https://github.com/simonw/datasette/issues/1404)) - New `hide_sql` canned query option for defaulting to hiding the SQL quey used by a canned query, see [Additional canned query options](https://docs.datasette.io/en/latest/sql_queries.html#canned-queries-options). ([#1422](https://github.com/simonw/datasette/issues/1422)) - New `--cpu` option for [datasette publish cloudrun](https://docs.datasette.io/en/latest/publish.html#publish-cloud-run). ([#1420](https://github.com/simonw/datasette/issues/1420)) - If [Rich](https://github.com/willmcgugan/rich) is installed in the same virtual environment as Datasette, it will be used to provide enhanced display of error tracebacks on the console. ([#1416](https://github.com/simonw/datasette/issues/1416)) - `datasette.utils` [parse_metadata(content)](https://docs.datasette.io/en/latest/internals.html#internals-utils-parse-metadata) function, used by the new [datasette-remote-metadata plugin](https://datasette.io/plugins/datasette-remote-metadata), is now a documented API. ([#1405](https://github.com/simonw/datasette/issues/1405)) | 2021-08-07T05:42:25Z | ["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.17.1 | 2021-09-22 | - [sqlite-utils memory](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-memory) now works if files passed to it share the same file name. ([#325](https://github.com/simonw/sqlite-utils/issues/325)) - [sqlite-utils query](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-query) now returns `[]` in JSON mode if no rows are returned. ([#328](https://github.com/simonw/sqlite-utils/issues/328)) | 2021-09-22T20:51:04Z | ["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/2.16 | 2020-08-21 | - `--load-extension` option for `sqlite-utils query` for loading SQLite extensions. ([#134](https://github.com/simonw/sqlite-utils/issues/134)) - New `sqlite_utils.utils.find_spatialite()` function for finding SpatiaLite in common locations. ([#135](https://github.com/simonw/sqlite-utils/issues/135)) | 2020-08-21T21:05:51Z | ["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/2.16.1 | 2020-08-28 | - `insert_all(..., alter=True)` now works for columns introduced after the first 100 records. Thanks, Simon Wiles! ([#139](https://github.com/simonw/sqlite-utils/issues/139)) - Continuous Integration is now powered by GitHub Actions. ([#143](https://github.com/simonw/sqlite-utils/issues/143)) | 2020-08-28T22:47:02Z | ["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.49a0 | 2020-08-28 | - `register_output_renderer()` render functions can now return a `Response`. ([#953](https://github.com/simonw/datasette/issues/953)) - New `--upgrade` option for `datasette install`. ([#945](https://github.com/simonw/datasette/issues/945)) - `datasette publish heroku` now deploys using Python 3.8.5 | 2020-08-28T23:18:09Z | ["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.4 | 2021-02-06 | - `sqlite-utils insert --csv` now accepts optional `--delimiter` and `--quotechar` options. See [Alternative delimiters and quote characters](https://sqlite-utils.datasette.io/en/stable/cli.html#cli-insert-csv-tsv-delimiter). ([#223](https://github.com/simonw/sqlite-utils/issues/223)) | 2021-02-06T01:38:26Z | ["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;