How saurabh-bhargav/3-tier-nodejs-mysql-main works
This is a React/Express user-management app backed by MySQL. The intended workflow is to view users and add, edit, or delete them through a browser UI and API. The sampled code shows two overlapping implementations: App.js fetches and adds directly, while UsersList uses an API client and UserItem for deletion; the controller-based routes support listing, adding, and deleting. A separate server.js implements direct SQL routes, and server/routes/users.js contains update support. The README documents editing, but the sampled UI edit buttons are placeholders. These parallel paths are shown without assuming they are wired together.
Main entry points: App.js Main app · UsersList.js Users list · server.js Standalone server · db.js DB connection
Components 14
Browser UI
- Main app
client/src/App.js - App styling
client/src/App.css - Users list
client/src/components/UsersList.js - User item
client/src/components/UserItem.js
Client API
- User API client
client/src/api/users.js
Express backend
- Express app
server/app.js - User routes
server/routes/userRoutes.js - User controller
server/controllers/userController.js - Direct SQL routes
server/routes/users.js - Standalone server
server/server.js
Persistence
- User model
server/models/userModel.js - DB connection
server/config/db.js
Other components
- User
- MySQL
Connections 14
- User → Main app: uses
README.md - Main app → App styling: imports
client/src/App.js - Main app → Standalone server: requests users
client/src/App.js - User → Users list: views users
README.md - Users list → User API client: calls
client/src/components/UsersList.js - Users list → User item: renders
client/src/components/UsersList.js - User API client → Standalone server: requests users
client/src/api/users.js - Express app → User routes: mounts
server/app.js - User routes → User controller: dispatches
server/routes/userRoutes.js - User controller → User model: calls
server/controllers/userController.js - User model → DB connection: queries
server/models/userModel.js - DB connection → MySQL: connects
server/config/db.js - Direct SQL routes → DB connection: queries
server/routes/users.js - Standalone server → MySQL: queries
server/server.js