5

Would it be possible (from the technical viewpoint) adding creation date to the Database Schema of SEDE.1 (Or maybe even id of the user who created the tag or id of the question where it was created.)

I do not know much about databases and SQL, so I have no idea whether this would be technically possible. I would imagine that it is virtually impossible to fill this in for already existing entries, should the database scheme be changed. (I hope you will pardon my ignorance and someone more knowledgeable or someone from SE staff will be kind enough to explain the technical problems with this suggestion, if there are any.)

But if such change is possible, I think it would be useful. I have seen several questions asking how to find out when or by whom a particular tag was created. For example (ordered by id):

If I do not miss something when reading those questions (going through all of the linked questions seems to be virtually impossible because of the sheer amount of them), I see basically the following possibilities:

  • Find the oldest question in the given tag. (Which does not always yield a correct result. The tag might have been added to an older questions which was deleted or retagged. Or the tag might have been actually created in a newer question and only later added to the older one.)
  • Check whether Taxonomist badge was awarded for this tag. (This only works if the tag has at least 50 questions. And IIRC this tag can only be awarded once, so it won't work if the tag creator already had this badge for another tag.)
  • One more thing I try in such situations is checking the revision history of tag-wiki and tag-excerpt. At least on some occasions the user, who creates the tag, also creates the tag-wiki.

1 Database schema is shown on the right when you click on compose query. I do not know a better link to it. It is also shown here: Database schema documentation for the public data dump and SEDE with more detailed explanations of some fields.

  • 1
    You could also ask for the identity of creating user to be recorded, while you are at it... – user259867 Nov 30 '14 at 8:02
  • I've suggested in the post: Or maybe even id of the user who created the tag or id of the question where it was created. – Martin Nov 30 '14 at 8:44
  • Jeff Atwood's answer to a related feature request (to show me the list of tags created by me, this is status-declined) says that this would probably cause that some users would be gaming the system to get taxonomist badge. – Martin Mar 2 '15 at 7:44

You must log in to answer this question.

Browse other questions tagged .