I am a historian whose specialty is too recent to deal with anything like that (20th century), but also have a friend who, to be generic here, deals with a handful of a few centuries back. She found a baggie of a drug mistakenly stored with a letter in an archive (think 18th century) and on a whim, dipped their pinky into the powder and tried it. They regret that decision, but also, nothing happened:)
EDIT: Historians can be boring, but not always that tame
I was looking for something similar for a while, like something for simple relational data with some GUI for data entry, aka “I don’t wanna write a little web app just for this”. I had used AirTable at work before at work so that’s what came to mind and my searching was basically for “open source or selfhosted alternative to AirTable”.
Came across some decent candidates, can’t remember all the names, but the one I tried, Grist, was pretty straightforward and did the job: easy relational data setup, GUI for all basic data types including file uploads, easy to create input forms, and widgets that talk to the API and you can customize with JavaScript. Setup was easy with docker
EDIT: other names that came up when looking were NocoDB and BaseRow ( I don’t remember why I didn’t try them for my specific needs)