[sqlalchemy] commit() okay on every web request ?

Switched to autocommit=False, and calling commit(), followed by remove() on every end-of-request, regardless of whether there's data to commit or not. Am I adding any unnecessary overhead ? And if so, how should I be checking for dirtyness prior to committing ? R -- You received this message

[sqlalchemy] VARCHAR requires a length when rendered on MySQL

I'm switching to MySQL from SQLite in my Pylons app and I get this error during setup-app: sqlalchemy.exc.InvalidRequestError: VARCHAR requires a length when rendered on MySQL I noticed some tables had simply Unicode without length but also adding length to all Unicode columns the error keeps

[sqlalchemy] Re: VARCHAR requires a length when rendered on MySQL

Please ignore this issue, searched for all Unicode but forgot I also used a String for a column... It works flawlessly, I apologize. On Feb 21, 12:40 pm, neurino neur...@gmail.com wrote: I'm switching to MySQL from SQLite in my Pylons app and I get this error during setup-app: