cortex-lab / alyx

Database for experimental neuroscience laboratories
44 stars 11 forks source link

"project" table #300

Closed nsteinme closed 6 years ago

nsteinme commented 7 years ago

One thing that will be difficult in the current implementation will be finding the sessions you're interested in, in order to view the notes about those sessions. I propose a "Project" table, each row of which has:

Then there's a many-to-many relationship between Projects and Sessions. So when you run a session, you can put it in any number of projects, and when you go to that project, you'll see those sessions listed there. Optionally expand all notes about all sessions in that project, for example.

@kdharris101 @petersaj ?

petersaj commented 7 years ago

aren't these things already searchable by other terms? for example if I wanted experiments with widefield imaging and sparse noise stimuli and pupil videos on female mice over 6 weeks old from the last two years, it pops those all up?

nsteinme commented 7 years ago

You can do an SQL query for those things and get those sessions in matlab. You could then copy and paste the session URL into the browser to see that one session's notes, or do a further SQL query about it. So in that sense, this suggestion is a convenience.

However there might be sessions that you want to link together under a project heading wouldn't all be returned by any one search, e.g. Mario had done some 2p imaging with GCAMP-expressing PV neurons then I did some electrophysiology with ChR2-expressing PV neurons. The mice, lines, rig, users, etc were all different between the two sets of experiments but we could still put them under the same project.

On Thu, May 11, 2017 at 4:19 PM, Andy Peters notifications@github.com wrote:

aren't these things already searchable by other terms? for example if I wanted experiments with widefield imaging and sparse noise stimuli and pupil videos on female mice over 6 weeks old from the last two years, it pops those all up?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/cortex-lab/alyx/issues/300#issuecomment-300822798, or mute the thread https://github.com/notifications/unsubscribe-auth/AHPUP0d88t-RS25zAyACDaH8gang3oPLks5r4yb4gaJpZM4NYHFi .

petersaj commented 7 years ago

it might be nice to have the former be a feature of the website too if that's possible, search for sessions with given parameters and get a list

On Thu, May 11, 2017 at 4:59 PM, Nick Steinmetz notifications@github.com wrote:

You can do an SQL query for those things and get those sessions in matlab. You could then copy and paste the session URL into the browser to see that one session's notes, or do a further SQL query about it. So in that sense, this suggestion is a convenience.

However there might be sessions that you want to link together under a project heading wouldn't all be returned by any one search, e.g. Mario had done some 2p imaging with GCAMP-expressing PV neurons then I did some electrophysiology with ChR2-expressing PV neurons. The mice, lines, rig, users, etc were all different between the two sets of experiments but we could still put them under the same project.

On Thu, May 11, 2017 at 4:19 PM, Andy Peters notifications@github.com wrote:

aren't these things already searchable by other terms? for example if I wanted experiments with widefield imaging and sparse noise stimuli and pupil videos on female mice over 6 weeks old from the last two years, it pops those all up?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/cortex-lab/alyx/issues/300#issuecomment-300822798, or mute the thread https://github.com/notifications/unsubscribe-auth/AHPUP0d88t- RS25zAyACDaH8gang3oPLks5r4yb4gaJpZM4NYHFi .

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/cortex-lab/alyx/issues/300#issuecomment-300835831, or mute the thread https://github.com/notifications/unsubscribe-auth/ARJuIKxjXNc6efRgNm5UV_hpBWwkmhNeks5r4zB5gaJpZM4NYHFi .

nsteinme commented 7 years ago

These would be filters on the sessions page. You could make a list of what filters there should be and make a new issue for it?

On Thu, May 11, 2017 at 5:10 PM, Andy Peters notifications@github.com wrote:

it might be nice to have the former be a feature of the website too if that's possible, search for sessions with given parameters and get a list

On Thu, May 11, 2017 at 4:59 PM, Nick Steinmetz notifications@github.com wrote:

You can do an SQL query for those things and get those sessions in matlab. You could then copy and paste the session URL into the browser to see that one session's notes, or do a further SQL query about it. So in that sense, this suggestion is a convenience.

