Tools for cloud storage, email, instant-messaging, collaborative text editing, hard drive encryption abound, they're free, easy to use, secure, and overall amazing (more in first comment). The one obstacle I haven't been able to tackle in several days of searching is an alternative to Google Sheets (spreadsheets and databases are pretty similar for my use case).
My criteria:
- security (E2E encryption, 2-factor authentication, not US-based)
- collaborative real-time editing
- ease-of-use, low maintenance
- small volume (10 sheets, 20 columns and 10k rows each) is sufficient
- simple data analysis (searching, filtering, count)
Optional features: differently-typed cells (dropdown, checkbox), forms to add new data-points.
Spreadsheets are so commonly used that all flavours should exist, but I wasn't able to find a tool that fulfills all criteria (more in first comment). I can think of 3 reasons:
- there is an insurmountable technical difficulty in creating a tool that is both collaborative and encrypted: can't be that though, since encrypted Google Docs/Trello clones are easy to find ([CryptPad](https://cryptpad.fr/), [Keybase](https://keybase.io/))
- the need is covered by encryption tools for databases: these require a lot of technical knowledge (renting servers, hosting databases, deploying encryption, etc.), surely a no-code tool would already exist?
- I haven't found the tool: wouldn't it be included in Keybase or the like though?
The second option seems the most likely, in which case I'd be happy if someone could tell me the easiest way to build an encrypted database, as I have never done something like that (I'm familiar with Python, know that SQL exists, and can probably follow instructions to deploy something on a server), but I would really need this tool to be low/no-maintenance
Cheers