Oct 29: System Catalogs, Debugging

Learning Objectives

After today's class, you should be able to:

• Summarize what information is stored in the system catalogs.
• Explain how to use a debugger both server-side and client-side.

Lesson Outline

Mini Lecture [20 min]

• System Catalogs
• information_schema
  • MySQL
  • PostgreSQL

HW5 Preview [15 min]

profs repository – see webapp folder

• Can run with flask run --debug
• workshop_all.jinja: addListener()
• app.py: flash() and redirect()

Debugging [15 min]

• Server-side: press F5 in VS Code
  • Debugging in Visual Studio Code
• Client-side: press F12 in Chrome
  • Debug JavaScript | Chrome DevTools

Work Time [25 min]

• Create webapp folder in repo:
  • Copy .vscode/launch.json from profs
  • Copy app.py, db.py, and index.jinja
• Decide who will do which table on HW5
• Coordinate efforts to finish GP3

Your To-Do List

• Due Wednesday: GP3 via GitHub
• Due Thursday: PE1 via Canvas