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!

  • 𝕸𝖔𝖘𝖘@infosec.pubEnglish
    281·
    21 days ago

    Personally, I would use a simple spreadsheet for this.

    But if you have your heart set on a db, you can use Access or LibreOffice Base for ease of initial setup.

    Maybe SQL (or PRQL, if you’re feeling cutting edge) with some dbms (SSMS Community I think is still free, or maybe Heidi SQL) but this will require you maintain a server as well. PostgreSQL is what I generally use if I want to spin up something quickly. I do like SQL quite a bit, but it seems overkill for this task.

    Edit: autocorrect

    • atzanteol@sh.itjust.worksEnglish
      11·
      21 days ago

      LibreOffice Base seems like a good idea for something like this. SQL based with a UI to create forms, reports, etc.

      It’s probably one of the few times it would be an appropriate tool to use!