issue_comments
7 rows where issue = 677926613
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
| id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 673068327 | https://github.com/simonw/datasette/issues/931#issuecomment-673068327 | https://api.github.com/repos/simonw/datasette/issues/931 | MDEyOklzc3VlQ29tbWVudDY3MzA2ODMyNw== | simonw 9599 | 2020-08-12T19:33:42Z | 2020-08-12T19:33:42Z | OWNER | https://hub.docker.com/r/datasetteproject/datasette/tags shows this: <img width="1282" alt="datasetteproject_datasette_Tags_-_Docker_Hub" src="https://user-images.githubusercontent.com/9599/90059445-0b3e6680-dc98-11ea-9e21-c473b6e9b55d.png"> | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Docker container is no longer being pushed (it's stuck on 0.45) 677926613 | |
| 673068919 | https://github.com/simonw/datasette/issues/931#issuecomment-673068919 | https://api.github.com/repos/simonw/datasette/issues/931 | MDEyOklzc3VlQ29tbWVudDY3MzA2ODkxOQ== | simonw 9599 | 2020-08-12T19:34:57Z | 2020-08-12T19:34:57Z | OWNER | Looks like SpatiaLite released new versions: https://www.gaia-gis.it/fossil/freexl/index says "Sources: current version is 1.0.6 (released on 2020-08-02)" and links to http://www.gaia-gis.it/gaia-sins/freexl-1.0.6.tar.gz | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Docker container is no longer being pushed (it's stuck on 0.45) 677926613 | |
| 673070308 | https://github.com/simonw/datasette/issues/931#issuecomment-673070308 | https://api.github.com/repos/simonw/datasette/issues/931 | MDEyOklzc3VlQ29tbWVudDY3MzA3MDMwOA== | simonw 9599 | 2020-08-12T19:37:55Z | 2020-08-12T19:37:55Z | OWNER | Project news here: https://groups.google.com/g/spatialite-users/c/8AG3hQzXDmo > FreeXL > ============================== > the current stable version is now 1.0.6 > (supporting few minor bug fixes and refreshed > build scripts) > DONE: no further development is expected in > the near future. > > http://www.gaia-gis.it/gaia-sins/freexl-1.0.6.tar.gz > http://www.gaia-gis.it/gaia-sins/freexl-1.0.6.zip > > > ReadOSM > =============================== > the current stable version is now 1.1.0a > (supporting few minor bug fixes and refreshed > build scripts) > DONE: no further development is expected in > the near future. > > http://www.gaia-gis.it/gaia-sins/readosm-1.1.0a.tar.gz > http://www.gaia-gis.it/gaia-sins/readosm-1.1.0a.zip > > > VirtualPG > =============================== > the current stanle version is now 2.0.0 > (supporting few minor bug fixes and refreshed > build scripts) > DONE: no further development is expected in > the near future. > > http://www.gaia-gis.it/gaia-sins/virtualpg-2.0.0.tar.gz > http://www.gaia-gis.it/gaia-sins/virtualpg-2.0.0.zip > > > libspatialite > =============================== > 5.0.0 Release Candidate 1 (RC1) is now ready > to become a stable release. > I'll simply wait for more or less a week so to > allow for a reasonable community testing; if > no critical issue will be reported in the meanwhile > I'll go ASAP to release 5.0.0 "stable" > > http://www.gaia-gis.it/gaia-sins/libspatialite-5.0.0-RC1.tar.gz > http://www.gaia-gis.it/gaia-sins/libspatialite-5.0.0-RC1.zip > > > librasterlite2 > ================================ > still under active development. > a very relevant milestone has been achieved, > now the DB layout required for fully integrating > libspatialte and librasterlie2 is definetely > consolidated, no further changes are expected. > > http://www.gaia-gis.it/gaia-sins/librasterlite2-sources/librasterlite2-1.1.0-beta1.tar.gz > http://www.gaia-gis.it/gaia-sins/librasterlite2-sources/librasterlit… | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Docker container is no longer being pushed (it's stuck on 0.45) 677926613 | |
| 673074297 | https://github.com/simonw/datasette/issues/931#issuecomment-673074297 | https://api.github.com/repos/simonw/datasette/issues/931 | MDEyOklzc3VlQ29tbWVudDY3MzA3NDI5Nw== | simonw 9599 | 2020-08-12T19:46:29Z | 2020-08-12T19:46:29Z | OWNER | Looks like the old files have moved to: - http://www.gaia-gis.it/gaia-sins/spatialite-tools-sources/ - http://www.gaia-gis.it/gaia-sins/libspatialite-sources/ | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Docker container is no longer being pushed (it's stuck on 0.45) 677926613 | |
| 673088110 | https://github.com/simonw/datasette/issues/931#issuecomment-673088110 | https://api.github.com/repos/simonw/datasette/issues/931 | MDEyOklzc3VlQ29tbWVudDY3MzA4ODExMA== | simonw 9599 | 2020-08-12T20:15:28Z | 2020-08-12T20:15:28Z | OWNER | I changed the Dockerfile and built it on my laptop using: docker build -f Dockerfile -t datasette-updated-spatialite . | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Docker container is no longer being pushed (it's stuck on 0.45) 677926613 | |
| 673104851 | https://github.com/simonw/datasette/issues/931#issuecomment-673104851 | https://api.github.com/repos/simonw/datasette/issues/931 | MDEyOklzc3VlQ29tbWVudDY3MzEwNDg1MQ== | simonw 9599 | 2020-08-12T20:52:08Z | 2020-08-12T20:52:08Z | OWNER | ``` docker run -p 8001:8001 -v `pwd`:/mnt \ datasette-updated-spatialite \ datasette -p 8001 -h 0.0.0.0 /mnt/fixtures.db --load-extension=/usr/local/lib/mod_spatialite.so ``` This seems to work `/-/versions` reports the SpatiaLite versions as expected: ``` "extensions": { "json1": null, "spatialite": "4.4.0-RC0" }, ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Docker container is no longer being pushed (it's stuck on 0.45) 677926613 | |
| 673123213 | https://github.com/simonw/datasette/issues/931#issuecomment-673123213 | https://api.github.com/repos/simonw/datasette/issues/931 | MDEyOklzc3VlQ29tbWVudDY3MzEyMzIxMw== | simonw 9599 | 2020-08-12T21:36:20Z | 2020-08-12T21:36:20Z | OWNER | That worked: https://hub.docker.com/r/datasetteproject/datasette/tags | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Docker container is no longer being pushed (it's stuck on 0.45) 677926613 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [issue_comments] (
[html_url] TEXT,
[issue_url] TEXT,
[id] INTEGER PRIMARY KEY,
[node_id] TEXT,
[user] INTEGER REFERENCES [users]([id]),
[created_at] TEXT,
[updated_at] TEXT,
[author_association] TEXT,
[body] TEXT,
[reactions] TEXT,
[issue] INTEGER REFERENCES [issues]([id])
, [performed_via_github_app] TEXT);
CREATE INDEX [idx_issue_comments_issue]
ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
ON [issue_comments] ([user]);