releases

16 rows where repo = 166159072

✎ View and edit SQL

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
15440165 https://github.com/simonw/db-to-sqlite/releases/tag/0.2 simonw 9599 MDc6UmVsZWFzZTE1NDQwMTY1 0.2 master 0.2 0 0 2019-02-08T06:01:44Z 2019-02-08T06:07:36Z `--all` option can now be used to duplicate an entire database, including detecting foreign key relationships. `--table` option called without `--sql` will now mirror the specified table. db-to-sqlite 166159072    
18242211 https://github.com/simonw/db-to-sqlite/releases/tag/0.3 simonw 9599 MDc6UmVsZWFzZTE4MjQyMjEx 0.3 master 0.3 0 0 2019-02-24T21:59:42Z 2019-06-26T15:54:56Z Anchor to sqlite-utils==0.13 to pick up a breaking change. db-to-sqlite 166159072    
18242248 https://github.com/simonw/db-to-sqlite/releases/tag/0.4 simonw 9599 MDc6UmVsZWFzZTE4MjQyMjQ4 0.4 master 0.4 0 0 2019-02-24T23:44:01Z 2019-06-26T15:55:54Z * Create `--all` tables in toposort order * Depend on sqlite-utils version 0.14 or higher db-to-sqlite 166159072    
18242294 https://github.com/simonw/db-to-sqlite/releases/tag/0.5 simonw 9599 MDc6UmVsZWFzZTE4MjQyMjk0 0.5 master 0.5 0 0 2019-06-26T15:44:35Z 2019-06-26T15:57:17Z * Foreign keys are now all added at the end, which means we can support circular foreign key references #1 * Dropped dependency on `toposort` * Added `--all --skip=table` option for skipping one or more tables when running `--all` db-to-sqlite 166159072    
18310609 https://github.com/simonw/db-to-sqlite/releases/tag/0.6 simonw 9599 MDc6UmVsZWFzZTE4MzEwNjA5 0.6 master 0.6 0 0 2019-06-29T15:18:30Z 2019-06-29T15:27:18Z - `--all` can now add many foreign key relationships without a `VACUUM` between each one, #8 - Added unit tests against MySQL, refs #5 db-to-sqlite 166159072    
18312451 https://github.com/simonw/db-to-sqlite/releases/tag/0.7 simonw 9599 MDc6UmVsZWFzZTE4MzEyNDUx 0.7 master 0.7 0 0 2019-06-29T21:27:30Z 2019-06-29T21:31:00Z - Support `pip install db-to-sqlite[postgresql]` #4 - Documentation for both that and `pip install db-to-sqlite[mysql]` db-to-sqlite 166159072    
18312546 https://github.com/simonw/db-to-sqlite/releases/tag/0.8 simonw 9599 MDc6UmVsZWFzZTE4MzEyNTQ2 0.8 master 0.8 0 0 2019-06-29T21:52:48Z 2019-06-29T21:53:58Z * Added `--progress` option to show progress bars during import - #7 db-to-sqlite 166159072    
18320205 https://github.com/simonw/db-to-sqlite/releases/tag/1.0 simonw 9599 MDc6UmVsZWFzZTE4MzIwMjA1 1.0 master 1.0 0 0 2019-07-01T01:23:17Z 2019-07-01T01:32:47Z See the [README](https://github.com/simonw/db-to-sqlite/blob/1.0/README.md) for full usage instructions. * Instead of using `--connection` the connection string is now a required positional argument, #14 * `--sql` must now be accompanied by `--output` specifying the table the query results should be written to * `--redact tablename columnname` option can be used to redact values, #2 * Foreign keys are now created with indexes, use `--no-index-fks` to disable this, #12 * `--table` can now be used multiple times, #6 * README and `--help` now include example connection strings * README also details how this can be used with Heroku Postgres db-to-sqlite 166159072    
18321523 https://github.com/simonw/db-to-sqlite/releases/tag/1.0.1 simonw 9599 MDc6UmVsZWFzZTE4MzIxNTIz 1.0.1 master 1.0.1 0 0 2019-07-01T04:08:01Z 2019-07-01T04:09:04Z * Improvements to README db-to-sqlite 166159072    
19054897 https://github.com/simonw/db-to-sqlite/releases/tag/1.0.2 simonw 9599 MDc6UmVsZWFzZTE5MDU0ODk3 1.0.2 master 1.0.2 0 0 2019-08-03T04:01:00Z 2019-08-03T04:09:41Z Fix for #18 - no longer throws error on empty tables db-to-sqlite 166159072    
23583453 https://github.com/simonw/db-to-sqlite/releases/tag/1.1 simonw 9599 MDc6UmVsZWFzZTIzNTgzNDUz 1.1 master 1.1 0 0 2020-02-11T20:51:33Z 2020-02-11T20:53:57Z Fixed compatibility with `sqlite-utils` 2.x - #20 db-to-sqlite 166159072    
23583861 https://github.com/simonw/db-to-sqlite/releases/tag/1.1.1 simonw 9599 MDc6UmVsZWFzZTIzNTgzODYx 1.1.1 master 1.1.1 0 0 2020-02-11T21:03:26Z 2020-02-11T21:07:10Z I made a mistake with the release of 1.1 to PyPI - this fixes it. db-to-sqlite 166159072    
27012272 https://github.com/simonw/db-to-sqlite/releases/tag/1.2 simonw 9599 MDc6UmVsZWFzZTI3MDEyMjcy 1.2 master 1.2 0 0 2020-05-28T23:15:01Z 2020-05-28T23:17:18Z Bumped to `sqlite-utils` 2.9.1. This fixes two things: - Decimal columns are now supported. They become FLOAT columns in SQLite. - Fixed a bug where columns that were a combination of integers and nulls were incorrectly stored as TEXT, not INTEGER. db-to-sqlite 166159072    
27012417 https://github.com/simonw/db-to-sqlite/releases/tag/1.2.1 simonw 9599 MDc6UmVsZWFzZTI3MDEyNDE3 1.2.1 master 1.2.1 0 0 2020-05-28T23:23:05Z 2020-05-28T23:23:52Z - Changelog badge and project_urls for the [PyPI listing](https://pypi.org/project/db-to-sqlite/). db-to-sqlite 166159072    
29008167 https://github.com/simonw/db-to-sqlite/releases/tag/1.3 simonw 9599 MDc6UmVsZWFzZTI5MDA4MTY3 1.3 master 1.3 0 0 2020-07-27T23:39:04Z 2020-07-27T23:39:27Z - Added support for compound primary keys. #26 db-to-sqlite 166159072    
44508143 https://github.com/simonw/db-to-sqlite/releases/tag/1.4 simonw 9599 MDc6UmVsZWFzZTQ0NTA4MTQz 1.4 main 1.4 0 0 2021-06-11T22:52:06Z 2021-06-11T22:55:56Z - New `--postgres-schema` option for specifying a different PostgreSQL schema, thanks Jeremy Dormitzer. [#29](https://github.com/simonw/db-to-sqlite/pull/29) - Correctly handles table names that need escaping, such as `user` in PostgreSQL. [#25](https://github.com/simonw/db-to-sqlite/issues/25) - Empty tables are now created in the SQLite database with a matching schema, rather than being skipped. [#28](https://github.com/simonw/db-to-sqlite/issues/28) - Connection strings starting with `postgres://` are treated as if they started with `postgresql://`. [#34](https://github.com/simonw/db-to-sqlite/issues/34) db-to-sqlite 166159072    

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