Describe the solution you would like
When a user adds a scan to the library, this is not added to the database. The application should read the metadata and ask the user if it should update the database with the metadata.
Describe alternatives you have considered
We don't want to give the user raw database access, so it should be done via the application.
Additional context
The main concern is security. What if the user inputs something malicious which the application runs? We need to guard against SQL injections. We also don't want the user to accidently remove data from the database, so we need to make sure what is happening with data is communicated clearly to the user.
Additionally, it might be worth considering if we should add an admin screen for arbitrary editing of the database.
Describe the solution you would like When a user adds a scan to the library, this is not added to the database. The application should read the metadata and ask the user if it should update the database with the metadata.
Describe alternatives you have considered We don't want to give the user raw database access, so it should be done via the application.
Additional context The main concern is security. What if the user inputs something malicious which the application runs? We need to guard against SQL injections. We also don't want the user to accidently remove data from the database, so we need to make sure what is happening with data is communicated clearly to the user.
Additionally, it might be worth considering if we should add an admin screen for arbitrary editing of the database.