Based on https://blog.pecar.me/django-sqlite-benchmark (and https://blog.pecar.me/django-sqlite-dblock) by @anze3db this is my current settings for #Sqlite in #Django. It seems more stable than the default, although I've only done limited testing.
I'm still unsure about the foreign_keys pragma, but coming from PostgreSQL, it at least sounds like something I want.
Feedback appreciated!
=> More informations about this toot | View the thread | More toots from adamghill@indieweb.social
=> View anze3db@fosstodon.org profile
=> View sqlite tag | View django tag This content has been proxied by September (ba2dc).Proxy Information
text/gemini