releases

5 rows where repo = 486732669

✎ View and edit SQL

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
65622173 https://github.com/simonw/datasette-copy-to-memory/releases/tag/0.1a0 simonw 9599 RE_kwDOHQLzfc4D6VCd 0.1a0 main 0.1a0 0 1 2022-04-28T20:03:43Z 2022-04-28T20:05:30Z - Initial prototype: copies each attached database file to an in-memory database on startup. [#1](https://github.com/simonw/datasette-copy-to-memory/issues/1) datasette-copy-to-memory 486732669    
65625093 https://github.com/simonw/datasette-copy-to-memory/releases/tag/0.1a1 simonw 9599 RE_kwDOHQLzfc4D6VwF 0.1a1 main 0.1a1 0 1 2022-04-28T20:47:24Z 2022-04-28T20:48:43Z - [Plugin configuration](https://github.com/simonw/datasette-copy-to-memory/blob/0.1a1/README.md#configuration) can now be used to select specific databases to be copied into memory on startup. [#2](https://github.com/simonw/datasette-copy-to-memory/issues/2) datasette-copy-to-memory 486732669    
65626275 https://github.com/simonw/datasette-copy-to-memory/releases/tag/0.1a2 simonw 9599 RE_kwDOHQLzfc4D6WCj 0.1a2 main 0.1a2 0 1 2022-04-28T21:06:25Z 2022-04-28T21:07:09Z - Fixed crash when attempting to load an immutable database. [#3](https://github.com/simonw/datasette-copy-to-memory/issues/3) datasette-copy-to-memory 486732669    
65628670 https://github.com/simonw/datasette-copy-to-memory/releases/tag/0.1a3 simonw 9599 RE_kwDOHQLzfc4D6Wn- 0.1a3 main 0.1a3 0 1 2022-04-28T21:47:08Z 2022-04-28T21:48:59Z - Fixed a bug where the plugin would generate unnecessary `file:...` files every time it ran. [#4](https://github.com/simonw/datasette-copy-to-memory/issues/4) - Plugin now has a live demo running on [latest-with-plugins.datasette.io/fixtures_memory](https://latest-with-plugins.datasette.io/fixtures_memory). [#5](https://github.com/simonw/datasette-copy-to-memory/issues/5) datasette-copy-to-memory 486732669    
65742145 https://github.com/simonw/datasette-copy-to-memory/releases/tag/0.2 simonw 9599 RE_kwDOHQLzfc4D6yVB 0.2 main 0.2 0 0 2022-04-30T19:47:07Z 2022-04-30T19:49:29Z - New `replace: true` plugin configuration option for replacing the file database with the in-memory one, rather than adding a new `/db_memory` route that duplicates that database. [#6](https://github.com/simonw/datasette-copy-to-memory/issues/6) datasette-copy-to-memory 486732669    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);