Setting the _URI column unique in MariaDB

(Hartmut Noack) #1

In order to allow people to correct typoes and the like using PHPMyAdmin, I would like to have a unique column in certain collected tables. What column would you recommend? I guess the _URI column should be the best for it seems to be de facto unique already...

recent Version of Aggregate under recent Debian stable Linux storing to MariaDB

Why do you choose not to set a column to unique in the first place? Is there a option in Aggregate to choose that behaviour by default?

(Yaw Anokwa) #2

Letting people change the data in the database is likely going to result in a corrupt database. For example, how will you guarantee that your users will only type in accepted values into a select_multiple question?

My recommendation is that you build an application layer on top that does some minimum constraints checking or you dump the data out into another data store where you can at least track the changes.