Hello! I'm self-hosting Prefect with SQLite and I am getting a lot of these errors: https://gist.github.com/valleybay/bb1bd9717596826e125b0343fb20c64a. It says «database is locked». It's repeating every few minutes. Anyone else experiencing this? Have you been able to get Prefect to run smoothly on SQLite?

Hi, I think the best solution is to switch to postgresql.

It's just so much for of a hassle to run it and do backups 😕 Were you in the same situation and wound up switching?

hi @Christian Dalsvaag - at any practical level of usage you're going to want postgres. we'd like to improve all access patterns but sqlite support is mostly there to allow easy onboarding. if you're doing consistent work i'd use postgres

Ah! Alright. Thank you for getting back to me!

I have the same error on prometheus/grafana that use SQLite. I haven't switched yet, but I looked at the origin of the problem and it is the only solution that appeared

Thank you for the tips, @Pierre L! Will check it out