Habit Tracker Console Application

Authored by Corey Jordan

May 12th, 2023

---

This a C# Console Application designed to store and track habits on a very basic level.
This application makes use of Sqlite and CRUD operations.

Requirements

• Application must store and retrieve data from a database
• Application must create a db if one does not exist
• The app must create a table in the db where the habit will be stored
• The app must be able to perform CRUD operations
• The application must exit only upon user request
• Cannot use data mappers, raw SQL only
• Project must contain a ReadMe file

Challenges

• User can create custom habits and units of measurement
• App to have report functionality

Thoughts

1. My knowledge of SQL is limited. Basic crud ops are simple. I ran into trouble creating a table to store units of measurement. In the end, I used the habit's tabe name as a key for the unit table but this feels incorrect. I also was unsure how to combine the queries into some sort of joiner and ended up performing 2 queries for the report function.
2. A lot of the program code is UI specific but feels a bit long and jumbled. In the future I might look for a better way to further seperate the program responsibilities. I do feel as though I seperated data logic and UI logic fairly well.
3. I need to improve writing my commits. I do well enough to keep the commit message concise but I seldom explain in more detail afterwards.