grocery-list-back-end.md

Mini Apps Review - Back End (Node/Express/MySQL)

Objectives

• Review React front-end
• Create a basic express server
  • Serve front-end
  • Use middleware
• Create a MySQL database
  • Practice creating ERDs (Entity Relationship Diagrams)
  • Practice writing schema
  • Practice writing seed data
  • Establish connection from server to DB
• Create GET and POST routes for data persistence
  • Discuss models & controllers
  • Test with postman
• Connect Front-end & Back-end!
  • Make AJAX requests to server
  • Modify front-end to use promises

Resources

• Serving static files in Express
  • Express 4.x - API Reference: express.static()
• Using Express middleware
  • Express 4.x - API Reference: express.json()
• Additional Express Documentation:
  • Express 4.x - API Reference: req.body()
  • Express 4.x - API Reference: res.status()
  • Express 4.x - API Reference: res.json()
• SQL Query Practice (Highly Recommended):
  • SQLZOO (highly recommended SQL query practice)
• mysql - npm Collapse