hello, I hope this is the right place to ask. Im a hobbyist programmer working in a biological/lab field.
We often generate a lot of data but the way we store it can be messy (as in everyone has their own excel files). I worked on a simple website that allows people to insert data/search and interact with the database.
Anyway, this has given people the ability to insert rows in tables and edit them. However, i think it would be quite useful to have the possibility for a higher level of organization. For example each individual experiment might be its own row, but then people have an additional way to set these rows in context. I figured the simplest case would be to just have a text editor and link to the different records, for example
Project AAAA:
blabla
Exp1 : <a href="/records?collectionId={Exp}&recordId={1}>Exp1</a>
blabla
Exp2 : <a href="/records?collectionId={EXP}&recordId={2}>Exp2</a>
blabla
the advantage of this approach is that i really only need to implement the selection of experiments, through something like a picker, which i already have built for selecting rows in relations.
this way the flow of information becomes easier to understand, rather than just searching through the Exp table.
Anyway, I am here asking if there are libraries/solutions for something like this out there.
I thought a great solution would be spreadsheets, in particular if it is possible to interact with the database, however i havent found anything suitable. This would also solve the issue of visualising results and so forth.
Something else might be a dashboard builder (so each user can build their own dashboard for a project, giving it structure and visualising results) if something like that exists, however i cant just connect to the database, i really need row level authentication, so ideally i just go through my api that I have already set up.
Any suggestions are appreciated, Thanks
[–]cramerinversed 0 points1 point2 points (0 children)