Git Product home page Git Product logo

app-tracker's Introduction

demo.mov

Setting up Job tracker

This project was bootstrapped with Create React App.

Install PostgreSQL and clone project

Setting up frontend

Navigate into project and run:
npm install

To start app, run:
npm start

Setting up backend

To connect database, make a file in your server folder that contains your DB properties:
Ex. jobs_db.js

Apply the following properties with your DB info to the file:

	const Pool = require("pg").Pool;
	const pool = new Pool({
		user: "{username}",
		password: "{password}",
		host: "localhost",
		port: 5432,
		database: "{name_given_to_db}"
	});

	module.exports = pool;

Navigate into server folder and run:
npm install OR npm init and step through default options

Install Express, PG and CORS:
npm i express pg cors

Install nodemon globally to automatically refresh server when there are changes to database:
npm install -g nodemon

server/index.js contains server info and database calls.

To start server, open a separate terminal and run:
nodemon index

Setting up PostgreSQL

Create and set database name and password

Create table and run following script:

CREATE TABLE companies (
    id integer NOT NULL UNIQUE,
    company_name varchar(50),
    job_role varchar(50),
    date_applied date,
    app_status varchar(50)
);

Verify calls on Postman


Send tacos if this app is helping

alt_text alt_text

app-tracker's People

Contributors

oscar6 avatar

Stargazers

Eduardorandom avatar Husam Alshehadat avatar vil avatar Alexander Soares de Oliveira Sucena avatar Prakhar Garg avatar Mike R. avatar Viktor avatar Pranav Sriram  avatar Bhanuteja Chintha avatar  avatar Tomer Shvueli avatar Cornell Benson avatar Ish avatar Hasnian avatar Serdar avatar Bishal Giri avatar Drew Hinderhofer avatar  avatar Eduardo Jose Flores III avatar  avatar

Watchers

 avatar Kostas Georgiou avatar arianna banks avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.