The database schema needs to be declared somehow

[matt-bernhardt]

I'm not sure of the best way to store this, but the database schema assumed by the rest of the platform needs to be documented somehow. This could be a set of SQL scripts describing the table setup, or something else.

[matt-bernhardt]

So far I've added table definitions to the fixtures directory to facilitate testing, but this is very different than what's needed for initial setup.

[matt-bernhardt]

Two links of note for this...

Setup scripts in Python2:
https://docs.python.org/2/distutils/setupscript.html

Migrations in distcontrib:
http://distcontrib-migrate.readthedocs.org/en/latest/

It may be that this question is one that will push me to adopt SQLAlchemy, because the maintenance of database schema is probably more than I want to tackle. OTOH, I'm concerned about how much the schema would end up changing if I turn over table design to an external package.