mersenneforum.org - View Single Post - there needs to be a better way to manage the database

ixfd64 · 2020-07-22, 22:05

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?

2020-07-22, 22:05	#1
ixfd64 Bemusing Prompter "Danny" Dec 2002 California 2²×3×197 Posts	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?