issue_comments: 1291115986

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/sqlite-utils/issues/503#issuecomment-1291115986 https://api.github.com/repos/simonw/sqlite-utils/issues/503 1291115986 IC_kwDOCGYnMM5M9N3S 9599 2022-10-25T20:39:24Z 2022-10-25T20:39:24Z OWNER

Used psutil to confirm that closing a SQLite connection closes the underlying file: https://til.simonwillison.net/python/too-many-open-files-psutil ```pycon

import psutil import sqlite3 for f in psutil.Process().open_files(): print(f) ... sqlite3.connect("/tmp/blah.db") <sqlite3.Connection object at 0x1007264d0> conn = _ for f in psutil.Process().open_files(): print(f) ... popenfile(path='/private/tmp/blah.db', fd=3) conn.close() for f in psutil.Process().open_files(): print(f) ...

```

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