issue_comments: 747764712

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-747764712 https://api.github.com/repos/simonw/datasette/issues/1150 747764712 MDEyOklzc3VlQ29tbWVudDc0Nzc2NDcxMg== 9599 2020-12-17T23:16:31Z 2020-12-17T23:16:31Z OWNER

Quick micro-benchmark, run against a folder with 46 database files adding up to 1.4GB total:

import pathlib, sqlite3, time

paths = list(pathlib.Path(".").glob('*.db'))

def schema_version(path):
    db = sqlite3.connect(path)
    version = db.execute("PRAGMA schema_version").fetchall()[0]
    db.close()
    return version

def all():
    versions = {}
    for path in paths:
        versions[path.name] = schema_version(path)
    return versions

start = time.time(); all(); print(time.time() - start)
# 0.012346982955932617

So that's 12ms.

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