Console Habit Logger

This is a basic CRUD console application for runners. It tracks what distance has a person run on a specific date. Appication was developed using C# and SQLite. In order to make UI a bit more interactive, I used Specter.

Requirements

• The habit can only be tracked by quantity (in this case app tracks distance).
• When the application starts a new table in a database should be created if it doesn't exist.
• User should be able to view, insert, update and delete data from the database.
• Errors should be handled so that the app doesn't crash
• Application can interact with the database only using ADO.NET.

How does the app work

When the program is started, if table doesn't already exist, new table is created. Then, the following UI is displayed.

View

Insert

Update

Delete

Experience

Before doing this project, I went through the tutorial series "Introduction to Object Oriented Programming" and "Introduction to SQL", where I got to refresh my knowledge of OOP concepts and basics of SQLite, gaining a bit different perspective on things I'm already familliar with. "Introduction to OOP" series motivated me to make use of basic Spectre library features in this project. After finishing the first version of this project, I went back and used parametrized queries to make application more secure.

In the future, I might consider adding new functionalities to this app, like making it possible for the user to create new habits to track.