💡 [Feature]: Add SQLite Support for Persistent High Scores in Games

[knoxiboy]

❓ Problem Statement

Currently, high scores for terminal games (like Whack-a-Mole or Typing Speed Tester) are likely lost when the script exits, or they are saved in brittle flat .txt files (e.g., game_results.txt).

🚀 Proposed Enhancement

Implement a lightweight SQLite database wrapper to securely and reliably store user profiles, game statistics, and high scores across all terminal games.

��️ Suggested Implementation

1. Create a utils/db_manager.py that initializes a local data.db file using the built-in sqlite3 module.
2. Provide simple CRUD functions: save_score(game, user, score) and get_top_scores(game).
3. Update the game scripts to query and display the top 5 high scores at the end of a session.

Additional Notes

• I am a registered GSSoC 2026 contributor.
• I would like to implement this feature myself.

[github-actions]

⚠️ Important Contribution Guideline

Please do not open a Pull Request without being assigned to this issue first.

Please do not open a Pull Request without being assigned to this issue first.

How to proceed:

1. Comment on this issue to express interest
2. Wait for maintainers to assign you to the issue
3. Once assigned, you can start working on the PR
4. Include the assignment in your PR checklist

Thank you for helping us maintain a smooth workflow! 🙏

[knoxiboy]

/assign gssoc'26
Hi! @steam-bell-92
I would like to work on this issue under GSSoC'26. Please assign this issue to me.

[Saloni885]

Hi, I’d like to work on this issue.
I can integrate SQLite to store and retrieve persistent high scores for the games.
Please assign this to me.