About once a year, I unsuccessfully quest for a FOSS replacement for Filemaker Pro. Specifically, I’m on the hunt for a solution that:
- Lets me create a variety of graphical ‘layouts’ of fields positioned on a page to display different segments of the data.
- Can search the data from those same layouts, by entering text into various fields (eg, ‘Sanderson’ in author, ‘< 1/1/2015’ in date.
This is largely for personal sized datasets: I only need to handle small (several thousand entries, all just text based) data collections. Basically, small enough that it could in principle be handled using a Libreoffice Calc spreadsheet and applying filters - I’d just like something more friendly.
Several users will use my databases (locally, no need for online hosting). It will be rare that multiple users try to access it simultaneously, so its ok if only one person can open at a time. Macros and relational field structures would be a bonus but not necessary.
I’ve tried a bunch of solutions. The closest are:
- Libreoffice Base. Layouts can’t be used to both enter and search data. Creating new search queries is overly arduous.
- Kexi. Similar to Base.
- Symphytum. Great, except the search is much too limited (no field specific search)
Any other suggestions?
In beta but you mean sonething like this?
Nextcloud Tables (Companion app for Nextcloud Tables) https://f-droid.org/packages/it.niedermann.nextcloud.tables/
Thanks - but having to host NextCloud is a dealbreaker for me. It seems very exciting and perhaps I’ll learn how to do this at some point, but I’d really love a simple standalone program.
I used to have a similar app that used local sqlite database if i remember right, cant remember what it was though, i have a feeling it might have been a desktop program
Have you considered using a nextcloud provider instead of hosting your own? Thats what i do, i use murena.io
Might look through this list: https://alternativeto.net/software/filemaker-pro/?license=opensource