Feature : Replace MySQL queries with PostgreSQL and SQLAlchemy query modelling

[SahanDisa]

Is your feature request related to a problem? Please describe.
Yes, the current use of MySQL limits scalability and flexibility due to its licensing and feature set.

Describe the solution you'd like
Transition to PostgreSQL for enhanced performance and scalability, with SQLAlchemy for database abstraction, allowing for more efficient data operations and cross-database compatibility.

Describe alternatives you've considered
Considered sticking with MySQL and exploring NoSQL options, but PostgreSQL offers a superior blend of features and flexibility.

Additional context
N/A