fix: add acquire timeout to sqlite database connection

[ellie]

This should fix #1503

I wasn't able to trigger enough IO pressure for the SQL connection to be a problem.

This adds local_timeout to the client config. This is a float, and represents the number of seconds (units in line with the other timeouts, though those are ints). Users may well want to reduce this if they regularly have issues, but by default I think 2s is fine and avoids a non-responsive system in bad situations.

[ellie]

Oh also I am still planning on adding an Atuin daemon, which should totally avoid the issue referenced above. Just

1. That's a MUCH larger change
2. We'd probably want timeouts there too anyway

[happysalada]

if you have a moment to make a new release, I'd be happy to update the version on nixos and make another test.
Nixos on rebuilds does a lot of IO, so it will be very easy to check that the problem didn't hide another problem.
Finally, thank you for making this and for all the time you spent on this project!

[ppom0]

Thanks a lot @ellie, it seems great! I'll wait for a release, but no stress about this ofc.

My use case is the same as happysalada, I'm using NixOS too, and its rebuilds are very IO intensive.