[tombert]

I love the idea of SQLite, but I actually really dislike using it.

I think part of my issue is that a lot of uses of it end up having a big global lock on the database file (see: older versions of Emby/Jellyfin) so you can't use it with multiple threads or processes, but I also haven't really ever find a case to use it over other options. I've never really felt the need to do anything like a JOIN or a UNION when doing local configurations, and for anything more complicated than a local configuration, I likely have access to Postgres or something. I mean, the executable for Postgres is only ten megs or twenty on Linux, so it's not even that much bigger than SQLite for modern computers.

[mjmas]

  PRAGMA journal_mode = WAL;

And set the busy timeout tunction as well.

https://www.sqlite.org/c3ref/busy_timeout.html

[sdoering]

Curious, what do you think about

> PRAGMA synchronous = NORMAL;

I am just not experienced enough to form an opinion.