School of Code, Week 05

This week we learned the following:

• What the relational databases are,
• Basic SQL queries, such as SELECT, CREATE, DELETE, UPDATE
• Basic SQL operators such as JOIN, UNITE, WHERE, GROPUP BY, ORDER BY
• How to execute database operations via Express

---

This repository contains the following tasks

w5d5_hackathon-rest-api-josh-gabor

We built a REST API with Node.js, Express & PostgreSQL

Requirements

• Must use a database (hosted on heroku or elephantSQL) for persistent storage
• Must use a REST API server with routes to manage requests and serve responses
• Must use the models pattern to allow easy interaction with the database
• Must use environment variables to store database credentials - do not hard code those credentials!

---

w5_recap-task-Szfinx5

This is the weekend task whith the following requirements:

• Set up the Express server
• Configure the basic CRUD routes
• Create a Postgre database on Heroku
• Join the dayabase to the back end and make the API routes work