postgress-database

Question 1

What is a database schema?

Answer 1

a schema describes the rules for how a table can be stored. it is actually the structure of the database

Question 2

What is a table?

Answer 2

table is a collection of rows, every row has the same attributes

Question 3

What is a row?

Answer 3

a collection of attributes for a single record in a table

Question 4

qna: what is full stack

Answer 4

full stack (real engineers call it 3 tier architecture)
- client, server, database

• loading from your api
• client (ex httpie) sends an http request to server (ex node/express)
  -the server recieves a request and runs a function
• that server function may send a query to a database (ex postgresSQL)
• the database replies to the server with a “result”
• the server then sends an HTTP response back to the client with data from “result”
• client -> req -> server -> query -> database -> result -> server -> response -> client