5 rows where repo = 248903544

View and edit SQL

Suggested facets: target_commitish, created_at (date), published_at (date)

id ▼ html_url node_id tag_name target_commitish name draft author prerelease created_at published_at body repo reactions
24731201 https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.1a MDc6UmVsZWFzZTI0NzMxMjAx 0.1a master 0.1a 0 simonw 9599 0 2020-03-21T04:19:07Z 2020-03-21T04:26:28Z * `user` and `trees` commands. hacker-news-to-sqlite 248903544  
24738954 https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.2a MDc6UmVsZWFzZTI0NzM4OTU0 0.2a master 0.2a 0 simonw 9599 0 2020-03-21T15:27:15Z 2020-03-21T19:46:58Z Compatibility with sqlite-utils 1.x hacker-news-to-sqlite 248903544  
24738963 https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.3 MDc6UmVsZWFzZTI0NzM4OTYz 0.3 master 0.3 0 simonw 9599 0 2020-03-21T19:46:08Z 2020-03-21T19:47:36Z First non-alpha release. Now configures full-text search for the `users` and `items` tables. #1 hacker-news-to-sqlite 248903544  
24740687 https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.3.1 MDc6UmVsZWFzZTI0NzQwNjg3 0.3.1 master 0.3.1 0 simonw 9599 0 2020-03-21T22:39:34Z 2020-03-21T22:41:16Z Added documentation on [Browsing your data with Datasette](https://github.com/dogsheep/hacker-news-to-sqlite/blob/0.3.1/README.md#browsing-your-data-with-datasette). hacker-news-to-sqlite 248903544  
39765751 https://github.com/dogsheep/hacker-news-to-sqlite/releases/tag/0.4 MDc6UmVsZWFzZTM5NzY1NzUx 0.4 main 0.4 0 simonw 9599 0 2021-03-13T19:11:12Z 2021-03-13T19:15:06Z Progress display now shows the total as well as the number currently in the queue. ``` % hacker-news-to-sqlite trees hn.db 26440397 done: 1, in queue: 0, total: 1 done: 2, in queue: 28, total: 30 done: 3, in queue: 27, total: 30 ``` hacker-news-to-sqlite 248903544  

Advanced export

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

CSV options:

CREATE TABLE [releases] (
   [html_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [tag_name] TEXT,
   [target_commitish] TEXT,
   [name] TEXT,
   [draft] INTEGER,
   [author] INTEGER REFERENCES [users]([id]),
   [prerelease] INTEGER,
   [created_at] TEXT,
   [published_at] TEXT,
   [body] TEXT,
   [repo] INTEGER REFERENCES [repos]([id])
, [reactions] TEXT);
CREATE INDEX [idx_releases_repo]
                ON [releases] ([repo]);
CREATE INDEX [idx_releases_author]
                ON [releases] ([author]);