I have a console app that uses threads, I have a db property in the app (app.db) , however in the thread I cannot access it?. Is there a way to have it visible to threads, I don’t really want to open the DB in the thread as its called thousands of times?
never share a db connection across threads
Don’t worry, you can’t! its invisible to threads. So does this also mean in a thread you should not open up a sqllite db and update it with multiuser set to true?
I guess I can dump it all into an array, then from a timer in app, read and update. This would be better anyway so I can do larger transactions
oh you could share one db instance across threads but you shouldnt
I’m glad its actually a pain in the butt to share one
you can use multiple connections like this safely