Teable is a no-code platform designed for managing data and building applications with a spreadsheet-like interface, targeting both non-technical users and developers. It aims to provide a flexible, scalable, and collaborative alternative to existing no-code solutions, enabling real-time data management and application creation without vendor lock-in.

How It Works

Teable leverages a PostgreSQL backend for robust data handling and scalability, supporting millions of rows. The architecture comprises a Next.js frontend for a responsive user interface and a NestJS backend for API services. It offers multiple data visualization views (Grid, Form, Kanban, Gallery, Calendar) and includes features like real-time collaboration, formula support, and a plugin system for extensibility. This approach combines the ease of use of spreadsheets with the power of a relational database and a flexible architecture.

Quick Start & Requirements

• Self-hosting: docker-compose up -d within the dockers/examples/standalone/ directory.
• Prerequisites: Docker, pnpm, Node.js. Supports SQLite (dev only) and PostgreSQL.
• Development: Requires pnpm install, make switch-db-mode, and running pnpm dev in apps/nestjs-backend. Plugin development requires pnpm dev in the plugins directory.
• Demo: A 1 million rows demo is available at teable.io.
• Documentation: Quick Guide, Help, Blog, Roadmap are linked in the README.

Highlighted Details

• Supports millions of rows with high performance.
• Offers multiple data views: Grid, Form, Kanban, Gallery, Calendar.
• Extensible via a plugin system.
• Includes features like real-time collaboration, formulas, and SQL query support.

Maintenance & Community

• Active development with a public roadmap.
• Community support via Discord and Twitter.
• Links to official documentation, templates, and API are provided.

Licensing & Compatibility

• Community Edition (CE) is licensed under AGPL 3.0 for self-hosting.
• Enterprise Edition (EE) offers advanced features and requires a commercial license.
• AGPL 3.0 may have implications for linking with closed-source applications.

Limitations & Caveats

The project structure indicates the frontend is AGPL 3.0 licensed, while the core packages are MIT licensed. The AGPL license for the apps and plugins directories may impose copyleft requirements on derivative works or linked applications.