A CRUD Demo using React JS + Express with a SQL DB

A simple demo of of create, read, update, delete operations.

Frontend

React Js for rendering
Next JS for SSR and boilerplating
Bootstrap for basic styling
State-Reducer Pattern for State-management
Tests using Jest (incomplete)

Backend

Express for api
Prisma for SQL ORM

Setup

Includes docker-compose.yml file for dev environment
Postgres OR Sqlite can be used (shipped with Sqlite, Sample configs for Postgres given)
Run docker-compose up --build
Project will auto build, setup db, migrate, seed, and build all frontend resources
Open http://localhost:3000/ in browser
This is a DEV docker-compose file not suitable for deployment, everytime backend is built using docker, it will reset the db, uncomment the line RUN npx prisma migrate reset --force in backend/Dockerfile to disable this behaviour.

Utils

Script for migrating from json to db is in path backend/prisma/seed.ts (reads from data.json to seed)
Run inside backend npx prisma db seed to (re)seed db
Tests for the frontend can be run using npm run test in frontend directory
The project can be run without docker, npm run dev command has be run for both frontend and backend.