This is a simple budgeting app that allows a user to set a daily budget and keep track of expenses per day. The application keeps a running total based on the number of days you have been using the application and the total expenses during this time. This project is based on an sinatra/ruby backend connected to a posgres SQL database using a adapter pattern. The sql database has two tables on for the expenses and one for the dates and daily budget. In the future I wish to adapt this to three tables to seperate the date and daily budget to allow for more flexability. These tables are many to one relationship because there can be more than one expense for each day but only one date for each expense. The front-end uses vanilla HTML and CSS.
To start building this application I started with a basic file using cookies/session to store the data to be used for the application. This included dates, daily budget, and expenses. AFter getting the application working, I pulled out all of the methods creating, retrieving, updating, and deleting data from the main application file into a session persistance file to set up a simple interation between the session and the main file. Lastly, I changed the session persistance file into a data persistance file that connected to a prosgre SQL database using an adapter pattern.
In the future I wish to impliment a way to change the date for each expense on the edit page. Also I want to extract the daily budget from the day table in the sql database and create its own table. This will allow flexablity for the future. I will be able to allow users the oppertunity to change the daily budget going forward instead of changing all of the days daily budgets in one change.