Back to School: Two new lessons

For most of you in the "upper half," summer is ending, and the tides of a new school year are marching in, no matter how much the kids are kicking and screaming. In light of that transition, we've been back in the studio recording new lessons and have released two new lessons, that we hope you'll enjoy. The lessons cover interesting topics on their own and can be viewed as a larger topic together.

Lesson 19: Creating Filtered Views

In this lesson, we cover a common paradigm on the web -- a sidebar that contains filters for a given list of items. We see this often in blogs and catalogues. While we have already covered filtering lists using a search form, this lesson focuses on creating custom URLs for each filtered version of the list, for instance /category/real-estate

Lesson 20: Beyond the ORM -- Building Custom SQL

A continuation of the previous lesson, we light up the date archive filters in this lesson, allowing users to browse by month, and year. This involves some custom database querying that pushes the boundaries of what is practical in the ORM, so we introduce the SQLQuery class, which affords us an API for building custom SQL.

Happy learning, and welcome back!