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) :)
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!
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)
Food for thought (no pun intended), but unless you’re willing to build an app (could be a great app; I doubt you’re the only person who could use this), you might be over engineering this quite a bit. A spreadsheet could be made to do what you’re looking for, with much less effort.
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.
Not a locally run tool, but a self hosted web app (that I wire up to my self hosted db) that has a web portal I login to, and then can manage my db with a nice slick UI to define tables, relations, etc.
There’s been some I’ve found but they vastly lacked basic features and were clearly in very early beta.
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !selfhosted@lemmy.world
A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don’t control.
Rules:
Be civil: we’re here to support and learn from one another. Insults won’t be tolerated. Flame wars are frowned upon.
No spam posting.
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it’s not obvious why your post topic revolves around selfhosting, please include details to make it clear.
Don’t duplicate the full text of your blog or github here. Just post the link for folks to click.
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
No trolling.
Resources:
selfh.st Newsletter and index of selfhosted software and apps
I use dbeaver on ubuntu and windows.
https://dbeaver.io/download/
doesn’t vscode have an extension that does that?
If you know the name, I’d be curious 🥺
I think it’s literally called “SQLite”. I haven’t used it though, so idk how good it is…
I think Grist would definitely fit your needs.
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 🤣
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)
https://github.com/nocodb/nocodb
Many thanks for all the replies, il take a look at them!
I’d love you to check back later with your conclusions.
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!
Très jolie!
deleted by creator
postgresql db (e.g. in Docker) + Dbeaver as GUI client
I found this site which might help you in your search.
https://selfh.st/apps/
Food for thought (no pun intended), but unless you’re willing to build an app (could be a great app; I doubt you’re the only person who could use this), you might be over engineering this quite a bit. A spreadsheet could be made to do what you’re looking for, with much less effort.
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.
https://sqlitebrowser.org/ is great or aSQLiteManager for android
I’ve been looking for th8s for awhile too.
Not a locally run tool, but a self hosted web app (that I wire up to my self hosted db) that has a web portal I login to, and then can manage my db with a nice slick UI to define tables, relations, etc.
There’s been some I’ve found but they vastly lacked basic features and were clearly in very early beta.
check out SQLiteStudio. It looks a good deal simpler than using dbeaver and it works on Linux. https://www.sqlitestudio.pl/
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
I’m a fan of Heidi
https://www.heidisql.com/