MacOS: setup fails with AttributeError: 'sqlite3.Connection' object has no attribute 'enable_load_extension'

[guthriec]

Hi! This is a very cool idea. I'm thinking of writing something similar actually, hopefully that can be packaged as a single local desktop app.

Unfortunately I wasn't able to test out your service. Both ./service_cmd.py create-db and requests subsequently made to the uvicorn server error with the message given in the issue title. Some preliminary Googling suggests that sqlite on MacOS doesn't allow loading extensions.

Suggested mitigations:

• Don't use sqlite extensions?
• Specify that sqlite extensions are a requirement in the docs

Thanks!