Fix SQLITE_BUSY issues when using sqlite on disk

microsoft / durabletask-go

The Durable Task Framework is a lightweight, embeddable engine for writing durable, fault-tolerant business logic (orchestrations) as ordinary code.

Apache License 2.0

178 stars 25 forks source link

Closed cgillum closed 11 months ago

cgillum commented 11 months ago

This PR makes a few changes to the sqlite backend:

The default database mode is in-memory instead of writing to a file (more appropriate for dev/test)
The default connection count is set to 1 in all cases. This fixes the SQLITE_BUSY problem. We can revisit this in the future if performance becomes an issue.
Fixes a couple small static analysis warnings.

FYI @ItalyPaleAle