releases
10 rows where repo = 219372133
This data as json, CSV (advanced)
Suggested facets: target_commitish, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21179411 | https://github.com/simonw/sqlite-transform/releases/tag/0.1 | simonw 9599 | MDc6UmVsZWFzZTIxMTc5NDEx | 0.1 | master | 0.1 | 0 | 0 | 2019-11-04T01:07:27Z | 2019-11-04T02:19:37Z | - First release, supporting only the `parsedatetime` command. | sqlite-transform 219372133 | ||
| 21179472 | https://github.com/simonw/sqlite-transform/releases/tag/0.2 | simonw 9599 | MDc6UmVsZWFzZTIxMTc5NDcy | 0.2 | master | 0.2 | 0 | 0 | 2019-11-04T02:21:24Z | 2019-11-04T02:26:57Z | - Added `lambda` command, which lets you specify a Python expression (or multiple lines of code) to be executed against every value in the column. [Documentation here](https://github.com/simonw/sqlite-transform/blob/0.2/README.md#lambda-for-executing-your-own-code). (#2) - Added a `parsedate` command, which works like `parsedatetime` except it outputs just the date component. (#1) | sqlite-transform 219372133 | ||
| 21180593 | https://github.com/simonw/sqlite-transform/releases/tag/0.3 | simonw 9599 | MDc6UmVsZWFzZTIxMTgwNTkz | 0.3 | master | 0.3 | 0 | 0 | 2019-11-04T04:37:39Z | 2019-11-04T04:39:06Z | - `return` is now optional for one-line lambdas, e.g. ``` sqlite-transform lambda my.db mytable mycolumn --code='str(value).upper()' ``` | sqlite-transform 219372133 | ||
| 36569163 | https://github.com/simonw/sqlite-transform/releases/tag/0.3.1 | simonw 9599 | MDc6UmVsZWFzZTM2NTY5MTYz | 0.3.1 | main | 0.3.1 | 0 | 0 | 2021-01-18T21:00:34Z | 2021-01-18T21:01:06Z | - Better `--help` for `sqlite-transform lambda`. [#7](https://github.com/simonw/sqlite-transform/issues/7) | sqlite-transform 219372133 | ||
| 38437426 | https://github.com/simonw/sqlite-transform/releases/tag/0.4 | simonw 9599 | MDc6UmVsZWFzZTM4NDM3NDI2 | 0.4 | main | 0.4 | 0 | 0 | 2021-02-22T17:03:09Z | 2021-02-22T17:04:53Z | - New `sqlite-transform jsonsplit` for converting `foo,bar` into `["foo", "bar"]`. [#10](https://github.com/simonw/sqlite-transform/issues/10) - Added `--dry-run` option to `sqlite-tranfsorm lambda` for previewing the conversion that is about to be applied. [#8](https://github.com/simonw/sqlite-transform/issues/8) | sqlite-transform 219372133 | ||
| 40384056 | https://github.com/simonw/sqlite-transform/releases/tag/0.5 | simonw 9599 | MDc6UmVsZWFzZTQwMzg0MDU2 | 0.5 | main | 0.5 | 0 | 0 | 2021-03-24T22:58:23Z | 2021-03-24T22:59:15Z | - `--dayfirst` and `--yearfirst` options for `parsedate` and `parsedatetime` commands. [#12](https://github.com/simonw/sqlite-transform/issues/12) | sqlite-transform 219372133 | ||
| 46513014 | https://github.com/simonw/sqlite-transform/releases/tag/1.0 | simonw 9599 | MDc6UmVsZWFzZTQ2NTEzMDE0 | 1.0 | main | 1.0 | 0 | 0 | 2021-07-21T01:01:47Z | 2021-07-21T01:05:05Z | New `--output colname` and `--output-type integer` options for all of the commands, see [saving the result to a separate column](https://github.com/simonw/sqlite-transform/blob/1.0/README.md#saving-the-result-to-a-separate-column). [#13](https://github.com/simonw/sqlite-transform/issues/13) | sqlite-transform 219372133 | ||
| 46562894 | https://github.com/simonw/sqlite-transform/releases/tag/1.1 | simonw 9599 | MDc6UmVsZWFzZTQ2NTYyODk0 | 1.1 | main | 1.1 | 0 | 0 | 2021-07-21T19:04:18Z | 2021-07-21T19:05:25Z | New `-s` or `--silent` option for hiding the progress bar. [#14](https://github.com/simonw/sqlite-transform/issues/14) | sqlite-transform 219372133 | ||
| 46722535 | https://github.com/simonw/sqlite-transform/releases/tag/1.2 | simonw 9599 | MDc6UmVsZWFzZTQ2NzIyNTM1 | 1.2 | main | 1.2 | 0 | 0 | 2021-07-25T00:59:41Z | 2021-07-25T01:02:14Z | - `sqlite-transform lambda --multi` option allowing the function to return a Python dictionary defining multiple columns that will be created and populated. [#4](https://github.com/simonw/sqlite-transform/issues/4) - `--drop` option can be used with `--output` or `--multi` to drop the original column. [#15](https://github.com/simonw/sqlite-transform/issues/15) - All commands now require at least one column to be specified. [#17](https://github.com/simonw/sqlite-transform/issues/17) | sqlite-transform 219372133 | ||
| 47188058 | https://github.com/simonw/sqlite-transform/releases/tag/1.2.1 | simonw 9599 | MDc6UmVsZWFzZTQ3MTg4MDU4 | 1.2.1 | main | 1.2.1 | 0 | 0 | 2021-08-02T22:06:20Z | 2021-08-02T22:07:57Z | - **This tool is no longer maintained**. The latest release of [sqlite-utils](https://sqlite-utils.datasette.io/) introduces a new [sqlite-utils convert](https://sqlite-utils.datasette.io/en/stable/cli.html#converting-data-in-columns) command which provides a super-set of the functionality provided by `sqlite-transform`. [#11](https://github.com/simonw/sqlite-transform/issues/11) | sqlite-transform 219372133 |
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]);