Grist Core

Grist offers a powerful approach to data management by fusing the intuitive interface of a spreadsheet with the strict relational structure of a database. Instead of relying on rigid, single-purpose SaaS tools, teams can build custom data applications that fit their exact workflows. Grist is a hybrid database/spreadsheet that combines the flexibility of a spreadsheet with the robustness of a database.

Structuring Your Relational Data

In standard spreadsheets, users can put any data in any cell, which often leads to broken references and chaotic formatting over time. In Grist, columns function like they do in a relational database. Each column has a defined name and data type, ensuring consistency across every record. Under the hood, Grist relies on SQLite, making the document format fully portable and easy to back up. Any tool capable of reading SQLite can extract your text and numeric data from a Grist document.

When deploying for a team, security and visibility are critical. Administrators can control data access down to individual rows, columns, and tables within a document. This fine-grained permissions model ensures that collaborators only see the information they are authorized to access, making it safe to share a single workspace across different departments or external clients.

Building Formulas with Python

One of the standout capabilities of Grist is its formula engine. While traditional spreadsheets rely on proprietary syntax, the platform supports full Python syntax for formulas, including the standard Python library. This enables users to perform complex data transformations, text parsing, and mathematical operations using a language widely known by developers and data analysts.

For environments that require executing untrusted documents or running instances on a shared host, Grist provides strong security measures. You can securely isolate documents running untrusted code using gVisor sandboxing on Linux or Docker. Additional sandboxing options are available for macOS and WebAssembly via Deno and Pyodide, ensuring formula execution remains safely contained.

Integrating and Extending the Platform

A modern data tool must connect easily to the rest of your infrastructure. Grist includes a REST API, webhooks, and an interactive API console for integrations. Whether you need to synchronize data with an external CRM, trigger an automated email when a row is updated, or construct a custom frontend widget to visualize specific metrics, the platform's API and webhook support can handle the task.

Setting Up Grist with Docker

The fastest way to deploy your own instance of the Grist core server is through Docker. The grist-core container image provides a fully functional environment that you can run locally on your workstation or deploy to a production server.

To pull the image and start the container, use the following official commands:

Once the container is running, the application will be accessible via your browser at port 8484. You can optionally configure persistent storage by mounting a local directory to /persist in the container to ensure your documents survive container restarts.