Made at HackRU (Rutgers Hackathon)
Cruber is a web application where people can help each other. For example, a person can send out an alert that they need their roof or car fixed. People around the client will be able to see the posting if their skillset matches the job. The "workers" are able to bid for the job and the client can accept the best offer.
- Client can post an alert through a form
- Workers can register an account with their skillset
- Workers can see all the available jobs on a map
All the information the client and workers post is saved using Amazon Web Services. Specifically, a MySQL database hosted on Amazon RDS. All the job postings are pulled from the database and shown on Google Maps using their API.
Cruber, at its heart, wants to relieve the stress that comes with trying to find an efficient and reliable contractor and bring the service to the client.
- CSS (Bootstrap)
- Google Maps API
- Amazon EC2 Server
- Amazon RDS (MySQL)
Install NodeJS and set up a MySQL database.
MySQL connection code under
- Database name: hackru
- Table name: workers
- Table columns: id, firstname, lastname, address, skills
CREATE DATABASE IF NOT EXISTS hackru; CREATE TABLE workers ( id INT NOT NULL AUTO_INCREMENT, firstname VARCHAR(20) NOT NULL, lastname VARCHAR(20) NOT NULL, address VARCHAR(255) NOT NULL, skills VARCHAR(500) NOT NULL, PRIMARY KEY(id) );
- Clone the respository
npm installto install all the dependencies
npm startto start the web application
- In your browser type