mersenneforum.org

mersenneforum.org (https://www.mersenneforum.org/index.php)
-   PrimeNet (https://www.mersenneforum.org/forumdisplay.php?f=11)
-   -   there needs to be a better way to manage the database (https://www.mersenneforum.org/showthread.php?t=25763)

ixfd64 2020-07-22 22:05

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 [url=https://mersenneforum.org/showpost.php?p=537920&postcount=1786]mentioned[/url] 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 [url=https://mersenneforum.org/showthread.php?t=24103]remove fake results[/url] 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?

xilman 2020-07-23 06:39

One thought is that there should be a clone of the database on which one could practice long before anyone is allowed to touch the main one.

I would hope that such a clone already exists. It´s standard practice for non-trivial applications.

Madpoo 2020-08-02 04:45

[QUOTE=xilman;551343]One thought is that there should be a clone of the database on which one could practice long before anyone is allowed to touch the main one.

I would hope that such a clone already exists. It´s standard practice for non-trivial applications.[/QUOTE]

If needed, DB changes could be rolled back. However it would involve taking the Primenet server offline so we could restore from the previous full backup and all of the incrementals until we got whatever we needed.

It's just easier to be careful. For big things, there's a clone server we can use if we want, but testing is more difficult. So it's just a balance of things.

The ability for end users to change the results they've submitted is not likely to ever happen. The potential for abuse, or just people changing things they really shouldn't, isn't worth it.

Submit what the program generates and you should be fine. :smile:


All times are UTC. The time now is 20:41.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.