[Feature Request]: Set database to WAL mode

[RustyNova016]

Checklist

• I am using an up-to-date version.
• I have read the documentation.
• I have searched existing issues.

Description

This is a pretty nerdy request, but would it possible to set the underlying sqlite database to use Write-Ahead Logging? This doesn't provide any benefits to the app, but would allow external programs to read and edit the database at the same time that the app is open without being scared of corrupting it

This may also prevent breakage in case multiple instances of TagStudio are open on the same library (I don't know if there's anything that prevent this already, but having multiple layers is always nice)

Solution

Set the database connection to wal mode on creation and migrate existing databases to use the new mode

Alternatives

No response

[Computerdores]

If we do this the backup code for the database will probably need to be adjusted. And if we are already doing that we should probably migrate to the backup API which sqlite provides