View Single Post
Old 2020-07-22, 22:05   #1
ixfd64
Bemusing Prompter
 
ixfd64's Avatar
 
"Danny"
Dec 2002
California

2,351 Posts
Default there needs to be a better way to manage the database

It's my understanding that there is currently no efficient way to modify submitted results. George has mentioned that such changes require "hand crafted SQL statements applied to the database." Because manual database queries are very risky and generally a hassle, they are not usually done except to fix missing tests or remove fake results from the server.

However, I think it would be very useful if there was an interface for modifying results. This would allow project admins (and maybe trusted users) to easily perform maintenance, such as removing duplicate results or re-attributing "anonymous" assignments to users who forgot to log in. The feature only needs to be implemented once, after which it would no longer be necessary to manually edit the database. Thoughts?
ixfd64 is online now   Reply With Quote