SQLite Connection or SQLite Async Connection SQLite Connection or SQLite Async Connection sqlite sqlite

SQLite Connection or SQLite Async Connection


I would involve also consider the size of the project and the scope of it, for example if its a small project then just use the simple, non-async, it's less code and easier to maintain, and most of the small operations happen in milliseconds.

If you want high performance, the go to async, write some extra code and get a better user experience.

Or maybe just use async for the large operations and non-async for the small ones?

I believe it's different for every project, and you could use a mixed approach sometimes, that's IMHO.