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!

In the wake of posts about Shopify's support for white nationalists and DataCamp's attempts to cover up sexual harassment
I have had to disable comments on this blog. Please email me if you'd like to get in touch.