issue_comments
22 rows where "updated_at" is on date 2018-07-10
This data as json, CSV (advanced)
Suggested facets: issue
reactions 2 ✖
id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
345750135 | https://github.com/simonw/datasette/issues/137#issuecomment-345750135 | https://api.github.com/repos/simonw/datasette/issues/137 | MDEyOklzc3VlQ29tbWVudDM0NTc1MDEzNQ== | simonw 9599 | 2017-11-20T16:30:56Z | 2018-07-10T17:53:13Z | OWNER | One possible route: introduce prefixes eg `?a.Trees.age__gt=5&a.Trees._group_count=qSpecies&b.Trees.age__gt=10&b.Trees._group_count=qSpecies` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Ability to combine multiple SQL queries on a single graph 275415799 | |
398133159 | https://github.com/simonw/datasette/issues/316#issuecomment-398133159 | https://api.github.com/repos/simonw/datasette/issues/316 | MDEyOklzc3VlQ29tbWVudDM5ODEzMzE1OQ== | simonw 9599 | 2018-06-18T17:29:59Z | 2018-07-10T15:14:53Z | OWNER | For #271 I've been contemplating having Datasette work against an on-disk database that gets modified without needing to restart the server. For that to work, I'll have to dramatically change the inspect() mechanism. It may be that inspect becomes an optional optimization in the future. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | datasette inspect takes a very long time on large dbs 333238932 | |
403672561 | https://github.com/simonw/datasette/issues/334#issuecomment-403672561 | https://api.github.com/repos/simonw/datasette/issues/334 | MDEyOklzc3VlQ29tbWVudDQwMzY3MjU2MQ== | simonw 9599 | 2018-07-10T01:45:28Z | 2018-07-10T01:45:28Z | OWNER | Tested with `datasette publish heroku fixtures.db --extra-options="--config sql_time_limit_ms:4000"` https://blooming-anchorage-31561.herokuapp.com/-/config | {"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 1, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | extra_options not passed to heroku publisher 339095976 | |
403855639 | https://github.com/simonw/datasette/issues/323#issuecomment-403855639 | https://api.github.com/repos/simonw/datasette/issues/323 | MDEyOklzc3VlQ29tbWVudDQwMzg1NTYzOQ== | simonw 9599 | 2018-07-10T15:03:36Z | 2018-07-10T15:03:36Z | OWNER | I'm satisified with the improvement we got from the pip wheel cache. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Speed up Travis CI builds 334698969 | |
403855963 | https://github.com/simonw/datasette/issues/330#issuecomment-403855963 | https://api.github.com/repos/simonw/datasette/issues/330 | MDEyOklzc3VlQ29tbWVudDQwMzg1NTk2Mw== | simonw 9599 | 2018-07-10T15:04:31Z | 2018-07-10T15:04:31Z | OWNER | This relates to #276 - I'm definitely convinced now that displaying a giant `b'...'` blob on the page is not a useful default. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Limit text display in cells containing large amounts of text 336924199 | |
403856114 | https://github.com/simonw/datasette/issues/331#issuecomment-403856114 | https://api.github.com/repos/simonw/datasette/issues/331 | MDEyOklzc3VlQ29tbWVudDQwMzg1NjExNA== | simonw 9599 | 2018-07-10T15:04:56Z | 2018-07-10T15:04:56Z | OWNER | Great idea. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Datasette throws error when loading spatialite db without extension loaded 336936010 | |
403858949 | https://github.com/simonw/datasette/issues/331#issuecomment-403858949 | https://api.github.com/repos/simonw/datasette/issues/331 | MDEyOklzc3VlQ29tbWVudDQwMzg1ODk0OQ== | simonw 9599 | 2018-07-10T15:12:53Z | 2018-07-10T15:13:04Z | OWNER | ``` $ datasette airports.sqlite Serve! files=('airports.sqlite',) on port 8001 Usage: datasette airports.sqlite [OPTIONS] [FILES]... Error: It looks like you're trying to load a SpatiaLite database without first loading the SpatiaLite module. Read more: https://datasette.readthedocs.io/en/latest/spatialite.html ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Datasette throws error when loading spatialite db without extension loaded 336936010 | |
403863927 | https://github.com/simonw/datasette/issues/335#issuecomment-403863927 | https://api.github.com/repos/simonw/datasette/issues/335 | MDEyOklzc3VlQ29tbWVudDQwMzg2MzkyNw== | simonw 9599 | 2018-07-10T15:26:27Z | 2018-07-10T15:29:54Z | OWNER | Here are some useful examples of other Python apps that have been packaged using the recipe described above: https://github.com/Homebrew/homebrew-core/search?utf8=%E2%9C%93&q=virtualenv_install_with_resources&type= | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Package datasette for installation using homebrew 339505204 | |
403865063 | https://github.com/simonw/datasette/issues/335#issuecomment-403865063 | https://api.github.com/repos/simonw/datasette/issues/335 | MDEyOklzc3VlQ29tbWVudDQwMzg2NTA2Mw== | simonw 9599 | 2018-07-10T15:29:32Z | 2018-07-10T15:29:32Z | OWNER | Huh... from https://docs.brew.sh/Acceptable-Formulae > We frown on authors submitting their own work unless it is very popular. Marking this one as "help wanted" :) | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Package datasette for installation using homebrew 339505204 | |
403866099 | https://github.com/simonw/datasette/issues/335#issuecomment-403866099 | https://api.github.com/repos/simonw/datasette/issues/335 | MDEyOklzc3VlQ29tbWVudDQwMzg2NjA5OQ== | simonw 9599 | 2018-07-10T15:32:14Z | 2018-07-10T15:32:14Z | OWNER | I can host a custom tap without needing to get anything accepted into homebrew-core: https://docs.brew.sh/How-to-Create-and-Maintain-a-Tap Since my principle goal here is ensuring an easy installation path for people who are familiar with `brew` but don't know how to use pip and Python 3 that could be a good option. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Package datasette for installation using homebrew 339505204 | |
403868584 | https://github.com/simonw/datasette/issues/330#issuecomment-403868584 | https://api.github.com/repos/simonw/datasette/issues/330 | MDEyOklzc3VlQ29tbWVudDQwMzg2ODU4NA== | simonw 9599 | 2018-07-10T15:39:12Z | 2018-07-10T16:21:08Z | OWNER | I think this makes sense for the HTML view (not for JSON or CSV). It could be controlled be a new [config option](http://datasette.readthedocs.io/en/latest/config.html), `truncate_cells_html` - which is on by default but can be turned off. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Limit text display in cells containing large amounts of text 336924199 | |
403906747 | https://github.com/simonw/datasette/issues/330#issuecomment-403906747 | https://api.github.com/repos/simonw/datasette/issues/330 | MDEyOklzc3VlQ29tbWVudDQwMzkwNjc0Nw== | simonw 9599 | 2018-07-10T17:39:46Z | 2018-07-10T17:39:46Z | OWNER | ``` datasette publish now timezones.db --spatialite \ --extra-options="--config truncate_cells_html:200" \ --name=datasette-issue-330-demo \ --branch=master ``` https://datasette-issue-330-demo-sbelwxttfn.now.sh/timezones-3cb9f64/timezones ![2018-07-10 at 10 39 am](https://user-images.githubusercontent.com/9599/42527428-7eabc6c8-842d-11e8-91ac-5666dbc5872c.png) But https://datasette-issue-330-demo-sbelwxttfn.now.sh/timezones-3cb9f64/timezones/1 displays the full blob. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Limit text display in cells containing large amounts of text 336924199 | |
403907193 | https://github.com/simonw/datasette/issues/330#issuecomment-403907193 | https://api.github.com/repos/simonw/datasette/issues/330 | MDEyOklzc3VlQ29tbWVudDQwMzkwNzE5Mw== | simonw 9599 | 2018-07-10T17:41:14Z | 2018-07-10T17:41:14Z | OWNER | Documentation: http://datasette.readthedocs.io/en/latest/config.html#truncate-cells-html | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Limit text display in cells containing large amounts of text 336924199 | |
403908704 | https://github.com/simonw/datasette/issues/191#issuecomment-403908704 | https://api.github.com/repos/simonw/datasette/issues/191 | MDEyOklzc3VlQ29tbWVudDQwMzkwODcwNA== | simonw 9599 | 2018-07-10T17:46:13Z | 2018-07-10T17:46:13Z | OWNER | I consider this resolved by #46 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Figure out how to bundle a more up-to-date SQLite 310533258 | |
403909389 | https://github.com/simonw/datasette/issues/139#issuecomment-403909389 | https://api.github.com/repos/simonw/datasette/issues/139 | MDEyOklzc3VlQ29tbWVudDQwMzkwOTM4OQ== | simonw 9599 | 2018-07-10T17:48:18Z | 2018-07-10T17:48:18Z | OWNER | This is done! https://github.com/simonw/datasette-vega | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Build a visualization plugin for Vega 275493851 | |
403909469 | https://github.com/simonw/datasette/issues/143#issuecomment-403909469 | https://api.github.com/repos/simonw/datasette/issues/143 | MDEyOklzc3VlQ29tbWVudDQwMzkwOTQ2OQ== | simonw 9599 | 2018-07-10T17:48:34Z | 2018-07-10T17:48:34Z | OWNER | This is now a dupe of https://github.com/simonw/datasette-vega/issues/4 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Mechanism for "suggested visualizations" 275939188 | |
403909671 | https://github.com/simonw/datasette/issues/87#issuecomment-403909671 | https://api.github.com/repos/simonw/datasette/issues/87 | MDEyOklzc3VlQ29tbWVudDQwMzkwOTY3MQ== | simonw 9599 | 2018-07-10T17:49:12Z | 2018-07-10T17:49:12Z | OWNER | This was fixed by https://github.com/simonw/datasette/commit/6a32684ebba89dfe882e1147b23aa8778479f5d8#diff-354f30a63fb0907d4ad57269548329e3 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Configure Travis to release new tags to PyPI 273709194 | |
403910318 | https://github.com/simonw/datasette/issues/140#issuecomment-403910318 | https://api.github.com/repos/simonw/datasette/issues/140 | MDEyOklzc3VlQ29tbWVudDQwMzkxMDMxOA== | simonw 9599 | 2018-07-10T17:51:11Z | 2018-07-10T17:51:11Z | OWNER | This would be a nice example plugin to demonstrate plugin configuration options in #231 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Heatmap visualization plugin 275755475 | |
403910774 | https://github.com/simonw/datasette/issues/27#issuecomment-403910774 | https://api.github.com/repos/simonw/datasette/issues/27 | MDEyOklzc3VlQ29tbWVudDQwMzkxMDc3NA== | simonw 9599 | 2018-07-10T17:52:41Z | 2018-07-10T17:52:41Z | OWNER | I consider this handled by https://github.com/simonw/datasette-vega | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Ability to plot a simple graph 267886330 | |
403939399 | https://github.com/simonw/datasette/issues/140#issuecomment-403939399 | https://api.github.com/repos/simonw/datasette/issues/140 | MDEyOklzc3VlQ29tbWVudDQwMzkzOTM5OQ== | simonw 9599 | 2018-07-10T19:30:17Z | 2018-07-10T19:30:41Z | OWNER | Building this using Svelte would also produce a neat example of a plugin that uses Svelte: https://svelte.technology/guide - and if I like it I might part datasette-vega to it. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Heatmap visualization plugin 275755475 | |
403959704 | https://github.com/simonw/datasette/issues/272#issuecomment-403959704 | https://api.github.com/repos/simonw/datasette/issues/272 | MDEyOklzc3VlQ29tbWVudDQwMzk1OTcwNA== | simonw 9599 | 2018-07-10T20:44:47Z | 2018-07-10T20:44:47Z | OWNER | No cookies or sessions - no POST requests in fact, Datasette just cares about GET (path and querystring) and being able to return custom HTTP headers. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Port Datasette to ASGI 324188953 | |
403996143 | https://github.com/simonw/datasette/issues/336#issuecomment-403996143 | https://api.github.com/repos/simonw/datasette/issues/336 | MDEyOklzc3VlQ29tbWVudDQwMzk5NjE0Mw== | simonw 9599 | 2018-07-10T23:21:27Z | 2018-07-10T23:21:27Z | OWNER | Easiest way to do this I think would be to make those help blocks separate files in the docs/ directory (publish-help.txt perhaps) and then include them with a sphinx directive: https://reinout.vanrees.org/weblog/2010/12/08/include-external-in-sphinx.html | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Ensure --help examples in docs are always up to date 340039409 |
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]);
created_at (date) 3 ✖