github
html_url | issue_url | id | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
https://github.com/simonw/datasette/issues/356#issuecomment-495931078 | https://api.github.com/repos/simonw/datasette/issues/356 | 495931078 | MDEyOklzc3VlQ29tbWVudDQ5NTkzMTA3OA== | 9599 | 2019-05-25T16:30:09Z | 2019-05-25T16:30:09Z | OWNER | Implemented in https://github.com/simonw/datasette/commit/d923d847545e829bf946bb9170bebfc7c3f9d993 Documentation here: https://datasette.readthedocs.io/en/latest/facets.html#facet-by-many-to-many Demo here: https://latest.datasette.io/fixtures/roadside_attractions | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 346028655 | |
https://github.com/simonw/datasette/issues/356#issuecomment-495931140 | https://api.github.com/repos/simonw/datasette/issues/356 | 495931140 | MDEyOklzc3VlQ29tbWVudDQ5NTkzMTE0MA== | 9599 | 2019-05-25T16:30:59Z | 2019-05-25T16:30:59Z | OWNER | I went with a much more simple URL scheme: `?_facet_m2m=destination_table` (it then figures out which the middle table is by looking at the foreign keys). This can be extended to be more complicated in the future if needed. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 346028655 | |
https://github.com/simonw/datasette/pull/365#issuecomment-495929743 | https://api.github.com/repos/simonw/datasette/issues/365 | 495929743 | MDEyOklzc3VlQ29tbWVudDQ5NTkyOTc0Mw== | 9599 | 2019-05-25T16:09:54Z | 2019-05-25T16:09:54Z | OWNER | That last commit referenced the wrong ticket - it was meant to reference #356 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 361764460 | |
https://github.com/simonw/sqlite-utils/issues/18#issuecomment-495818358 | https://api.github.com/repos/simonw/sqlite-utils/issues/18 | 495818358 | MDEyOklzc3VlQ29tbWVudDQ5NTgxODM1OA== | 9599 | 2019-05-25T00:16:50Z | 2019-05-25T00:16:50Z | OWNER | Oh that's really interesting - yeah I think having an option to insert if missing, skip otherwise would be a good feature. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 413871266 | |
https://github.com/simonw/sqlite-utils/issues/20#issuecomment-495818849 | https://api.github.com/repos/simonw/sqlite-utils/issues/20 | 495818849 | MDEyOklzc3VlQ29tbWVudDQ5NTgxODg0OQ== | 9599 | 2019-05-25T00:21:04Z | 2019-05-25T00:21:04Z | OWNER | I'm going to implement this using a new `--json-cols` option which works by detecting any string value that starts with [ or { and is valid JSON. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 432727685 | |
https://github.com/simonw/sqlite-utils/issues/21#issuecomment-495818615 | https://api.github.com/repos/simonw/sqlite-utils/issues/21 | 495818615 | MDEyOklzc3VlQ29tbWVudDQ5NTgxODYxNQ== | 9599 | 2019-05-25T00:19:04Z | 2019-05-25T00:19:04Z | OWNER | I think this can be implemented as an `--ignore` option to `sqlite-utils insert` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 448391492 | |
https://github.com/simonw/sqlite-utils/issues/22#issuecomment-495823173 | https://api.github.com/repos/simonw/sqlite-utils/issues/22 | 495823173 | MDEyOklzc3VlQ29tbWVudDQ5NTgyMzE3Mw== | 9599 | 2019-05-25T01:17:55Z | 2019-05-25T01:17:55Z | OWNER | Shipped 1.0 to PyPI! | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 448395665 | |
https://github.com/simonw/sqlite-utils/issues/22#issuecomment-495823219 | https://api.github.com/repos/simonw/sqlite-utils/issues/22 | 495823219 | MDEyOklzc3VlQ29tbWVudDQ5NTgyMzIxOQ== | 9599 | 2019-05-25T01:18:27Z | 2019-05-25T01:18:27Z | OWNER | https://sqlite-utils.readthedocs.io/en/latest/changelog.html#v1-0 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 448395665 |