Thanks and hmmm, this is really really strange. Coud you run conda list and check which version of sqlite it has installed by default? Maybe you’ve ended up with some old version with bad defaults compiled into it (which is a known issue).
To help debug this, could you find line 302 in prodigy/components/db.py and add a print statement above it that outputs the example it’s adding (to find the last one it eventually fails on)? For example, like this:
print(eg)
eg = Example.create(input_hash=eg[INPUT_HASH_ATTR],
task_hash=eg[TASK_HASH_ATTR],
content=content)
To find the location of your Prodigy installation, you can run the following:
python -c "import prodigy; print(prodigy.__file__)"
Finally, if this is all too annoying and you just want to get started, it might be easier to install MySQL on your system. In your prodigy.json, you can set "db": "mysql" and then use the "db_settings" to specify your username, database and password. See here for details.