I am also looking for a west-coast volunteer to help me organize something in the San Fran/Los Angeles area.  If anyone has an appropriate venue and a place for me to stay I would be happy to come out and give a tutorial.

Other tentative places for tutorials are: Ann Arbor, MI, and Washington DC or Baltimore, MD.  If anyone has a user group in these locations and would like to help organize, I would be appreciative of the support.  I would also not mind running the tutorial coupled with a sprint in a more exotic location like Crested Butte, CO.  There is an inexpensive hostel there with free wifi, some great skiing/mountain biking/hiking to be had.

Here is a rough itinerary:

Relational Database Applications with TurboGears
———————————————————————-
This tutorial is intended to be an un-tutorial. The idea is simple.  Bring me a public database, (or 4) and share with the class as we explore  the new admin-level RESTful features that TurboGears2 employs.

At the end of the class, the goal is for everyone to have a working TG2 application, with a working admin, at least one customized form or table, based on a database they, or another student brought to class.

I will ask the students to do some prep-work. For those who would like to
share a database, or a database schema, they should bring with them a database dump, be it a sqlite file on a memory stick, or a pgdump file, or a mysqldump file. If the students would like to share with the class, that’d be the best way to run the tutorial, and if people provide me with dumps of reasonable sizes ahead of time, I will distribute them with the class material.

We will then split up into teams of people working on similar database systems.

Intro Talk
++++++++++
A 10 minute talk to introduce myself and describe what SA and TG2  aim to do for relational databases. I will also discuss goals for the tutorial.

Part I
++++++++
The goal of part one is to break the ice with everyone, getting them into groups  and getting the first database interactions happening.

* Student Database descriptions (10 mins)
* Splitting into groups (5 mins)
* Copying/Loading databases all around (10 mins)
* Install SQLAlchemy and SQLAutocode (5 mins)
* Run sqlautocode on your loaded database. (30 mins)

We will discuss the different options sqlautocode provides,  and take a look at the output it produces.
* Set up TG2 and Quickstart a new App. (20 mins)

Part II
++++++++
The goal of part 2 is to integrate the work done in Part I and  explore the ways we can put the turbogears admin and sprox to good use.

* Integrate sqlautocode with the quickstarted TG app. (10 mins)
* Fire up the admin, see how it works with the existing schema. (5 mins)
* Modify the TG code to replace the default TG AdminConfig with A customizable one. (10 mins)
* See where the class would like to customize their admin, following necessary parts of:
http://turbogears.org…
http://www.sprox.org/…
http://www.sprox.org/…
as needed (60 minutes)

Bonus
+++++++
If we need extra filler at the end (not likely), or, if people want to meet after the afternoon session, I will have a mini-tutorial for BootAlchemy. BootAlchemy allows people to load Yaml files directly into a relational database.

Requirements
+++++++++++++

* Laptop with Python 2.5 or 2.6 installed.
* Database system of your choice (Postgres, Sqlite, MySQL)
* Python drivers for your desired database system installed. (psychopg2, pg8000, pysqlite, mysql-python)

cheers.

-chris