releases

8 rows where repo = 280500027

✎ 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
28693674 https://github.com/simonw/datasette-insert/releases/tag/0.1a simonw 9599 MDc6UmVsZWFzZTI4NjkzNjc0 0.1a main 0.1a 0 1 2020-07-17T23:23:02Z 2020-07-17T23:23:56Z - First working release - supports unauthenticated POST of a JSON list to `/-/update/database-name/table-name` datasette-insert 280500027    
28716684 https://github.com/simonw/datasette-insert/releases/tag/0.2a simonw 9599 MDc6UmVsZWFzZTI4NzE2Njg0 0.2a main 0.2a 0 1 2020-07-19T19:08:52Z 2020-07-19T19:09:54Z * Renamed plugin from `datasette-update-api` to `datasette-insert-api`. #7 * Add `?alter=1` to create any missing table columns. #5 datasette-insert 280500027    
28719838 https://github.com/simonw/datasette-insert/releases/tag/0.3 simonw 9599 MDc6UmVsZWFzZTI4NzE5ODM4 0.3 main 0.3 0 0 2020-07-20T00:08:38Z 2020-07-20T00:09:18Z - Implement basic "allow" permissions. #4 - Support inserts of a single record in addition to lists. #6 datasette-insert 280500027    
28791432 https://github.com/simonw/datasette-insert/releases/tag/0.4 simonw 9599 MDc6UmVsZWFzZTI4NzkxNDMy 0.4 main 0.4 0 0 2020-07-21T16:23:41Z 2020-07-21T16:25:15Z - More finely grained plugin permissions: `insert-api:all`, `insert-api:insert-update`, `insert-api:create-table`, `insert-api:alter-table`. #8 datasette-insert 280500027    
28949618 https://github.com/simonw/datasette-insert/releases/tag/0.5 simonw 9599 MDc6UmVsZWFzZTI4OTQ5NjE4 0.5 main 0.5 0 0 2020-07-25T20:31:28Z 2020-07-25T20:31:51Z Renamed this plugin `datasette-insert` The user-facing consequences of this are: * The plugin configuration block is now called `"datasette-insert"` (it was previously called `"datasette-insert-api") * The permissions that used to be called `insert-api:all`, `insert-api:insert-update`, `insert-api:create-table` and `insert-api:alter-table` are now called `insert:all`, `insert:insert-update`, `insert:create-table` and `insert:alter-table` datasette-insert 280500027    
29182979 https://github.com/simonw/datasette-insert/releases/tag/0.6 simonw 9599 MDc6UmVsZWFzZTI5MTgyOTc5 0.6 main 0.6 0 0 2020-07-31T21:42:35Z 2020-07-31T21:43:14Z - Locked down by default. This plugin no longer defaults to allowing all, reducing the risk that someone may deploy it insecurely. #15 datasette-insert 280500027    
67003493 https://github.com/simonw/datasette-insert/releases/tag/0.7 simonw 9599 RE_kwDOELgXO84D_mRl 0.7 main 0.7 0 0 2022-05-16T18:43:10Z 2022-05-16T18:45:09Z - New `/-/upsert/db/table?pk=id` API endpoint for performing upserts, where partial JSON documents can be provided and those keys will be updated on existing row or used to create new rows if a matching row does not exist. [#9](https://github.com/simonw/datasette-insert/issues/9) datasette-insert 280500027    
72638056 https://github.com/simonw/datasette-insert/releases/tag/0.8 simonw 9599 RE_kwDOELgXO84EVF5o 0.8 main 0.8 0 0 2022-07-22T17:50:41Z 2022-07-22T17:52:23Z - Now serves CORS headers if Datasette is started with the `--cors` option. [#17](https://github.com/simonw/datasette-insert/issues/17) datasette-insert 280500027    

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