BUG: Improve SQLite concurrency handling to prevent database is locked errors

[sujal111]

Is there an existing issue for this?

• I have searched the existing issues

What happened?

Under concurrent access (multiple requests / threads), SQLite can raise intermittent database is locked errors.
The current connection setup does not configure SQLite’s recommended concurrency and timeout PRAGMAs, which makes the application more fragile under parallel reads/writes.

could be solved using db optimisations which sqlite3 provides :)

@rahulharpal1603 - let me know if I can pick this up

Record

• I agree to follow this project's Code of Conduct

[github-actions]

👋 Thanks for opening this issue! The maintainers will review it shortly. Till then, do not open any PR. This is a strict rule we like to follow around here :)