I'm trying to find a tool which can fit my needs in the management of a list a scientific papers I read during my phd thesis. For each paper I collect title, authors, write a summary, give tags...
I want a spreadsheet tool like LibreOffice Calc or Microsoft Excel but with features from SQL database clients.
I found 2 kind of tools : SQL clients (like DBeaver) and Spreadsheet tools, but none meets all needs.
Actually I have ~100 papers on rows in my LibreOffice Calc file, and some features described below are very simple but missing.
- Easy control of cells size, can display the entire content of a cell just by clicking on... In a nutshell an ergonomic way to navigate / display cells knowing that some has a lot of text in and other hasn't.
- Column selection in a checkbox (Hide/Display) like we can do in a file explorer.
- Filtering /sorting by years for example.
- Filtering by list of tags (or list of keywords). For example a paper can have multiple tags like #network, #machinelearning, #topicmodeling. The filter could allow the user to click on tags in a checkbox which filter lines by requesting "the line must contain #tag1 OR #tag2". There is the "AutoFilter" in all spreadsheet tools but doesn't allow multiple keys.
And unfortunately in spreadsheet tools it is easy to break all database coherence, I recently tried to sort by the "year" column and Calc just moved all years of all lines without keeping titles and others on the corresponding line. I know I don't use the tool well but I wanted a tool wich can secure my data and prevent mistakes like this...