I'm looking for something that can store, manage and display a fairly simple set of data and their relations. But since these are n:m relations, obvious solutions like Excel don't work well. What I have:
- data sets A, B and C
- n:m relations between A-B and B-C
- just a few columns for each data set
The most important part here is the relations. I'm looking for 3 lists, obviously, and then a display where if I select an entry from set A, it will show me the related entries in set B, for example. (or it could show them inline in the table, like a set of tags).
Regular users must be able to use it, and at best it's Free Software. I'm ok with having to write a bit of code to make it all work. It can be web-based or an application. In that case it would be great if it were multi-platform (Windows, macOS, Linux).
I've looked at a number of possibilities, such as airtables, NocoDB, Kexi, Symphytum and none of them look like they will give me what I need without considerable work. I'm thinking that maybe a graph database frontend would be best.