mersenneforum.org  

Go Back   mersenneforum.org > Great Internet Mersenne Prime Search > PrimeNet

Reply
 
Thread Tools
Old 2020-07-22, 22:05   #1
ixfd64
Bemusing Prompter
 
ixfd64's Avatar
 
"Danny"
Dec 2002
California

2×19×61 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
Old 2020-07-23, 06:39   #2
xilman
Bamboozled!
 
xilman's Avatar
 
"𒉺𒌌𒇷𒆷𒀭"
May 2003
Down not across

1019410 Posts
Default

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.
xilman is online now   Reply With Quote
Old 2020-08-02, 04:45   #3
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

1100110011012 Posts
Default

Quote:
Originally Posted by xilman View Post
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.
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.
Madpoo is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to browse for files in manage attachments kriesel Forum Feedback 3 2019-06-01 18:56
Database for k-b-b's: 3.14159 Miscellaneous Math 325 2016-04-09 17:45
Database question Xyzzy Forum Feedback 0 2012-04-01 15:37
Using Screen to manage your clients/servers IronBits No Prime Left Behind 1 2008-07-13 17:00
database.zip HiddenWarrior Data 1 2004-03-29 03:53

All times are UTC. The time now is 19:23.

Thu Nov 26 19:23:15 UTC 2020 up 77 days, 16:34, 3 users, load averages: 1.34, 1.16, 1.22

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

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.