Backend Learning Tracker

SQL & API

Express + PostgreSQL project. Fetching real data from API endpoints

API Routes

Get /players-scores

Get /top-players

Get /inactive-players

Get /popular-genres

Get /recent-players

PostgreSQL

Packages

Express, pg, dotenv, zod

dev: nodemon, typescript, ts-node, @types/express, @types/node

DB: PostgreSQL

Setup Environment

Zod Validate

ESLint configure

Parse and Validate

Init PostgreSQL Connection

SQL & API

Webshop with Prisma, Express, and React

API Routes

Post /products

Get /products

Patch /products/:id

Delete /products/:id

Relationship

Create Project

Initialize Prisma

Configure DB

Prisma Schema

Migrate & Generate

Apply the Database Schema

schema.prisma

1. Migrate the database to create tables based on the Prisma schema.

2. Generate the Prisma Client to interact with the database.

3. Create a seed.ts file to populate initial data.

4. Update package.json to include the seed script.

          "scripts": {
            "dev": "nodemon server.ts"
          },
          "prisma": {
            "seed": "ts-node prisma/seed.ts"
          }

5. Run the seed script to insert sample data into the database.

              npx prisma db push

Packages

Express, Prisma

dev: nodemon, typescript, ts-node, @types/express, @types/node, @prisma/client

DB: Prisma postgres

Learning Tracker

Query Practice

SQL & API

API Routes

PostgreSQL

Packages

Setup Environment

Zod Validate

ESLint configure

Parse and Validate

Init PostgreSQL Connection

Prisma Webshop

SQL & API

API Routes

Relationship

Create Project

Initialize Prisma

Configure DB

Prisma Schema

Migrate & Generate

Packages