home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 808978808

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/1276#issuecomment-808978808 https://api.github.com/repos/simonw/datasette/issues/1276 808978808 MDEyOklzc3VlQ29tbWVudDgwODk3ODgwOA== 9599 2021-03-28T23:32:58Z 2021-03-28T23:33:58Z OWNER

I just managed to replicate this bug on Glitch: https://nicar-2020.glitch.me/data

Invalid SQL no such table: pragma_database_list

https://nicar-2020.glitch.me/-/versions says:

json { "python": { "version": "3.7.10", "full": "3.7.10 (default, Feb 20 2021, 21:21:24) \n[GCC 5.4.0 20160609]" }, "datasette": { "version": "0.55" }, "asgi": "3.0", "uvicorn": "0.13.4", "sqlite": { "version": "3.11.0", "fts_versions": [ "FTS4", "FTS3" ], "extensions": { "json1": null }, "compile_options": [ "ENABLE_COLUMN_METADATA", "ENABLE_DBSTAT_VTAB", "ENABLE_FTS3", "ENABLE_FTS3_PARENTHESIS", "ENABLE_JSON1", "ENABLE_LOAD_EXTENSION", "ENABLE_RTREE", "ENABLE_UNLOCK_NOTIFY", "ENABLE_UPDATE_DELETE_LIMIT", "HAVE_ISNAN", "LIKE_DOESNT_MATCH_BLOBS", "MAX_SCHEMA_RETRY=25", "OMIT_LOOKASIDE", "SECURE_DELETE", "SOUNDEX", "SYSTEM_MALLOC", "TEMP_STORE=1", "THREADSAFE=1" ] } } That's SQLite 3.11.0 from 2016-02-15 with no FTS5.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
841456306  
Powered by Datasette · Queries took 1.073ms · About: github-to-sqlite