issue_comments: 585962849
This data as json
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/670#issuecomment-585962849 | https://api.github.com/repos/simonw/datasette/issues/670 | 585962849 | MDEyOklzc3VlQ29tbWVudDU4NTk2Mjg0OQ== | 9599 | 2020-02-13T20:44:18Z | 2020-02-13T20:46:53Z | OWNER | Got the database page working! It lists tables, their columns and their row count. Got the table page partially working! It can list rows. It can't apply filters yet (because PostgreSQL `$1` parameters differ from SQLite `:blah` parameters) and faceting doesn't work because PostgreSQL requires that subqueries have an alias: ``` subquery in FROM must have an alias HINT: For example, FROM (SELECT ...) [AS] foo. ``` Still a pretty promising start though! | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 564833696 |