issue_comments

Table actions

7 rows where issue = 705827457

✎ View and edit SQL

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
696297601 https://github.com/simonw/datasette/issues/971#issuecomment-696297601 https://api.github.com/repos/simonw/datasette/issues/971 MDEyOklzc3VlQ29tbWVudDY5NjI5NzYwMQ== simonw 9599 2020-09-21T18:41:07Z 2020-09-21T18:41:07Z OWNER How to detect it? Looks like it's visible in SQLite compile time options: https://latest.datasette.io/-/versions ``` "compile_options": [ "COMPILER=gcc-8.3.0", "ENABLE_COLUMN_METADATA", "ENABLE_DBSTAT_VTAB", ``` {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support the dbstat table 705827457  
696297930 https://github.com/simonw/datasette/issues/971#issuecomment-696297930 https://api.github.com/repos/simonw/datasette/issues/971 MDEyOklzc3VlQ29tbWVudDY5NjI5NzkzMA== simonw 9599 2020-09-21T18:41:47Z 2020-09-21T18:41:47Z OWNER https://www.sqlite.org/dbstat.html > The DBSTAT virtual table is an eponymous virtual table, meaning that is not necessary to run CREATE VIRTUAL TABLE to create an instance of the dbstat virtual table before using it. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support the dbstat table 705827457  
696298614 https://github.com/simonw/datasette/issues/971#issuecomment-696298614 https://api.github.com/repos/simonw/datasette/issues/971 MDEyOklzc3VlQ29tbWVudDY5NjI5ODYxNA== simonw 9599 2020-09-21T18:43:07Z 2020-09-21T18:43:07Z OWNER Or, do this: ```sql SELECT 1 FROM dbstat limit 1; ``` And see if it returns a "table does not exist" error. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support the dbstat table 705827457  
696302020 https://github.com/simonw/datasette/issues/971#issuecomment-696302020 https://api.github.com/repos/simonw/datasette/issues/971 MDEyOklzc3VlQ29tbWVudDY5NjMwMjAyMA== simonw 9599 2020-09-21T18:49:09Z 2020-09-21T18:49:09Z OWNER ... made harder to work on because I apparently don't have the `DBSTAT_VTAB` module on macOS. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support the dbstat table 705827457  
696302868 https://github.com/simonw/datasette/issues/971#issuecomment-696302868 https://api.github.com/repos/simonw/datasette/issues/971 MDEyOklzc3VlQ29tbWVudDY5NjMwMjg2OA== simonw 9599 2020-09-21T18:50:40Z 2020-09-21T18:50:40Z OWNER Easiest way to get this may be to run `create view dbstat_view as select * from dbstat` on databases that support it. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support the dbstat table 705827457  
696304108 https://github.com/simonw/datasette/issues/971#issuecomment-696304108 https://api.github.com/repos/simonw/datasette/issues/971 MDEyOklzc3VlQ29tbWVudDY5NjMwNDEwOA== simonw 9599 2020-09-21T18:52:50Z 2020-09-21T18:52:50Z OWNER Looks like the `pysqlite3-binary` package doesn't support `dbstat` either. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support the dbstat table 705827457  
696307922 https://github.com/simonw/datasette/issues/971#issuecomment-696307922 https://api.github.com/repos/simonw/datasette/issues/971 MDEyOklzc3VlQ29tbWVudDY5NjMwNzkyMg== simonw 9599 2020-09-21T18:59:52Z 2020-09-21T19:00:02Z OWNER Given `dbstat` isn't as widely available as I thought I'm going to let people who want to use `dbstat` run their own `select * from dbstat` queries rather than bake support directly into Datasette. The experience of exploring `dbstat` will improve if I land support for running facets against arbitrary custom SQL queries, which is half-done in that facets now execute against wrapped subqueries as-of ea66c45df96479ef66a89caa71fff1a97a862646 https://github.com/simonw/datasette/blob/ea66c45df96479ef66a89caa71fff1a97a862646/datasette/facets.py#L192-L200 {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} Support the dbstat table 705827457  

Advanced export

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

CSV options: 

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