issue_comments
4 rows where "created_at" is on date 2020-12-21 sorted by user
This data as json, CSV (advanced)
Suggested facets: issue_url
reactions 1 ✖
id | html_url | issue_url | node_id | user ▼ | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
749158111 | https://github.com/simonw/datasette/issues/1156#issuecomment-749158111 | https://api.github.com/repos/simonw/datasette/issues/1156 | MDEyOklzc3VlQ29tbWVudDc0OTE1ODExMQ== | simonw 9599 | 2020-12-21T19:33:45Z | 2020-12-21T19:33:45Z | OWNER | One reason for this change: it means I can use that database for more stuff. I've been thinking about moving metadata storage there for example, which fits a database called `_internal` but not one called `_schemas`. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Rename _schemas to _internal 772408750 | |
749170608 | https://github.com/simonw/datasette/issues/1155#issuecomment-749170608 | https://api.github.com/repos/simonw/datasette/issues/1155 | MDEyOklzc3VlQ29tbWVudDc0OTE3MDYwOA== | simonw 9599 | 2020-12-21T20:01:47Z | 2020-12-21T20:01:47Z | OWNER | I removed that `MEMORY` object() in dcdfb2c301341d45b66683e3e3be72f9c7585b2f | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Better internal database_name for _internal database 771216293 | |
749176936 | https://github.com/simonw/datasette/issues/1155#issuecomment-749176936 | https://api.github.com/repos/simonw/datasette/issues/1155 | MDEyOklzc3VlQ29tbWVudDc0OTE3NjkzNg== | simonw 9599 | 2020-12-21T20:18:15Z | 2020-12-21T20:18:15Z | OWNER | Fun query: ```sql select table_name, group_concat(name, ', ') from columns group by database_name, table_name ``` https://latest.datasette.io/_internal?sql=select+table_name%2C+group_concat%28name%2C+%27%2C+%27%29+from+columns+group+by+database_name%2C+table_name | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Better internal database_name for _internal database 771216293 | |
749179460 | https://github.com/simonw/datasette/issues/1157#issuecomment-749179460 | https://api.github.com/repos/simonw/datasette/issues/1157 | MDEyOklzc3VlQ29tbWVudDc0OTE3OTQ2MA== | simonw 9599 | 2020-12-21T20:24:19Z | 2020-12-21T20:24:19Z | OWNER | Three places to fix: https://github.com/simonw/datasette/blob/dcdfb2c301341d45b66683e3e3be72f9c7585b2f/datasette/tracer.py#L40-L42 https://github.com/simonw/datasette/blob/dcdfb2c301341d45b66683e3e3be72f9c7585b2f/datasette/utils/__init__.py#L139-L152 https://github.com/simonw/datasette/blob/dcdfb2c301341d45b66683e3e3be72f9c7585b2f/datasette/views/base.py#L460-L461 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Use time.perf_counter() instead of time.time() to measure performance 772438273 |
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]);
updated_at (date) 1 ✖