releases
6 rows where repo = 459821110
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59748955 | https://github.com/simonw/google-drive-to-sqlite/releases/tag/0.1a0 | simonw 9599 | RE_kwDOG2hQNs4Dj7Jb | 0.1a0 | main | 0.1a0 | 0 | 1 | 2022-02-16T22:14:25Z | 2022-02-16T22:18:21Z | This initial alpha release may not work for anyone other than me, as Google still need to verify my OAuth application. - `google-drive-to-sqlite auth` command for authenticating with Google and storing the resulting credentials. [#2](https://github.com/simonw/google-drive-to-sqlite/issues/2) - `google-drive-to-sqlite files` command for fetching file metadata from Google Drive and storing it in a SQLite database file, or outputting it as JSON. [#7](https://github.com/simonw/google-drive-to-sqlite/issues/7) - `google-drive-to-sqlite get` command for executing other authenticated API calls against Google APIs. [#3](https://github.com/simonw/google-drive-to-sqlite/issues/3) | google-drive-to-sqlite 459821110 | ||
| 59774833 | https://github.com/simonw/google-drive-to-sqlite/releases/tag/0.1a1 | simonw 9599 | RE_kwDOG2hQNs4DkBdx | 0.1a1 | main | 0.1a1 | 0 | 1 | 2022-02-17T06:49:50Z | 2022-02-17T06:52:55Z | - New `google-drive-to-sqlite download` command, [documented here](https://github.com/simonw/google-drive-to-sqlite/blob/0.1a1/README.md#google-drive-to-sqlite-download-file_id). [#4](https://github.com/simonw/google-drive-to-sqlite/issues/4) - Fixed bug where `google-drive-to-sqlite get` threw an error if retrieving non-JSON output. [#13](https://github.com/simonw/google-drive-to-sqlite/issues/13) - Increased timeout to 30s. [#8](https://github.com/simonw/google-drive-to-sqlite/issues/8) | google-drive-to-sqlite 459821110 | ||
| 59835984 | https://github.com/simonw/google-drive-to-sqlite/releases/tag/0.1a2 | simonw 9599 | RE_kwDOG2hQNs4DkQZQ | 0.1a2 | main | 0.1a2 | 0 | 1 | 2022-02-17T19:20:42Z | 2022-02-17T19:20:59Z | - Improved README. | google-drive-to-sqlite 459821110 | ||
| 59876495 | https://github.com/simonw/google-drive-to-sqlite/releases/tag/0.2a0 | simonw 9599 | RE_kwDOG2hQNs4DkaSP | 0.2a0 | main | 0.2a0 | 0 | 1 | 2022-02-18T06:33:21Z | 2022-02-18T06:36:07Z | - New `google-drive-to-sqlite revoke` command, for revoking stored credentials. [#16](https://github.com/simonw/google-drive-to-sqlite/issues/16) - If an hour long `access_token` expires while a command is running, the failed request is retried with a new token automatically generated using the `refresh_token`. [#11](https://github.com/simonw/google-drive-to-sqlite/issues/11) | google-drive-to-sqlite 459821110 | ||
| 59978438 | https://github.com/simonw/google-drive-to-sqlite/releases/tag/0.3 | simonw 9599 | RE_kwDOG2hQNs4DkzLG | 0.3 | main | 0.3 | 0 | 0 | 2022-02-19T21:36:14Z | 2022-02-19T21:37:13Z | - New design for the database schema: [#9](https://github.com/simonw/google-drive-to-sqlite/issues/9) - `drive_files` contains files, with a `_parent` foreign key to the parent folder - `drive_folders` contains folders, with a self-referential `_parent` foreign key - `drive_users` contains users who may own or have modified files - `drive_folders_owners` relates folders to their owners - `drive_files_owners` relates files to their owners - The full schema is now included [in the documentation](https://github.com/simonw/google-drive-to-sqlite/blob/0.3/README.md#database-schema). - New `--import-json` and `--import-nl` options to the `files` command for creating a database using JSON data retrieved previously using the `--nl` and `--json` options. [#20](https://github.com/simonw/google-drive-to-sqlite/issues/20) - `--starred`, `--trashed` and `--shared-with-me` options for `files` as shortcuts for constructing more advanced search queries. [#25](https://github.com/simonw/google-drive-to-sqlite/issues/25) - Documentation now has a [quickstart section](https://github.com/simonw/google-drive-to-sqlite/blob/0.3/README.md#quickstart). [#24](https://github.com/simonw/google-drive-to-sqlite/issues/24) | google-drive-to-sqlite 459821110 | ||
| 60003484 | https://github.com/simonw/google-drive-to-sqlite/releases/tag/0.4 | simonw 9599 | RE_kwDOG2hQNs4Dk5Sc | 0.4 | main | 0.4 | 0 | 0 | 2022-02-20T20:12:45Z | 2022-02-20T20:12:49Z | - Redesigned [the schema](https://github.com/simonw/google-drive-to-sqlite/blob/0.4/README.md#database-schema) to reflect that Google Drive files can only have one, not multiple owners. [#34](https://github.com/simonw/google-drive-to-sqlite/issues/34) - Removed `drive_folders_owners` and `drive_files_owners` tables. - `drive_files` and `drive_folders` now have a `_owner` column that is a foreign key to `drive_users`. - New [google-drive-to-sqlite export format file_id](https://github.com/simonw/google-drive-to-sqlite/blob/0.4/README.md#google-drive-to-sqlite-export-format-file_id) command for exporting Google Docs files as different formats such as `pdf`. [#21](https://github.com/simonw/google-drive-to-sqlite/issues/21) - New options to `files`: `--apps` for all Google Docs files of all types, or `--docs`, `--sheets`, `--presentations` and `--drawings` for Google Docs files of specific types. - `google-drive-to-sqlite files` and `get` commands now have a `--verbose` option showing what the tool is doing in detail. - Automatically retries up to twice on HTTP transport errors, with a 2 second delay. [#18](https://github.com/simonw/google-drive-to-sqlite/issues/18) - The `auth.json` file now defaults to `0600` permissions, meaning only the user can read that file on a shared system. [#37](https://github.com/simonw/google-drive-to-sqlite/issues/37) | google-drive-to-sqlite 459821110 |
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]);