However there might be sessions that you want to link together under a project heading wouldn't all be returned by any one search, e.g. Mario had done some 2p imaging with GCAMP-expressing PV neurons then I did some electrophysiology with ChR2-expressing PV neurons. The mice, lines, rig, users, etc were all different between the two sets of experiments but we could still put them under the same project.

On Thu, May 11, 2017 at 4:19 PM, Andy Peters notifications@github.com wrote:

aren't these things already searchable by other terms? for example if I wanted experiments with widefield imaging and sparse noise stimuli and pupil videos on female mice over 6 weeks old from the last two years, it pops those all up?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://github.com/cortex-lab/alyx/issues/300#issuecomment-300822798 , or mute the thread https://github.com/notifications/unsubscribe-auth/AHPUP0d88t- RS25zAyACDaH8gang3oPLks5r4yb4gaJpZM4NYHFi .

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/cortex-lab/alyx/issues/300#issuecomment-300835831, or mute the thread https://github.com/notifications/unsubscribe- auth/ARJuIKxjXNc6efRgNm5UV_hpBWwkmhNeks5r4zB5gaJpZM4NYHFi .

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/cortex-lab/alyx/issues/300#issuecomment-300838730, or mute the thread https://github.com/notifications/unsubscribe-auth/AHPUP9V3zKeemyuCTZYj_4OhuQo-I8-pks5r4zLigaJpZM4NYHFi .

kdharris101 commented 7 years ago

Good idea Nick.

I do worry a bit about an explosion of tables. And an alternative would be to have free-text Tags associated to any session (just text).

But a projects table is better really.

petersaj commented 7 years ago

ok - maybe I'll wait until the planned sessions extensions are made so we can play around with it and see what other things we want

On Thu, May 11, 2017 at 5:22 PM, Nick Steinmetz notifications@github.com wrote:

These would be filters on the sessions page. You could make a list of what filters there should be and make a new issue for it?

On Thu, May 11, 2017 at 5:10 PM, Andy Peters notifications@github.com

wrote:

it might be nice to have the former be a feature of the website too if that's possible, search for sessions with given parameters and get a list

On Thu, May 11, 2017 at 4:59 PM, Nick Steinmetz < notifications@github.com> wrote:

You can do an SQL query for those things and get those sessions in matlab. You could then copy and paste the session URL into the browser to see that one session's notes, or do a further SQL query about it. So in that sense, this suggestion is a convenience.

However there might be sessions that you want to link together under a project heading wouldn't all be returned by any one search, e.g. Mario had done some 2p imaging with GCAMP-expressing PV neurons then I did some electrophysiology with ChR2-expressing PV neurons. The mice, lines, rig, users, etc were all different between the two sets of experiments but we could still put them under the same project.

On Thu, May 11, 2017 at 4:19 PM, Andy Peters <notifications@github.com

wrote:

aren't these things already searchable by other terms? for example if I wanted experiments with widefield imaging and sparse noise stimuli and pupil videos on female mice over 6 weeks old from the last two years, it pops those all up?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://github.com/cortex-lab/alyx/issues/300# issuecomment-300822798 , or mute the thread https://github.com/notifications/unsubscribe-auth/AHPUP0d88t- RS25zAyACDaH8gang3oPLks5r4yb4gaJpZM4NYHFi .

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://github.com/cortex-lab/alyx/issues/300#issuecomment-300835831 , or mute the thread https://github.com/notifications/unsubscribe- auth/ARJuIKxjXNc6efRgNm5UV_hpBWwkmhNeks5r4zB5gaJpZM4NYHFi .

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/cortex-lab/alyx/issues/300#issuecomment-300838730, or mute the thread https://github.com/notifications/unsubscribe-auth/AHPUP9V3zKeemyuCTZYj_ 4OhuQo-I8-pks5r4zLigaJpZM4NYHFi .

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/cortex-lab/alyx/issues/300#issuecomment-300842236, or mute the thread https://github.com/notifications/unsubscribe-auth/ARJuIEU42GM6EeFFkh-SlJmqnMTxbY-Hks5r4zXegaJpZM4NYHFi .