Forums

sqlite / aiosqlite

I am trying to use ON CONFLICT but it seems the version of aiosqlite / SQLite does not support it with the packages available in python anywhere. Is there a way I can change the versions?

JoeV2 | 6 posts | Feb. 6, 2022, 5:44 p.m. | permalink

I see that you're on an older system image -- you can upgrade the system image to the most recent one and set the default Python version to more recent one as well, that should upgrade SQLite version. Regarding asiosqlite you may install it with pip (mind that async code would not work in the web app, though).

pafk | 2973 posts | PythonAnywhere staff | Feb. 7, 2022, 10:46 a.m. | permalink

This helped me thank you so much!

JoeV2 | 6 posts | Feb. 7, 2022, 6:40 p.m. | permalink

Glad to hear that!

pafk | 2973 posts | PythonAnywhere staff | Feb. 8, 2022, 9:52 a.m. | permalink