Looking for some kind of local DB manager? "application" with a gui (lemmy.world)

submitted 14 hours ago* (last edited 14 hours ago) by OwlPaste@lemmy.world to c/selfhosted@lemmy.world

35 comments fedilink hide all child comments

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!

top 35 comments

sorted by: hot top controversial new old

[-] gofsckyourself@lemmy.world 1 points 4 hours ago

I'm a fan of Heidi

https://www.heidisql.com/

[-] AustralianSimon@lemmy.world 18 points 10 hours ago

I use dbeaver on ubuntu and windows.

https://dbeaver.io/download/

[-] 01189998819991197253@infosec.pub 14 points 12 hours ago* (last edited 12 hours 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.works 3 points 10 hours 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!

[-] keepee@lemmy.world 4 points 9 hours ago

I think Grist would definitely fit your needs.

[-] OwlPaste@lemmy.world 4 points 10 hours ago

Many thanks for all the replies, il take a look at them!

[-] thirdBreakfast@lemmy.world 3 points 4 hours ago

I'd love you to check back later with your conclusions.

[-] xep@fedia.io 13 points 14 hours ago

Would DBeaver suffice?

[-] AustralianSimon@lemmy.world 2 points 10 hours ago

I also suggested this. Friendly on lots of operating systems too.

[-] ITeeTechMonkey@lemmy.world 3 points 12 hours ago

I use DBeaver at work when I am having problems with psql commands in terminal. It's prevented me from pulling out my hair a few times.

[-] daddy32@lemmy.world 4 points 6 hours ago

Question is, what is its Wife Acceptance Factor (WAF)?

[-] thinkyfish@lemmy.world 6 points 12 hours ago

check out SQLiteStudio. It looks a good deal simpler than using dbeaver and it works on Linux. https://www.sqlitestudio.pl/

[-] JackbyDev@programming.dev 2 points 3 hours ago

Yessss this program is amazing. One of the few things I've donated to.

[-] just_another_person@lemmy.world 7 points 12 hours ago

You might be looking for Nocodb

[-] k4j8@lemmy.world 2 points 2 hours ago* (last edited 2 hours ago)

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.

[-] krash@lemmy.ml 1 points 4 hours ago

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.

[-] gramie@lemmy.ca 12 points 14 hours ago

The database app in LibreOffice, based on the Firebird database engine, can do all that.

[-] bmck@lemmy.bmck.au 3 points 10 hours ago

Not locally hosted, but pretty powerful and has a free tier.

https://airtable.com/

Basically spreadsheets but superpowered.

[-] retro@infosec.pub 7 points 6 hours ago

Grist is a selfhostable alternative to Airtable

https://www.getgrist.com/blog/grist-v-airtable/

[-] Ekpu@lemmy.world 3 points 11 hours ago

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

[-] redbr64@lemmy.world 5 points 12 hours ago* (last edited 12 hours ago)

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)

[-] just_another_person@lemmy.world 2 points 12 hours ago

https://github.com/nocodb/nocodb

[-] Nomecks@lemmy.ca 6 points 14 hours ago

Why wouldn't a simple spreadsheet and some pivot tables work?

[-] atzanteol@sh.itjust.works 1 points 10 hours ago

The data is relational. Spreadsheets are a pain to use for that.

[-] NaibofTabr@infosec.pub -1 points 14 hours ago

Never use a spreadsheet to do a database job.

[-] Nomecks@lemmy.ca 19 points 13 hours ago

Tracking a single cat doesn't seem like DB work

[-] themeatbridge@lemmy.world 5 points 12 hours ago

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.

[-] Nomecks@lemmy.ca 2 points 12 hours ago* (last edited 12 hours ago)

Sure, but how many foods are we talking here? This sounds like probably <20 rows on a sheet, with columns for ingredients.

[-] OwlPaste@lemmy.world 2 points 11 hours ago* (last edited 11 hours ago)

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.

[-] shertson@lemmy.world 1 points 1 hour ago

I'm not sure about libre office, but Excel has lookup and lookup. I've not personally used those. But might be of help.

[-] GrumpyBike1020@monero.town 2 points 11 hours ago

https://selfh.st/apps/?alternative=Airtable Self hosted airtable

[-] dohpaz42@lemmy.world 3 points 14 hours ago

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.

[-] pixxelkick@lemmy.world 1 points 14 hours ago* (last edited 14 hours ago)

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.

[-] lungdart@lemmy.ca -1 points 14 hours ago

Neo4j might with

[-] nick@midwest.social 3 points 13 hours ago

lol what, a graph database for spreadsheet work?

this post was submitted on 15 Oct 2024

47 points (100.0% liked)

Selfhosted

39632 readers

349 users here now

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:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 1 year ago

MODERATORS

HybridSarcasm@lemmy.world

HybridSarcasm@lemmy.hybridsarcasm.xyz