8
Home
lp edited this page 4 months ago
Leading solution: Grist
Functions fine using built-in node server on a bare digital ocean IP with following recipe:
UFW
| To | Action | From |
|---|---|---|
| 22/tcp | LIMIT | Anywhere |
| 2375/tcp | ALLOW | Anywhere |
| 2376/tcp | ALLOW | Anywhere |
| 80 | ALLOW | Anywhere |
| 22/tcp (v6) | LIMIT | Anywhere (v6) |
| 2375/tcp (v6) | ALLOW | Anywhere (v6) |
| 2376/tcp (v6) | ALLOW | Anywhere (v6) |
| 80 (v6) | ALLOW | Anywhere (v6) |
Docker run script
docker run -d -p 80:8484 -e GRIST_PUBLIC_URL=http://<URL> -e GRIST_SQLITE_DB=/var/lib/grist/grist.db -e APP_HOME_URL=http://<URL> --name grist gristlabs/grist-oss
APP_HOME_URL is needed, as found here: https://community.getgrist.com/t/networkerror-when-attempting-to-fetch-resource/1653/4
This creates a functioning anonymous instance with no login auth defined. Unclear of how users are managed, maybe all in cookies, does weird stuff like giving user named like @guest and @you (possibly to multiple users simultaneously). Multiple people can edit the same table, data will update to other user, but there's no notification of collaborative editing: no user list, and no cursor to show what other user is doing.
Probably has sandboxing issues, and is missing secret.
Comparison/Issues:
Ethercalc (mobile)
- Cell editing is easily done by typing into formula box, but formula box doesn't float - so editing anything beyond roughly D33 is annoying.
Onlyoffice (mobile)
- Cell editing is difficult as keyboard doesn't spawn intuitively.
Seatable
- Doesn't appear to offer read/write anonymous links
Baserow
- Doesn't appear to offer read/write anonymous links
Cryptpad
- Garbage mobile UX
- Possibly can be helped by self-hosting, and either commenting out code or doing CSS display:none hacks to improve UX.