Selfhosted

57822 readers

456 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.
No low-effort posts. This is subjective and will largely be determined by the community member reports.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

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

Questions? DM the mods!

founded 2 years ago

MODERATORS

HybridSarcasm@lemmy.world

HybridSarcasm@lemmy.hybridsarcasm.xyz

AFFORDABLE selfhosted nocode relational databases? (à la Baserow/NocoDB, etc.) (jlai.lu)

submitted 8 hours ago by Buck@jlai.lu to c/selfhosted@lemmy.world

13 comments fedilink hide all child comments

Hi,

I selfhost a lot of tools for personal (and professional) use, so this surprised me, but maybe I am missing something regarding simple tools that are "open source enough" for relational databases.

My (small, broke) company has a problem with tools, and I figured that open source would be the answer, but if I look at the usual suspects that would allow for a simple way to create/update/sort/search clients and missions, that everyone could use, everything seems either very limited or very expensive (or both!).

I looked at the pricing for Baserow, Grist, NodoDB, Nocobase, and for 100 users and 5000 rows, it means around 12 000 euros per year to get something usable. And the open source selfhosted versions are quite limited everytime. I saw someone rage about open core some months ago, but never realized how true this was.

The only thing that seems truly open source (and a lot more limited than the others) is Mathesar. Maybe it will be good enough. There isn't much content about it, I will have to look at the documentation to get a better feeling of what it can offer.

Is there some truly open source no code relational database tools around? Enough to create rows, have advanced (AND OR) search, and a tag system to look for "all clients in country X with type of mission Y in sector Z in 2024" or "all missions for clients A or B"

For those wondering, of course we have a tool to manage missions, clients, billing, etc. but it is truly awful, and I was hoping to propose something simple to manage search of past references, but nothing seems as easy as I thought it would.

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

[–] bacon_pdp@lemmy.world 2 points 8 hours ago (1 children)

There is no such thing as no code, just code that someone else wrote. Not that such code isn’t trivial to get from a basic LLM that you can run locally for pennies a year.

https://blog.mlc.ai/2024/04/20/GPU-Accelerated-LLM-on-Orange-Pi

Just setup a standard PostgreSQL database and then work with the LLM to write some C# code to connect to it and create, update and delete data per your own system needs. Hire a part time programmer if you need more help. They usually can get you where you want to be cheaply if they are FSF developers and you don’t restrict them from using the code they write for you.

[–] joeldebruijn@lemmy.ml 1 points 6 hours ago (1 children)

For more discussion on the value of the term "No code" I can recommend this: https://vger.to/lemmy.ml/post/35466470

[–] bacon_pdp@lemmy.world 0 points 6 hours ago

Thank you for the recommendation.