Re:Open source electronic lab notebook
by bluGill on Thursday June 15, 2017 @04:27PM
(#14564065)
Anytime someone says excel I immediately think that they would be better off with a real database. I'm rarely wrong.
This is defiantly a case where you want a database. You want all data to go into a write-only table (when you make a mistake the correction needs to be noted and tracked). Then use queries to do your analysis on the raw data assured that you won't make a mistake.
A database also does well for collecting meta-data: who entered this data when.
Finally a database is very useful for meta-analysis which is starting to become important.
This is defiantly a case where you want a database. You want all data to go into a write-only table (when you make a mistake the correction needs to be noted and tracked). Then use queries to do your analysis on the raw data assured that you won't make a mistake.
A database also does well for collecting meta-data: who entered this data when.
Finally a database is very useful for meta-analysis which is starting to become important.