Enhancement: Improve database error handling in connection layer

[Ayushd172005]

Is there an existing issue for this?

• I have searched the existing issues

What happened?

The current database layer uses broad exception handling, which makes debugging difficult.

This issue proposes:

• Using specific SQLite exceptions
• Improving error logging

This is being addressed in PR #1246.
#1246

Record

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

👋 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 :)

[JITENDRAGAHERWAR03]

Hello 👋
I am interested in working on this issue. I have basic knowledge of Python and I’m eager to learn and contribute. I will try to provide a clean and well-documented solution.
Please assign this issue to me if possible.
Thank you 😊