/grist-electron

Desktop Grist, packaged with Electron

Primary LanguageTypeScriptApache License 2.0Apache-2.0

Grist Desktop App, built with Electron

This is an Electron build of Grist. Use it to easily open and edit Grist spreadsheets on your computer. It does not need the internet, and will work fine on a desert island (assuming you can find a power outlet). It is not tied to any online account or service.

This build is handy for all sorts of things, like editing splits for ML training runs, analyzing some CSV or JSON data, or preparing some structured lists for a batch job.

It is also the quickest way to demonstrate to the skeptical that a Grist spreadsheet on a hosted service really is fully self-contained, and that you could download it and work with it on your own hardware if you needed to.

For hosting Grist spreadsheets on a server for use by a team, better options are grist-core and grist-omnibus.

Download

See https://github.com/gristlabs/grist-electron/releases

Screenshots

The Grist Meme Generator template being edited on an Intel Mac.

Grist on Intel Mac

A Wedding Planner on Ubuntu.

Grist on Linux

A D&D Encounter Tracker on an ARM Mac (M1).

Grist on Mac M1

A Doggy Daycare spreadsheet running on an old super-low-resolution Windows 7 setup.

Grist on Windows 7

Grist Electron being used as a server on a LAN, on Windows 10 Pro (credit: Sylvain_Page).

Grist on Windows 10 Pro

How to build from source

You'll need an environment with bash, git, and yarn.

git submodule init
git submodule update
yarn install
yarn run setup
yarn run build
yarn run electron:preview
yarn run electron

Configure

There's no configuration needed if you are just running this as a regular app to view and edit Grist spreadsheets on your laptop.

Some people use the app as a quick way to set up a simple Grist server in a local network where everyone is trusted. Be sure you know what you're doing - if you have any security concerns at all, I'd urge you to do a proper Grist server installation - see https://support.getgrist.com/self-managed/

If you are sure you are in a trusted environment, you can set some environment variables to make Grist listen on a specific network interface and port:

GRIST_HOST=192.168.1.22     # IP address to serve from
GRIST_PORT=8484             # Port number to serve at
GRIST_ELECTRON_AUTH=strict  # Auth strategy (strict, mixed, or none)

(You can create a .env file in the root directory of the app and set the environment variables there). Set GRIST_ELECTRON_AUTH to none to allow access across the network just as if you were using the app. Set GRIST_ELECTRON_AUTH to mixed to allow anonymous access across the network, but not logins. Set GRIST_ELECTRON_AUTH to strict to require logins and to permit them only in the app.

It you use Grist on the network this way, be aware that data is being sent using plain http and not encrypted https, so network traffic could be readable in transit. And there is no login mechanism built in.

An experimental sandboxing mechanism is turned on by default, so that formulas in a spreadsheet are limited in their effect. Sandboxing can be turned off by setting:

GRIST_SANDBOX_FLAVOR=unsandboxed

It can be explicitly set by doing:

GRIST_SANDBOX_FLAVOR=pyodide

There are also gvisor and macSandboxExec sandbox flavors, but they are not yet easy to use.

If you turn off sandboxing, then the full raw power of Python will be available to any Grist spreadsheet you open. So:

  • Use only with your own Grist spreadsheets, or
  • Use with spreadsheets you trust, or
  • Turn sandboxing the heck back on, or
  • Return to the YOLO days of opening spreadsheets and crossing your fingers.

History

Learn the back-story of this work in the Packaging Grist as an Electron app forum thread.

It draws on some ideas from https://github.com/stan-donarise/grist-core-electron/ and from an early standalone version of Grist developed at Grist Labs.

Roadmap

  • Set up a Windows x86 build
  • Set up a Windows x64 build
  • Set up a Linux x64 build
  • Set up a Mac x64 build
  • Set up a Mac ARM build
  • Sign and notarize Mac builds
  • Revive the File items in the menu
  • Revive opening a Grist spreadsheet from the command line
  • Revive the updater
  • Add Linux ARM builds
  • Land grist-core changes upstream
  • Land node-sqlite3 build changes in @gristlabs fork
  • Get python sandboxing going. Considering using WASM; could also use runsc on Linux and sandbox-exec on Mac
  • Turn sandboxing on by default
  • Become an official gristlabs project :-)

License

Apache License, Version 2.0