6. Dynamic Backends

Syllabus Points Covered

Programming for the web

Data transmission using the web

• Explore the applications of web programming

  • interactive website/webpages

• Investigate and describe the function of web protocols and their ports

  • HTTP

Designing web applications

• Model elements that form a web development system

  • client-side (front-end) web programming

  • server-side (back-end) web programming

  • interfacing with databases that are based on Structured Query Language (SQL) or non-SQL

• Observe and describe the back-end process used to manage a web request

  • libraries

  • databases

Chapter Contents

• 6.1. Case Study: Movie Reviews
  • 6.1.1. Download the Database
  • 6.1.2. Movies Database
  • 6.1.3. Reviews Table
• 6.2. Databases and Python Using SQLAlchemy
  • 6.2.1. SQLAlchemy
• 6.3. Databases with Flask
  • 6.3.1. Displaying Data from a Database
  • 6.3.2. Sort Results - Most Recent Reviews
  • 6.3.3. Sort and Limit Results - Top 10 Movies
• 6.4. Templating
  • 6.4.1. Jinja
  • 6.4.2. Jinja Syntax
  • 6.4.3. Templates in Flask
  • 6.4.4. Extending Templates
  • 6.4.5. Static Files in Templates
  • 6.4.6. Glossary
• 6.5. Variables in URLs
  • 6.5.1. Basic Example
  • 6.5.2. Review Page
  • 6.5.3. Complete Example
• 6.6. Forms - Part 1
  • 6.6.1. HTML Forms
  • 6.6.2. Form Inputs
  • 6.6.3. Forms over HTTP
  • 6.6.4. Query Strings
  • 6.6.5. Example Form
  • 6.6.6. Handling Query Strings
  • 6.6.7. Example: Filter Reviews
  • 6.6.8. Glossary
• 6.7. Forms - Part 2
  • 6.7.1. Form Example
  • 6.7.2. Handling Form Data
  • 6.7.3. Example: New Movie Review
  • 6.7.4. HTML Forms - Uploading Files
  • 6.7.5. Handling File Data
  • 6.7.6. Example: Image Uploads
• 6.8. Extension Exercises