Team Homefront


Think Metacritic/Rotten Tomatoes, but for home safety.

What it does

Homefront allows tenants of a home to submit information about said home and compare them against local safety regulations.

How we built it

We created a database in MySQL and a frontend to interact with it via Node.js/Express.js

Challenges we ran into

Two backslashes.

Accomplishments that we're proud of

This is our first time using Express.js, EJS, or Node.js to interact with MySQL. It's also the first time we've used databases this extensively

What's next for Homefront

Ability to view history of a home, loading data from official sources, and Google Maps integration, among other ideas.

Documentation (see our repo)


Homefront is a data aggregator for housing information for houses, apartments, and even dorms. The goal was to provide a nice web-based frontend for a service that allows for past residents to enter information about their experience with a living space they rented out in the past and for potential occupants to get a good idea of how safe the house is (along with other details) based on a "safety index".

Getting Started

To get started with this demo, you must have an installation of Node.js and you must have installed the MySQL plugin through npm.

Setting up the database

Install a MySQL server. MySQL Community Server will work fine. Import the .sql into your server using MySQL Workbench. Create a user for your MySQL server and give them complete access to this database.

Prepping the JS

Change the user and password attributes of the constant db within Application/Site/app.js

Running and using the demo

Open PowerShell if you are on Windows, Terminal if on MacOS, or a new shell environment if on Unix or Linux. Change the working directory to Application/Site. Run node app.js. Open a browser and go to localhost:3000. You're set to start playing with this neat little demo. :heart:

Share this project: