[Tools-discuss] Advice on DT schema changes

["Salz, Rich" <[e-mail]>]

I want to add a uniform and extensible way of attaching “external references” to DT objects: groups, people, documents. For example, I’d like us to be able to say “this is the GitHub repository for this draft,” “my GitLab username is rsalz,” and “the homepage for this WG is https:…..”

I’m attaching two files that I’d like some comments on.   The ext-schema.sql file is a SQL script that shows the tables I am thinking of adding.  The data-changes.py file is a combination of python and pseudo-code that shows how I’d migrate the database. Is this the best place to ask?

Now, I know that this isn’t the way we’d really do things. Instead I’d write Django models, update the view scripts, and a command-line tool to do the migration. But before I dig into that (and learn enough Django so that I can :) I’d like comments – think of them as the high-level design work, for example.

One of my motivations for this (BTW, my first notes on this are on letterhead from the Bangkok hotel :), is so that I can enhance my GitHub scripts, https://github.com/richsalz/ietf-gh-scripts, to automatically pull/push data between GH and DT.

Thanks for any feedback.
                /r$