issue_comments: 982006544

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/344#issuecomment-982006544 https://api.github.com/repos/simonw/sqlite-utils/issues/344 982006544 IC_kwDOCGYnMM46iDsQ 9599 2021-11-29T20:44:37Z 2021-11-29T20:48:43Z OWNER

This worked: cd /tmp mkdir sqlite-3.37 cd sqlite-3.37 wget 'https://www.sqlite.org/2021/sqlite-amalgamation-3370000.zip' unzip sqlite-amalgamation-3370000.zip git clone https://github.com/coleifer/pysqlite3/ cp sqlite-amalgamation-3370000/sqlite3.[ch] pysqlite3 cd pysqlite3 python3 setup.py build_static build bdist_wheel This gave me a file here:

pysqlite3 % ls -l dist total 1872 -rw-r--r-- 1 simon wheel 956557 Nov 29 12:38 pysqlite3-0.4.6-cp39-cp39-macosx_10_15_x86_64.whl That wheel only works when installed for Python 3.9 (it failed to install in a Python 3.10 virtual environment) - but pip install /tmp/sqlite-3.37/pysqlite3/dist/pysqlite3-0.4.6-cp39-cp39-macosx_10_15_x86_64.whl gave me a working pysqlite3 - and the following worked:

```pycon

import pysqlite3 pysqlite3.connect(":memory:").execute("select sqlite_version()").fetchall() [('3.37.0',)] And if I install `sqlite-utils` in the same virtual environment this works: % sqlite-utils memory 'select sqlite_version()' [{"sqlite_version()": "3.37.0"}] ```

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