Recommend a simple local FLOSS database for beginners? (piefed.social)

submitted 2 weeks ago by klu9@piefed.social to c/linux4noobs@programming.dev

10 comments fedilink hide all child comments

Context

I've started a Fediverse watch party (#ReMonsterdon on Mastodon) & want to store & organize info about it (films shown; films scheduled to be shown; candidates for showing; dates; relevant links like streams, trailers, Wikipedia; images like film posters etc).

At the moment, I'm using a combination of stuff on my computer, i.e. a folder with text & image files, and a collection on NeoDB, a Fediverse media catalogue.

But I'd like a more all-in-one & organized/organizable file (easy to search, sort etc). A lot of people use a spreadsheet for that kind of thing. But I was under the impression that that's what databases are for.

I don't know much about either. I use spreadsheets very little and databases not at all (except NeoDB, I suppose).

Request

Is there a simple, local, FLOSS, GUI database, suitable for beginners, that I could use for this?

(I had a look at my installation of LibreOffice, but for some reason the options for creating a Base file are greyed out or missing).

(I am not yet ready to try self-hosting. So something that is local, preferably in a system package, .deb or .AppImage. My OS: Linux Mint 22.2 Xfce.)

Thanks in advance

you are viewing a single comment's thread
view the rest of the comments

[-] sunrisepirate@piefed.social 2 points 2 weeks ago

Another alternative to a database that will let you practice SQL is duckdb.

I use it frequently at work with python and parquet files which are type safe, compact, and very performant. I use Python with Positron as my IDE (I'm a data scientist) and it has a built in parquet viewer that makes the data exploration a little less abstract.

this post was submitted on 17 May 2026

15 points (100.0% liked)

linux4noobs

4185 readers

12 users here now

linux4noobs

Noob Friendly, Expert Enabling

Whether you're a seasoned pro or the noobiest of noobs, you've found the right place for Linux support and information. With a dedication to supporting free and open source software, this community aims to ensure Linux fits your needs and works for you. From troubleshooting to tutorials, practical tips, news and more, all aspects of Linux are warmly welcomed. Join a community of like-minded enthusiasts and professionals driving Linux's ongoing evolution.

Seeking Support?

Mention your Linux distro and relevant system details.
Describe what you've tried so far.
Share your solution even if you found it yourself.
Do not delete your post. This allows other people to see possible solutions if they have a similar problem.
Properly format any scripts, code, logs, or error messages.
Be mindful to omit any sensitive information such as usernames, passwords, IP addresses, etc.

Community Rules

Keep discussions respectful and amiable. This community is a space where individuals may freely inquire, exchange thoughts, express viewpoints, and extend help without encountering belittlement. We were all a noob at one point. Differing opinions and ideas is a normal part of discourse, but it must remain civil. Offenders will be warned and/or removed.
Posts must be Linux oriented
Spam or affiliate links will not be tolerated.

founded 2 years ago

MODERATORS

PlutoParty@programming.dev