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.