Hey Folks :wave: Is there any guidance on how to use SQLDelight with background threads? If I try to...

# squarelibraries

[Sebastian Sellmair [JB]]

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.

[Sebastian Sellmair [JB]]

Oh, I see:
https://github.com/cashapp/sqldelight/issues/4779

[Paul Woitaschek]

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

[Sebastian Sellmair [JB]]

due to the concurrency limit of the connection

What is the limit? Is it 1?

[Paul Woitaschek]

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

[Sebastian Sellmair [JB]]

Thank you 👍

[Paul Woitaschek]

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

[Paul Woitaschek]

And it’s probably device specific too for some vendors

[Paul Woitaschek]

@cb
Where did you get the info on the SQLite connection limit from?
https://github.com/chrisbanes/tivi/commit/9f990ec517685990d7b119d17788235cff3502c0

[cb]

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

[Paul Woitaschek]

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