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!
https://mermaid.live This might handle a lot of the GUI in combination with some scripting and a few other bits tossed in the mix.
But mostly came to demand cat tax!
Apologies for delay, mandatory cat tax!
postgresql db (e.g. in Docker) + Dbeaver as GUI client
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).
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 🤣
https://sqlitebrowser.org/ is great or aSQLiteManager for android
It’s already been recommended, but I think Grist or a lowcode/nocode thing like baserow or nocodb might work for you.
Also, I’d love to see what you come up with! My cats are picky eaters and I’ve been wanting to keep track of what wet food they like or not.
I’m a fan of Heidi
I think Grist would definitely fit your needs.
I use dbeaver on ubuntu and windows.
Many thanks for all the replies, il take a look at them!
I’d love you to check back later with your conclusions.
Not locally hosted, but pretty powerful and has a free tier.
Basically spreadsheets but superpowered.
Grist is a selfhostable alternative to Airtable
I think for this it is over the top but I found rei3 one oft the best database webapp low-code builders: https://rei3.de/en/home
https://selfh.st/apps/?alternative=Airtable Self hosted airtable
check out SQLiteStudio. It looks a good deal simpler than using dbeaver and it works on Linux. https://www.sqlitestudio.pl/
Yessss this program is amazing. One of the few things I’ve donated to.
You might be looking for Nocodb
Perfect application for NocoDB in my opinion. They have a relationship view like the one shown in the screenshot and a form builder for easily adding new data. Setting up the relationships is easy. I find it much easier to use than DBeaver and the GUI is more modern.
The data is accessible by programs such as DBeaver, and they have a REST API too, should you need it.
Hmm, nocodb is a webapp first and foremost. It does have binaries to run directly on the host, but I’m not entirely sure to recommend this over libreoffice actual app for database management. I believe it would be more in line with OPs requirement.
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
Yea, talk about overcomplicating a simple task.
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!
