• Stars
    star
    166
  • Rank 227,748 (Top 5 %)
  • Language
    TypeScript
  • License
    Apache License 2.0
  • Created almost 2 years ago
  • Updated about 1 month ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

Desktop Grist, packaged with Electron

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

More Repositories

1

grist-core

Grist is the evolution of spreadsheets.
TypeScript
6,985
star
2

ts-interface-checker

Runtime library to validate data against TypeScript interfaces.
TypeScript
323
star
3

asttokens

Annotate Python AST trees with source text and token information
Python
172
star
4

ts-interface-builder

Compile TypeScript interfaces into a description that allows runtime validation
TypeScript
132
star
5

mkdocs-windmill

Outstanding mkdocs theme with a focus on navigation and usability
CSS
105
star
6

grist-static

Showing Grist spreadsheets on a static website, without a special backend.
TypeScript
88
star
7

grist-widget

A repository of custom widgets to embed in Grist documents
JavaScript
56
star
8

grist-omnibus

an opinionated Grist+Dex+Traefik package for first-time self-hosters
JavaScript
52
star
9

yaml-cfn

Parser and schema for CloudFormation YAML templates
JavaScript
31
star
10

py_grist_api

Python client for interacting with Grist
Python
19
star
11

grist-help

Grist documentation and help center articles
HTML
13
star
12

grist-api

NodeJS client for interacting with Grist
TypeScript
13
star
13

grainjs

Javascript library from Grist Labs
TypeScript
13
star
14

grist-ee

The source code for self-managed Grist Enterprise.
TypeScript
11
star
15

aws-lambda-upload

Package and upload an AWS lambda with its minimal dependencies
JavaScript
7
star
16

secrets.js

Tiny node tool to share secrets using public key crypto
JavaScript
6
star
17

jupyterlite-widget

Python
3
star
18

grain-rpc

Typed RPC interface on top of an arbitrary communication channel
TypeScript
3
star
19

grist-pug-py-widget

Grist widget to directly develop custom widgets within Grist’s UI.
JavaScript
3
star
20

grist-form-submit

Turn form submissions on webpages into new records in Grist documents
TypeScript
3
star
21

mocha-webdriver

Write Mocha style tests using selenium-webdriver, with many conveniences.
TypeScript
3
star
22

npm-check-shrinkwrap

Quickly check if contents of node_modules correspond to npm-shrinkwrap.json
JavaScript
2
star
23

grist-plugin-examples

2
star
24

collect-js-deps

Collect the minimal list of dependencies required by a JS file.
JavaScript
1
star
25

grist-zapier

Code behind the initial Grist/Zapier integration, exported as a reference.
JavaScript
1
star