Monday

Objectives

• Familiarize ourselves with the basics of SQL persistence
• Learn the DBAPI specification and how to interact directly with databases using it
• Gain an understanding of the purpose and usage of an Object-Relational Mapper
• Generate the basic structure for our learning journal project
• Understand the structure and uses of the Deque data structure

Readings

These readings will support the work you do on Tuesday:

• The SQLAlchemy ORM Tutorial (Read up to and including the section on querying)
• Command-Line Pyramid: The Interactive Shell

Review

Concepts

• SQL Persistence in Python
  • Interacting With the Database
  • Handling Errors with Rollback
  • Wrap-Up
• Deque
  • Motivation
  • Definition
  • Attributes
  • Operations

Demo

Interfacing with a database using the SQLAlchemy ORM

Assignments

(due Monday morning):

• Introduction to SQL
• Acquire a Heroku Account

(Work on Monday):

• Implement a Deque in Python
• Algorithm Analysis
• Group Project: Pitch Ideas
• Today I learned...
• Python Learning Journal: HTML Mockup (due Thursday)
• Technical Blog Post: Outline a Post (due Friday)