Back to Blog
team@tinypod.app

Self-Hosting Grist: Open-Source Spreadsheet Database

Grist combines spreadsheets with databases. Formulas like a spreadsheet, structure like a database, and Python for custom logic.

gristspreadsheetdatabaseno-code

What Is Grist?


Grist is an open-source tool that combines the familiarity of spreadsheets with the power of databases. It looks like Excel but works like a database.


Features


Spreadsheet Interface

  • Familiar grid view
  • Formulas (spreadsheet-style)
  • Cell formatting
  • Sorting and filtering

    • Database Structure

  • Tables with typed columns
  • References (foreign keys)
  • Lookups across tables
  • Computed columns

    • Views

  • Grid (spreadsheet)
  • Card (record detail)
  • Chart
  • Custom widgets
  • Calendar (with date columns)

    • Python Formulas

    Formulas in Grist use Python, not Excel syntax:

    python

    len($Items)

    $Price * $Quantity

    sum(Table.lookupRecords(status='active').amount)


    Access Control

  • Row-level access rules
  • Column-level access rules
  • View-based permissions
  • Share with specific users

    • Grist vs Airtable vs Google Sheets


  • Grist: Python formulas, self-hosted, most powerful logic
  • Airtable: Best UI, SaaS, most views
  • Google Sheets: Simplest, collaborative, limited structure

    • When to Choose Grist


  • You need complex formulas (Python is more powerful than Excel)
  • You need row-level access control
  • You want self-hosted with database features
  • You need computed views with custom widgets

    • Deployment


    1. Deploy Grist on TinyPod

    2. Create a document

    3. Define tables and columns

    4. Write formulas

    5. Build views


    Resources: 1 CPU, 512 MB RAM.


    Grist bridges the gap between spreadsheets and databases. If your data outgrew Google Sheets but doesn't need a full database, Grist is perfect.