issue_comments: 386879509

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/251#issuecomment-386879509 https://api.github.com/repos/simonw/datasette/issues/251 386879509 MDEyOklzc3VlQ29tbWVudDM4Njg3OTUwOQ== 9599 2018-05-06T13:29:26Z 2018-05-06T13:29:26Z OWNER

We can solve this using the sqlite_timelimit(conn, 20) helper, which can tell SQLite to give up after 20ms. We can wrap that around the following SQL:

select distinct COLUMN from TABLE limit 21;

Then we look at the number of rows returned. If it's 21 or more we know that this table had more than 21 distinct values, so we'll treat it as "unlimited". Likewise, if the SQL times out before 20ms is up we will skip this introspection.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 320592643