Grist Core | Awesome Repos

gristlabsgrist-core

11,176 stars588 forksTypeScriptApache-2.01 viewwww.getgrist.com

Grist Core

Grist is a relational spreadsheet platform that combines the flexibility of a spreadsheet with the power of a relational database. At its core, it manages structured data across multiple linked tables, using a relational database engine to organize information while providing a familiar grid interface. The platform supports Python-based formulas for complex calculations and data transformations, with automatic recalculation when referenced cells change.

The system is designed for self-hosted deployment, storing data in either portable SQLite files or enterprise-grade PostgreSQL databases. It includes an immutable action-log system that records every document modification, enabling collaborative undo and comprehensive audit history with change attribution. For authentication, Grist integrates with external identity providers using OIDC, SAML, and single sign-on protocols to manage user access and permissions.

Grist offers interactive dashboard creation through drag-and-drop widgets, charts, calendars, and summary tables that can be linked together for coordinated filtering and editing. It includes native form creation for data entry, conditional cell formatting, and cross-table record referencing. The platform also provides an AI formula assistant that translates natural language prompts into spreadsheet formulas by connecting to configurable large language model endpoints.

The system supports external integrations through REST APIs, webhooks, and cloud storage providers like Google Drive for data synchronization and automation. It features a plugin-based widget system for adding custom UI components and building low-code data applications. Deployment is managed through environment variable configuration, with a web-based admin panel for health monitoring and system management.

Features

Data Platforms - Provides a self-hosted relational spreadsheet platform with SQLite or PostgreSQL storage and user authentication.
Data Application Builders - A platform for creating custom data interfaces using a modular plugin system for custom widgets and components.
Relational Spreadsheets - Manages structured data with spreadsheet flexibility and relational database power, including linked tables and Python formulas.
Cross-Table References - Links records in one table to records in another using references, reference lists, and two-way synchronization.
Grid-Based Formula Execution - Executes Python-based logic within cells to perform complex calculations and data transformations.
Document Modification Histories - Logs all document modifications to attribute specific changes to the users who performed them.
Relational Storage Backends - Provides PostgreSQL as a persistent storage backend for relational spreadsheet documents.
Python Data Pipeline Frameworks - Uses Python expressions to perform complex calculations and derive values across related data sets.
Grid-Based Transformations - Performs complex calculations and dynamic data transformations within a grid interface using full Python expressions and libraries.
Relational Data Management - Organizes structured information using a hybrid system that combines spreadsheet flexibility with relational database power.
Relational Database Engines - Combines a relational database engine with a spreadsheet interface to manage structured data across linked tables.
SQLite Storage Adapters - Persists spreadsheet data in portable SQLite files for easy backup and external reading.
Structured Data Management - Combines a relational database with a spreadsheet interface to organize data and calculate values using Python formulas.
Data Application Builders - Builds custom data interfaces and workflows by adding tailored widgets and components through a modular plugin system.
Data Application Builders - A platform for building custom data applications through a plugin system and customizable user interface widgets.
Data Platforms - Provides a self-hosted relational spreadsheet platform with SQLite or PostgreSQL storage and user authentication.
Python - Provides a Python-powered formula engine that evaluates cell expressions with automatic dependency tracking.
Python Formula Evaluators - Provides a Python-powered formula engine that evaluates cell expressions with automatic dependency tracking.
Python Formulas - Writes spreadsheet formulas using full Python syntax and the standard library, with automatic recalculation when referenced cells change.
Formula Locators - Provides a Python-powered formula engine that evaluates cell expressions with automatic dependency tracking.
Document Action Logs - Records every document modification as an immutable action log for auditing and undo.
Document Modification Audits - Maintains detailed records of document modifications attributed to specific users.
External Identity Provider Integration - Verifies user access via OIDC and SAML protocols from external identity providers.
Identity Authentication - Tracks identity and document revisions by connecting to external security providers.
User Identity Verification - Verifies user credentials by connecting to external identity providers via standardized protocols.
Identity Provider Integrations - Verifies user identities and manages access permissions through external authentication protocols.
OIDC Identity Integrations - Verifies user identities via OpenID Connect from external identity providers.
SAML Integrations - Manages user access via OIDC and SAML identity providers for single sign-on.
OIDC Integrations - Verifies user identities via OpenID Connect and SAML protocols from external providers.
Single Sign-On Integrations - Connects to external identity providers using OIDC, SAML, and forward authentication.
Single Sign-On Providers - Integrates with OIDC, SAML, and forward-auth providers for centralized user authentication.
User Access Controls - Manages user identities and tracks revisions by integrating with external security services.
Relational Spreadsheet Cores - Combines database-style structured storage with a spreadsheet interface to manage complex data relationships across multiple tables.
Document Action Logs - Records every document modification as an immutable log for collaborative undo and audit.
Collaborative Document Audits - Tracks all modifications to shared documents with user attribution for accountability.
Plugin-Based Widget Systems - Extends the application interface with custom widgets and components through a modular plugin system for tailored data presentation and workflows.
Identity Provider Integration - Connects to third-party identity providers for user authentication and access permissions.
Formula Generation Assistants - Provides an AI assistant that translates natural language into complex spreadsheet formulas.
Dashboard Layouts - Lays out and links distinct widgets like charts, card views, and calendars to visualize and filter data.
AI-Assisted Formula Generators - Ships an AI assistant that generates spreadsheet formulas from natural language prompts.
Incremental Imports - Adds new records from a CSV file without duplicating existing data, enabling ongoing imports from sources like bank statements.
REST API Integrations - Integrates with external systems through a REST API, interactive console, Zapier actions, and configurable webhooks.
REST APIs - Exposes spreadsheet data programmatically through a REST API with interactive console and webhook support.
Natural Language Synthesis - Translates natural language prompts into spreadsheet formulas via external AI providers.
Functional Extension Bundles - Bundles custom widgets into the application to provide specialized data visualization components.
Plugin-Based Widget Additions - Adds tailored widgets and components to a data interface through a plugin system to meet specific business needs.
Plugin Bundling - Packages visual plugins to serve directly from the application without requiring external dependencies.
Data Entry Forms - Builds forms that feed submissions directly into a spreadsheet with file attachments and URL pre-population.
Form Data Population - Builds forms that feed directly into a spreadsheet, supporting file attachments and URL pre-population.
Conditional Formatting - Controls cell style with formulas to highlight important data based on user-defined conditions.
Interactive Dashboards - Creates visual data displays using drag-and-drop charts, calendars, and linked summary tables.
External API Integrations - Connects to Google Drive, Excel, CSV, REST APIs, webhooks, and custom widgets for data exchange.
REST API Synchronizations - Exposes spreadsheet data programmatically through a REST API with interactive console and webhook support.
Business Operations - Relational spreadsheet for data management.

