https://www.sqlite.org/pragma.html does a pretty good job on the tradeoffs. Something like WAL you'd want to look a bit deeper on... but need not go too far afield: https://www.sqlite.org/wal.html