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
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".
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
password attributes of the constant
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
node app.js. Open a browser and go to
localhost:3000. You're set to start
playing with this neat little demo. :heart: