The Third Bit

Schema Changes

A while back, I posted a handmade picture of DrProject’s database schema. Thanks to DB Visualizer, we now have pictures of the 1.2 database schema, and the new-and-improved schema that works with SQLAlchemy and Elixir. Alex and DW are starting work on a migration tool to translate from the latter to the former; those of you who have done this before will want to wish them good luck . According to Alex:

What’s really cool about this diagram is that it shows a topological
ordering of the graph of foreign keys, so if we migrate the rightmost
tables first, we shouldn’t run into any foreign key constraint
violation problems!