Inspiration
Out of the 4 members of our team, two of our families have bought houses in the past year and another is currently on the market for one. Due to the market and other conditions, finding a good price for your house along with knowing where you stand is quite difficult. This challenge resonated with us because it's something we struggled with as our families went through the process.
What it does
Our application processes all the sample data provided by Fannie Mae, determines whether the data from each row approves a person or not, and inserts it into our local running database. We have a calculator page where a potential buyer can input their info and figure out if they'll be approved or not, along with a visualization of why they may not have been approved. Finally we also have a page with several pie charts that analyzes the processed data we have in our database.
How we built it
Our frontend is made of plain HTML/CSS and javascript. Our backend consists of a prisma client accessing a postgresql database, a logic folder where we set up scripts to insert/empty data into our database and our processing logic as well.
Challenges we ran into
We had to carefully code up the processing logic so that we were accurately determining if someone is approved or not. Inserting 10,000 entries into a database and making sure it was accurate was something that was also difficult at first. It was the same with making sure our calculations are correct for our charts and graphs that we display on our frontend.
Accomplishments that we're proud of
We're proud of our setup database with four different tables, two of which are additional information regarding zipcodes, counties, and property tax of which we had further ideas for implementation. We are also very proud of the graphs and charts that we have displayed on the frontend because they are all made from the processed data from our database.
What we learned
We learned the process of making a full stack application and how to potentially steer clear of issues. For example a greater emphasis on coding and testing the processing code would have helped us greatly with time.
What's next for HowToHouse
The next part would incorporating the two additional tables that we have stored in the database. We can provide further analysis based on the information we stored by user given location of which we can lookup in our tables. We would also have more charts and graph to display this information.
Log in or sign up for Devpost to join the conversation.