BUG: Implement Thread-Safe Database Connection Management

### Is there an existing issue for this?

- [x] I have searched the existing issues

### What happened?

The current implementation in
connection.py
uses check_same_thread=False which disables SQLite's thread safety checks, potentially leading to race condition plus inconsistent application state

this code snippet is causing it :)
conn = sqlite3.connect(DATABASE_PATH, check_same_thread=False,)

@rahulharpal1603 - let me know if I can work on this issue

### Record

- [x] I agree to follow this project's Code of Conduct