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?

Also see http://stackoverflow.com/questions/575172/portable-non-relational-database — S.Lott, Feb 24 '09 at 00:29

score 16 · Accepted Answer · answered Feb 23 '09 at 23:05

16

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

answered Feb 23 '09 at 23:05

zweiterlinde

And you can migrate to another DBMS easily. – Matthew Schinckel Feb 23 '09 at 23:19

score 2 · Answer 2 · answered Feb 24 '09 at 02:18

2

SQLAlchemy, when used with the sqlalchemy-migrate library.

answered Feb 24 '09 at 02:18

Nikhil

2 Answers2