recent_releases (view)
1 row where "published_at" is on date 2022-08-14 sorted by release
This data as json, CSV (advanced)
Suggested facets: date (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.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"] |
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;