We converted the existing database schema for Django, including adding numeric ID columns where we had multiple column keys. Django is helpful in that you instantly get maintenance pages for the tables, for adding/changing/deleting records. We’d also like to see joins and ‘maintain’ the data from that view, without having to go find the individual row in its own table.
There were frustrations with Django, as I’m sure one would have with any new platform. There is a “book” online, but several of the examples didn’t work and when looking online for help, it was hard to find the answers. Django doesn’t seem to help much with reporting. Our reports need multi table joins and summaries,
I was excited to read about SQLAlchemy and how it handles a lot of fancy database ideas we’d want. Not available in Django, and only sort-of available in Turbogears. Pylons does support it. Pylons of course is less mature than the other two so no doubt we’ll run into issues, but now ready to try it out.
