releases
5 rows where repo = 470338069
This data as json, CSV (advanced)
Suggested facets: prerelease, created_at (date), published_at (date)
| id ▼ | html_url | author | node_id | tag_name | target_commitish | name | draft | prerelease | created_at | published_at | body | repo | reactions | mentions_count |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61940776 | https://github.com/simonw/datasette-hashed-urls/releases/tag/0.1a0 | simonw 9599 | RE_kwDOHAjKFc4DsSQo | 0.1a0 | main | 0.1a0 | 0 | 1 | 2022-03-15T22:44:41Z | 2022-03-15T22:46:07Z | - Initial alpha release. [#1](https://github.com/simonw/datasette-hashed-urls/issues/1) | datasette-hashed-urls 470338069 | ||
| 61959462 | https://github.com/simonw/datasette-hashed-urls/releases/tag/0.2 | simonw 9599 | RE_kwDOHAjKFc4DsW0m | 0.2 | main | 0.2 | 0 | 0 | 2022-03-16T04:35:16Z | 2022-03-16T04:35:26Z | - The URL for a cached database file is now `/fixtures-aa7318b` - previously it used an underscore. This ensures compatibility with existing installations that had used Datasette's now deprecated [hashed URL mode](https://docs.datasette.io/en/0.60.2/performance.html#hashed-url-mode). [#3](https://github.com/simonw/datasette-hashed-urls/issues/3) - The `max-age` in the cache header can nowbe configured using the `max_age` plugin configuration setting. [#6](https://github.com/simonw/datasette-hashed-urls/issues/6) - Cache header is now `cache-control: max-age=31536000, public` - which has been tested with the cache provided by [Vercel](https://vercel.com/). [#4](https://github.com/simonw/datasette-hashed-urls/issues/4) | datasette-hashed-urls 470338069 | ||
| 62621892 | https://github.com/simonw/datasette-hashed-urls/releases/tag/0.3 | simonw 9599 | RE_kwDOHAjKFc4Du4jE | 0.3 | main | 0.3 | 0 | 0 | 2022-03-23T20:40:29Z | 2022-03-23T20:42:49Z | - Now depends on [Datasette 0.61.1](https://docs.datasette.io/en/stable/changelog.html#v0-61-1) - Fixes several bugs: [#9](https://github.com/simonw/datasette-hashed-urls/issues/9), [#10](https://github.com/simonw/datasette-hashed-urls/issues/10), [#12](https://github.com/simonw/datasette-hashed-urls/issues/12), [#13](https://github.com/simonw/datasette-hashed-urls/issues/13) - thanks for the QA, Forest Gregg. | datasette-hashed-urls 470338069 | ||
| 62642726 | https://github.com/simonw/datasette-hashed-urls/releases/tag/0.3.1 | simonw 9599 | RE_kwDOHAjKFc4Du9om | 0.3.1 | main | 0.3.1 | 0 | 0 | 2022-03-24T03:22:55Z | 2022-03-24T03:23:43Z | - Fixed a bug where the necessary CORS headers were not included with the redirects. [#14](https://github.com/simonw/datasette-hashed-urls/issues/14) | datasette-hashed-urls 470338069 | ||
| 62720704 | https://github.com/simonw/datasette-hashed-urls/releases/tag/0.4 | simonw 9599 | RE_kwDOHAjKFc4DvQrA | 0.4 | main | 0.4 | 0 | 0 | 2022-03-24T17:54:52Z | 2022-03-24T20:52:04Z | - If run with Datasette's `--crossdb` option to enable [cross-database queries](https://docs.datasette.io/en/stable/sql_queries.html#cross-database-queries) the `/_memory` database now gains a hash that is the combined hash of all of the attached immutable databases. [Example query](https://datasette-hashed-urls.vercel.app/_memory?sql=select+*+from+fixtures.facetable+union+all+select+*+from+fixtures2.facetable). [#15](https://github.com/simonw/datasette-hashed-urls/issues/15) | datasette-hashed-urls 470338069 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [releases] (
[html_url] TEXT,
[id] INTEGER PRIMARY KEY,
[author] INTEGER REFERENCES [users]([id]),
[node_id] TEXT,
[tag_name] TEXT,
[target_commitish] TEXT,
[name] TEXT,
[draft] INTEGER,
[prerelease] INTEGER,
[created_at] TEXT,
[published_at] TEXT,
[body] TEXT,
[repo] INTEGER REFERENCES [repos]([id])
, [reactions] TEXT, [mentions_count] INTEGER);
CREATE INDEX [idx_releases_repo]
ON [releases] ([repo]);
CREATE INDEX [idx_releases_author]
ON [releases] ([author]);