Can SQLAlchemy update the table structure?

Question

I am working on my first pylons + SQLAlchemy app (I'm new to both).

As I change my mind on the table structure, I wish there was a similar function to metadata.create_all(), that checks if there are new columns definitions and create them in the database.

Does such a function exist ?

Answer 1

I'm not (yet) a SQLAlchemy user, but I've heard good things about sqlalchemy-migrate. The general term of the problem you have is "schema migration", I'm sure a google search containing these terms will help you further.