CS 304 Slideshow

This slideshow gives a kind of high-level idea of what CS 304 is about.

The calm before the storm
The calm before the storm...
user clicks a button, submitting a form
user clicks on a button, submitting a request to Apache

Apache gets it and hands it off to our code
Apache gets it and hands it off to our code
our code sents SQL code to MySQL to get or modify data
Our Python/Flask code sends SQL code to the MySQL DBMS to get or modify data
MySQL returns results to our code, often a table of data
MySQL returns results to our code, often a table of data.
Our code uses the data as it pleases and gives a response to Apache
Our code uses the data as it pleases and gives a response to Apache, in the form of a web page, probably dynamically constructed out of templates and the data from the database.
Apache hands the response, which is HTML, CSS and JavaScript to the browser
Apache sends the response (HTML, CSS and JavaScript) to the browser
And the round trip is complete
And the round trip is complete.
In another situation, the browser might submit to a Flask 
      development server.
The browser sends the request to a Flask development server, running on a different port.
Flask includes some code that you write to handle 
      different <em>routes</em> (urls)
Flask includes some code that you write to handle different routes (urls)
Your handler can connect to MySQL, sending it some SQL code
Your handler can connect to MySQL, sending it some SQL code
Again, the DBMS replies with a table of data
Again, the DBMS replies with a table of data
The flask application replies to the browser
The flask application replies to the browser