gristlabs/grist-core

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.

Star history