Hey Folks 👋 Is there any guidance on how to use SQLDelight with background threads? If I try to wrap my transaction with

withContext(Dispatchers.IO) {
     database.transactionWithResult { 
          ...
     }
}

Then I see

java.lang.IllegalStateException: Transaction objects (`TransactionWithReturn` and `TransactionWithoutReturn`) must be used only within the transaction lambda scope.

Bitw you should limit the parallelism, or your will block threads due to the concurrency limit of the connection

due to the concurrency limit of the connection

What is the limit? Is it 1?

For Android it’s 1 thread for writing and 4 for reading

Thank you 👍

I didn’t find official documentations on the actual limit of WAL

I don't remember tbh. I was probably just copying the Android configuration.

I read it in another slack space but also couldn’t find any sources on this