Express set-up
What is the first thing I should do in the command line after creating my directory and initial folders.
NPM init
what is the first line of code I should run in my server file when starting the database integration process
const pg = require pg
what does the P in PSQL mean
Postgres
app.patch
updates a certain data point in your database
This NC State and Wisconsin QB was drafted in the 4th round and won a superbowl in the 2010's
Russell Wilson
what is the first line of code that should go on my server file
const express = require express
what are the two file names we typically use for the data in our database
migration and seed
Query
a request for data or information from a database table
require fs
allows you to work with the filesystem in your computer
The last Defensive player to be drafted #1 Overall
Myles Garrett
How can I hide my node modules so they don't get pushed up
git ignore
ID should always say what after it.
SERIAL PRIMARY KEY
Route
part of the url that identifies a resource
app.use
used to mount the specific middleware function at the path you are specifying it to.
Name the last 3 QBs to win the Hesiman and be drafted 1st overall
Burrow, Murray, Mayfield
What line of code should I use to start my app having express
const app = express()
What typically follows first after the INSERT INTO command
the table name
API
Application programming interface
ORDER BY DESC
will order the data you are retrieving from top to bottom. IE ORDER BY age DESC. The oldest ages would be first
This defensive player was the first of two DE's to be taken first overall in the 2010's
Jadeveon Clowney
How do I get my app to listen to a port
app.listen
what is the first step in actually getting the database to communicate with my app
setting up pool so we can make queries
Postgres is what kind of database?
Relational
res.statusCode
sets the HTTP status for the response
This was the only offense lineman to be taken 1st overall in the 2010's