Python ORM that auto-generates/updates tables and uses SQLite?

Question

I am doing some prototyping for a new desktop app i am writing in Python, and i want to use SQLite and an ORM to store data.

My question is, are there any ORM libraries that support auto-generating/updating the database schema and work with SQLite?

Answer 1

SQLAlchemy is a great choice in the Python ORM space that supports SQLite.

Answer 2

SQLAlchemy, when used with the sqlalchemy-migrate library.

Answer 3

For a related approach, take a look at the y_serial Python module for schemaless data persistance: http://yserial.sourceforge.net

Hope this helps your project... it should be simple enough to implement in 10 minutes.