Simon Binder

Thanks for the report! Does the exception print a stack trace? It should not be possible to hit that error in sqlite since moor is supposed to have guards against...

You could open two separate instances of your database: One for reading and one for writing. A recent feature that was originally introduced for isolates can be used to synchronize...

> it should be easy enough to write a little helper for running read and write blocks that resolve the correct connection That sounds like a good idea. I was...

Cool idea with the override and `CustomSelectStatement` subclass. Did you see any performance benefits so far? Since sqlite3 apis are synchronous, I assume the best performance gains are reached by...

The `MultiExecutor` approach is on `develop` now. I've just opted for a single `QueryExecutor` for reads (as opposed to a creator function) since there wouldn't be any performance benefits. It...

I think most of what was discussed here is still up-to-date. Isolates and cross-isolate communication have gotten a lot cheaper in recent Dart/Flutter versions, so I definitely recommend using [drift's...

> i dont want to loop for all element in the list and all the update function to update Why not? That's a valid approach to solve this. Multiple statements...

Inside a batch, you have to use ```dart await batch((batch) { batch.replaceAll(income, dataList); }); ```

Can you post a snippet that reproduces this behavior?

Thanks for the additional information! Judging from the error code, it looks like the database is somehow getting used after being closed. I'm not yet sure how that could have...