I need to record information about what my cat eats and does, as she might have a food allergy and I need to track down what it is.
So I am after some kind of a user friendly locally hosted database (maybe via some kind of app), preferably Linux friendly.
It would be nice if it had similar relationships to the added image, some kind of relational DB that I can fill with data. But essentially I need to have a bunch of lookup tables to return some data specific to difference events.
Its a bit of a pain (and takes time) to have to write an entire webapp to manage all this from scratch, that's why I am looking for some kind of user friendly GUI way to do it. Surely there must be some kind of relational database managing "application" that lets you set up some lookup tables and enter data in a nice and easy GUI way to do it? sqllitebrowser doesn't count as it doesn't handle linked tables in a nice way (would be nice if its friendly for my wife to use) :)
Cheers!
Thank you for the suggestions, I tried a bunch and nothing immediately fit. Most were either too complicated for me to create the relationships or I couldn't get the thing locally running (or there wasn't a self hosted option)... Basically stupid user syndrome 😑 😤.
So went back to the drawing board of writing a webapp and after a few experiments realised that... All I needed was a calendar with pre-canned event titles, groups for colour to highlight different events... silly me, all I needed was a calendar...
Ended up re-inventing something looking very much like a calendar... sigh... do I carry on or look for some kind of lightweight calendar :/ Just need to have ability to quickly create pre-canned events, would be nice if the events could be related...
On the other hand, its kinda fun to re-invent a calendar haha!
Here is a colour version... totally a calendar 🤣