issue_comments: 747804254

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/1150#issuecomment-747804254 https://api.github.com/repos/simonw/datasette/issues/1150 747804254 MDEyOklzc3VlQ29tbWVudDc0NzgwNDI1NA== 9599 2020-12-18T01:12:13Z 2020-12-18T01:12:13Z OWNER

Prototype: https://latest.datasette.io/fixtures?sql=select+%27facetable%27+as+%27table%27%2C+*+from+pragma_table_xinfo%28%27facetable%27%29%0D%0Aunion%0D%0Aselect+%27searchable%27+as+%27table%27%2C+*+from+pragma_table_xinfo%28%27searchable%27%29%0D%0Aunion%0D%0Aselect+%27compound_three_primary_keys%27+as+%27table%27%2C+*+from+pragma_table_xinfo%28%27compound_three_primary_keys%27%29

select 'facetable' as 'table', * from pragma_table_xinfo('facetable')
union
select 'searchable' as 'table', * from pragma_table_xinfo('searchable')
union
select 'compound_three_primary_keys' as 'table', * from pragma_table_xinfo('compound_three_primary_keys')
<table> <thead> <tr> <th>table</th> <th>cid</th> <th>name</th> <th>type</th> <th>notnull</th> <th>dflt_value</th> <th>pk</th> <th>hidden</th> </tr> </thead> <tbody> <tr> <td>compound_three_primary_keys</td> <td>0</td> <td>pk1</td> <td>varchar(30)</td> <td>0</td> <td> </td> <td>1</td> <td>0</td> </tr> <tr> <td>compound_three_primary_keys</td> <td>1</td> <td>pk2</td> <td>varchar(30)</td> <td>0</td> <td> </td> <td>2</td> <td>0</td> </tr> <tr> <td>compound_three_primary_keys</td> <td>2</td> <td>pk3</td> <td>varchar(30)</td> <td>0</td> <td> </td> <td>3</td> <td>0</td> </tr> <tr> <td>compound_three_primary_keys</td> <td>3</td> <td>content</td> <td>text</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>0</td> <td>pk</td> <td>integer</td> <td>0</td> <td> </td> <td>1</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>1</td> <td>created</td> <td>text</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>2</td> <td>planet_int</td> <td>integer</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>3</td> <td>on_earth</td> <td>integer</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>4</td> <td>state</td> <td>text</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>5</td> <td>city_id</td> <td>integer</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>6</td> <td>neighborhood</td> <td>text</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>7</td> <td>tags</td> <td>text</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>8</td> <td>complex_array</td> <td>text</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>facetable</td> <td>9</td> <td>distinct_some_null</td> <td> </td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>searchable</td> <td>0</td> <td>pk</td> <td>integer</td> <td>0</td> <td> </td> <td>1</td> <td>0</td> </tr> <tr> <td>searchable</td> <td>1</td> <td>text1</td> <td>text</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>searchable</td> <td>2</td> <td>text2</td> <td>text</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> <tr> <td>searchable</td> <td>3</td> <td>name with . and spaces</td> <td>text</td> <td>0</td> <td> </td> <td>0</td> <td>0</td> </tr> </tbody> </table>
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
770436876