That’s the way it goes with the scale from simple to “something that fits our needs”. Either something is too simple or it is so complex that you can’t let your more challenged users at it. So you end up rolling your own solution.
That’s how many companies end up with monstrous Excel or Access applications.
The upside of having your own app that uses common open source components is that integration with other tools is easier later down the line. Make it web based and it can run on basically every computer on the planet. Use PostgreSQL or MySQL in the backend and you can easily add other frontends if needed.
frongt@lemmy.zip 2 weeks ago
On the plus side that means it’ll be pretty quick and easy to implement.
But as always, I’m sure they’ll ask “ok but can it also do this?” and at that point you need to weigh the cost of your time vs buying one of those products.
The only other options I’m aware of are just using something like phpmysql or whatever the postgres equivalent is called, or maybe some FOSS alternative to powerbi. Maybe libreoffice calc can connect to SQL?