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.

  • SreudianFlip@sh.itjust.worksEnglish
    1·
    4 hours ago

    I have been looking at Saltcorn for this purpose, and it seems quite interesting. I can’t verify it or vouch for it, however.

    If I had more time, I would love to play with it and try and build things. But I am pretty busy. So I am also looking at replacing my specialized CRM with something open source and self-hosted.

    It’s not pretty, but I will probably settle on Dolibarr as it’s non-American, comprehensive, and there are docker implementations.

    Edit: rereading your use case, I think you should look harder at Dolibarr as it is FOSS, widely used, and comprehensive but you can disable what you don’t need. Save your team the development time.