SQLite Forum

Feature request, PRAGMA for setting default transaction mode
Login
Hello SQLite maintainers,

I am building a middleware application that uses SQLite as a database engine. I am using the WAL mode and setting a busy handler which help a lot with concurrency. My main issue though is that deferred transactions result in many database locked errors. I am trying to overcome that by injecting "immediate" whenever my code sees a transaction coming from the client code. It would be very helpful and more resilient if I could globally change the default transaction mode on the connection level. Something like:

PRAGMA default_transaction_mode = immediate;

Would something like this be useful to other SQLite users? would the maintainers be interested in implementing this?