Clearing Tech Debt / Code Refactoring

[cliffchew84]

Description: Currently, the codebase is in quite a mess, as the sole developer @cliffchew84 has been focused on just trying to hack out a somehow workable tool for himself. However, he understands that his code is in dire need of much refactoring and repayment of tech debt.

Proposed solutions / help needed:

• [x] General clean up current code base to remove legacy backend code
• [x] Refactor current FastAPI main.py file into more maintainable
• [ ] Removal of old accounts that have not logged in for more than X months
• [ ] Adding of unit tests ( what types of units tests can be further discussion )

[kiritowu]

Other potential improvements includes:

• [ ] More modern dependencies management with uv or poetry
• [x] Implement Supabase-CLI as local staging environment for postgre database and data migration requirement without touching production environment.
• [x] Documentation for getting started as developer with code formatting best practices. (#159 )
• [ ] Implement ORM with pydantic for NLB api and database operations. This is to introduce stricter type safety and Better isolation for ideal MVC structure.