My SQLAlchemy tutorial proposal was also accepted. (Tutorials are three hours long and take place the day before PyCon proper.) The full list of tutorials is here: http://us.pycon.org/TX2007/Tutorials
Here was my proposed outline. (Suggestions welcome before I put this up on the public wiki. :) Part 1: advanced database concepts ================================== Subqueries ---------- - scalar - in FROM Functions --------- - One query is almost always better than multiple - parse overhead - driver and/or network overhead - pl/pgsql - pl/pythonu Triggers -------- - Performance - Single point of maintenance - Declarative vs procedural - per-statement vs per-row Part 2: mapping with SQLAlchemy =============================== Introduction ------------ - Data Mapper pattern vs Active Record - Reusable constructs vs collections of special cases Data constructs --------------- - Constraints - FKs - ON UPDATE, ON DELETE - How SA plays nicely with in-db defaults and triggers Queries ------- - Joins - Aliasing Mapping to Python classes ------------------------- - one to many, many to many - backreferences - cascade options - inheritance Advanced mapping & optimization ------------------------------- - logging query duration with a proxy Engine - lazy / eager loading - identity map is not a cache - mapping function calls and subqueries -- Jonathan Ellis http://spyced.blogspot.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
