How sammykym/projectd works
This is a small Express bulletin-board app: visitors can view a rendered message list, retrieve messages through JSON endpoints, and submit a message. The route handlers in app.js query MySQL; the home route passes query results to an EJS template. The README contains only a video link, so the architecture is based on the sampled source; update and delete routes are shown as attempted operations, not confirmed working behavior.
Main entry points: app.js Express server and middleware · index.ejs Message list template · public Static public files
Components 12
Web runtime
- Express server and middleware
app.js - Static public files
public
Board routes
- Home page route
app.js - List messages API
app.js - Single message API
app.js - Create message route
app.js - Update route
app.js - Delete route
app.js
Data and views
- MySQL database
- Message board table
- Message list template
view/index.ejs
Other components
- Visitor
Connections 22
- Visitor → Express server and middleware: HTTP requests
- Express server and middleware → Home page route: routes requests
- Express server and middleware → List messages API: routes requests
- Express server and middleware → Single message API: routes requests
- Express server and middleware → Create message route: routes requests
- Express server and middleware → Update route: routes requests
- Express server and middleware → Delete route: routes requests
- Home page route → MySQL database: queries
- List messages API → MySQL database: queries
- Single message API → MySQL database: queries
- Create message route → MySQL database: inserts
- Update route → MySQL database: updates
- Delete route → MySQL database: deletes
- MySQL database → Message board table: reads and writes
- Home page route → Message list template: renders with results
- Message list template → Visitor: HTML response
- List messages API → Visitor: JSON response
- Single message API → Visitor: JSON response
- Create message route → Visitor: redirects home
- Update route → Visitor: text response
- Delete route → Visitor: text response
- Express server and middleware → Static public files: serves files