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!
Why wouldn't a simple spreadsheet and some pivot tables work?
The data is relational. Spreadsheets are a pain to use for that.
Never use a spreadsheet to do a database job.
Tracking a single cat doesn't seem like DB work
But it's not just the cat. OP wants to track the foods the cat is eating and the allergens in the food, and then look for correlations and trends. You could manage most of that with a spreadsheet, but you'd have to update reference tables every time you add a new entry. OP wants something user friendly.
Sure, but how many foods are we talking here? This sounds like probably <20 rows on a sheet, with columns for ingredients.
Looking to replicate something like this (with a weekly/monthly/ect views, maybe monthly view can look different since it would be too long to scroll, but anyway, it looks like arse but was just giving it a go), but didn't want to have to create a full webapp (with CRUD data inserts, pagination ect... its certainly doable, but just annoying to implement). This is just a simple index view in a random framework I found, with some real, but pre-canned data via db seeding (so at least I can re-create it easily). Just thought there could be something easier that already exists and i wouldn't have to be re-inventing the wheel. Have a paper version of this, but its too hard to keep track of different foods via paper.
Spreadsheet sounds interesting (read easier) to try, though I am not quite sure how to do the lookup bits. Would it be something like one table (sheet) of events feeding from say, food type table (sheet) and some kind of a month view that can accumulate events on the same day?
PS: yes got a vet appointment coming up soon.
I'm not sure about libre office, but Excel has lookup and lookup. I've not personally used those. But might be of help.