Some tweaks that I keep for my personal toy webservices:

    PRAGMA journal_mode = WAL;
    PRAGMA busy_timeout = 5000;
    PRAGMA synchronous = NORMAL;
    PRAGMA cache_size = 1000000000;
    PRAGMA foreign_keys = true;
    PRAGMA temp_store = memory;

And use BEGIN IMMEDIATE transactions.

https://kerkour.com/sqlite-for-servers