Git Product home page Git Product logo

app-tracker's Introduction

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

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.