issue_comments: 453251589

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/397#issuecomment-453251589 https://api.github.com/repos/simonw/datasette/issues/397 453251589 MDEyOklzc3VlQ29tbWVudDQ1MzI1MTU4OQ== 9599 2019-01-10T20:59:42Z 2019-01-10T20:59:42Z OWNER

What version of SQLite are you seeing in Datasette? You can tell by hitting http://localhost:8001/-/versions - e.g. here: https://latest.datasette.io/-/versions

My best guess is that your Python SQLite module is running an older version that doesn't support window functions.

One way you can fix that is with the pysqlite3 module - try running this in your virtual environment:

pip install git+git://github.com/karlb/pysqlite3

That's using a fork of the official module that embeds a full recent SQLite. See this issue thread for more details: https://github.com/coleifer/pysqlite3/issues/2

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