Was Milestone 1

Web client

Login page

• No need for Milestone 1: web server uses a fixed DB user
• There may be no separate login page, if we decide to develop a single-page application

Home page

• Accept SQL query
• Submit SQL query
  • Use POST (not GET)
  • Obviously use AJAJ
• Display brief status: "Running...", "Completed successfully", "Query timed out", "Error"
  • Would be nice to show number of result rows
  • Place the status just above the result table
• If query ran, display returned rows in a table: no pagination needed; result could have zero rows
• If query failed, display the error detail in a separate text area
  • Show either the result table or the error detail; not both: might need to revise this scheme after some trials

Web server

Serve home page

• Serve "home page" directly from a file: browser displays the page as is

Perform query

• Extract query
• Create a session-specific DB connection and reuse connection
  • Use fixed DB parameters: server, database, user
• Return at least three components: status, result, error; need to revise based on DB module's capability