How muhammmadrizo/backendwithsql works
This is a small Express API for CRUD operations on users, teachers, students, and courses. An HTTP client sends requests to the server, which mounts resource routers; each router dispatches to its controller, and controllers query PostgreSQL through a shared pool. The source excerpts establish the route and database relationships. The README is empty, and the SQL schema was not sampled, so schema details and additional capabilities are not represented.
Main entry points: server.js Express server · db.js PostgreSQL pool · users.js User routes · teachers.js Teacher routes
Components 12
HTTP API
- Express server
src/server.js - User routes
src/routers/users.js - Teacher routes
src/routers/teachers.js - Student routes
src/routers/students.js - Course routes
src/routers/courses.js
Resource Operations
- User operations
src/controllers/users.js - Teacher operations
src/controllers/teachers.js - Student operations
src/controllers/students.js - Course operations
src/controllers/courses.js
Persistence
- PostgreSQL pool
src/config/db.js - PostgreSQL database
Other components
- HTTP client
Connections 14
- HTTP client → Express server: sends requests
- Express server → User routes: mounts
src/server.js - Express server → Teacher routes: mounts
src/server.js - Express server → Student routes: mounts
src/server.js - Express server → Course routes: mounts
src/server.js - User routes → User operations: dispatches
src/routers/users.js - Teacher routes → Teacher operations: dispatches
src/routers/teachers.js - Student routes → Student operations: dispatches
src/routers/students.js - Course routes → Course operations: dispatches
src/routers/courses.js - User operations → PostgreSQL pool: queries
src/controllers/users.js - Teacher operations → PostgreSQL pool: queries
src/controllers/teachers.js - Student operations → PostgreSQL pool: queries
src/controllers/students.js - Course operations → PostgreSQL pool: queries
src/controllers/courses.js - PostgreSQL pool → PostgreSQL database: connects to
src/config/db.js