New project: tzaware_datetime
I added a new project to my site: tzaware_datetime.
For developers using sqlalchemy, it uses a Composite column to store a datetime in any timezone so that the dates are sorted by UTC, and the original datetimestamp is preserved. In other words, it round-trips datetime values without losing the timezone offset.
Details, example code, files and license available on the tzaware_datetime project page.