Open-source alternatives to Grist Core

Similar open-source projects, ranked by how many features they share with Grist Core.

octelium/octelium
octelium/octelium
3,371View on GitHub
Octelium is a zero-trust network access platform and identity-aware proxy designed to secure private HTTP, SSH, and SQL resources. It functions as a secure gateway that validates human and workload identities using OIDC, SAML, and FIDO2 passkeys before granting access to internal applications and SaaS APIs. The system is distinguished by its secretless access broker, which injects credentials—such as API keys, passwords, and AWS Sigv4 signatures—at the gateway level so users can access databases and cloud resources without managing secrets. It further specializes in AI gateway administration,
Goabacai-gatewayapi-gateway
View on GitHub3,371
binarylogic/authlogic
binarylogic/authlogic
4,343View on GitHub
Authlogic is a Ruby authentication framework designed to manage user identities, session persistence, and secure password hashing. It provides a system for verifying user credentials against stored records using configurable identity fields. The framework distinguishes itself through its provider-based identity integration, allowing applications to connect authentication flows to external services including OAuth, OpenID Connect, LDAP, and various social media platforms. It also includes an extensibility model that executes custom user-defined code via hooks and callbacks during identity veri
Ruby
View on GitHub4,343
jhaals/yopass
jhaals/yopass
2,581View on GitHub
Yopass is a secure secret sharing platform used to share encrypted text and files via one-time expiring links. It utilizes client-side encryption to ensure that sensitive data is encrypted in the browser before transmission, preventing the server from seeing plain text. The platform differentiates itself through an integrated security auditing system that generates structured logs and triggers cryptographically signed webhooks when secrets are created, viewed, or expired. It also features an access control system based on OpenID Connect, allowing administrators to restrict secret creation and
TypeScriptencryption-decryptionhacktoberfestpassword-sharing
View on GitHub2,581
davidfowl/todoapp
davidfowl/TodoApp
3,104View on GitHub
TodoApp is a task management web application designed for organizing and tracking pending items. It consists of a web-based interface and a REST API backend that handles business logic and data requests. The system includes an OAuth 2.0 identity provider for user authentication via passwords and external social providers, as well as an API gateway proxy that routes traffic from the frontend to the backend to prevent cross-origin resource sharing issues. Operational capabilities cover system observability through OpenTelemetry for collecting logs and metrics, request rate limiting to maintain
C#aspnetcoreauthenticationblazor
View on GitHub3,104

See all 30 alternatives to Grist Core

Grist Core

Features

Open-source alternatives to Grist Core

octelium/octelium

binarylogic/authlogic

jhaals/yopass

davidfowl/TodoApp

Star history

Open-source alternatives to Grist Core

octelium/octelium

binarylogic/authlogic

jhaals/yopass

davidfowl/TodoApp