Apitable
๐๐๐ APITable, an API-oriented low-code platform for building collaborative apps and better than all other Airtable open-source alternatives.
Install / Use
/learn @apitable/ApitableREADME
โจ Quick Start
If you just want to try out APITable[^info], use our cloud-hosted AI version at aitable.ai.
If you want to demo this APITable open-source project, click here for โก๏ธGitpod Online Demo.
If you want to try the self-hosted APITable, ๐ one-click deploy with Dome here
If you want to install APITable in your local or cloud computing environment, see ๐พ Installation
If you want to set up your local development environment, read our ๐งโ๐ป Developer Guide
Join Discord or Twitter to keep in touch.
๐ฅ Features
<table> <tr> <th> <a href="#">Realtime Collaboration</a> </th> <th> <a href="#">Automatic Form</a> </th> </tr> <tr> <td width="50%"> <a href="#"> <img src="docs/static/feature-realtime.gif" /> </a> </td> <td width="50%"> <a href="#"> <img src="docs/static/feature-form.gif" /> </a> </td> </tr> <tr> <th> <a href="#">API-first Panel</a> </th> <th> <a href="#">Unlimited cross-table links</a> </th> </tr> <tr> <td width="50%"> <a href="#"> <img src="docs/static/feature-api-first-panel.gif" /> </a> </td> <td width="50%"> <a href="#"> <img src="docs/static/feature-unlimited-cross-table-links.gif" /> </a> </td> </tr> <tr> <th> <a href="#">Powerful Rows/Columns Permissions</a> </th> <th> <a href="#">Embed</a> </th> </tr> <tr> <td width="50%"> <a href="#"> <img src="docs/static/feature-permissions.gif" /> </a> </td> <td width="50%"> <a href="#"> <img src="docs/static/feature-embed.gif" /> </a> </td> </tr> </table>APITable provides a range of amazing features, from the personal to the enterprise.
- Advanced technology stack and open-source
Realtime collaborationallows multiple users to edit together in real time, or simultaneously with theOperational Transformation (OT)Algorithm.- Extremely smooth, user-friendly, super-fast database-spreadsheet interface in
<canvas> Rendering Engine. - Database native architecture: Changeset / Operation / Action / Snapshot and so on.
- 100k+ data rows with real-time collaboration.
- Full-stack API access, from
DatatoMetadata. - One-direction / Bi-direction Table Link and
Infinite Cross Links - Community-friendly programming languages and framework, TypeScript (NextJS + NestJS) and Java (Spring Boot).
- Beautiful and Rich Database-Spreadsheet UI
CRUD: Create, Read, Update, Delete the Tables, Columns, and RowsFields Operations: sort, filter, grouping, hide/unhide, height setting.Space based: Use separated workspaces in place of App/Base-based structure, make unlimited tables link together possible.Dark modeand theme customization available.7 View Types: Grid View (Datasheet) / Gallery View / Mindmap View / Kanban View / Full-Feature Gantt View / Calendar View- One-click API Panel
- Batteries included
- Built-in 10+ official templates.
- Robot Automation and customization available.
- BI dashboard
- One-click auto-generated form
- Shareable and embeddable page.
- Multi-language support.
- Integration with n8n.io / Zapier / Appsmith... and more.
- Excellent extensibility
- Extensible
Widget Systemwith over 20 officials open-source widgets. - Customizable Graph & Chart & Dashboard
- Customizable Data Column Types
- Customizable Formulas
- Customizable Automation Robot Actions.
- Extensible
- Enterprise-grade permissions
Mirror, turn a View into a mirror to implement Row Permission.- Activate
Column Permissionthrough a very simple operation. - Folders / Sub-Folders / Files Permission.
- Tree structure folders and customizable node (file);
- Team Management & Organization Structure.
- Enterprise features:
- SAML
- Single-Sign-On (SSO)
- Audit
- Database Auto Backup
- Data Exporter
- Watermark
- ....
With extensible widgets and plugins, you can add more features.
๐ฅ Use Cases
Why you must know APITable for your next software?
- As super management software
- Flexible Project Management & Tasks / Issues Management.
- Marketing Lead Management.
- Most flexible and connectable CRM.
- Flexible Business Intelligence (BI).
- People-Friendly Forms and Surveys
- Flexible ERP.
- Low-code and no-code platform.
- ...and more, APITable puts 1000 softwares in your pocket.
- As a visual database infrastructure
- Embed APITable into your own software UIs.
- Visual Database with REST API.
- Admin dashboard.
- Central configuration management.
- All-in-one enterprise database that connect all your software.
- ...and more, APITable connects everything.
- Also, it is open source and extensible
๐ API-oriented
API UI Panel
Clicking the API button in the right corner will show the API Panel
SQL-like query
APITable will provides a Datasheet Query Language (DQL) to query your database-spreadsheet contents.
๐ Embed-friendly
Share and Embed
Share your datasheet table or folder. Embed them by copying and pasting HTML scripts.
Enterprise-ready Embedding
AITable.ai provides more Enterprise-ready Embedding features for securities.
Installation
Before you begin:
- A host with docker and docker-compose v2 installed.
- 4 CPUs/8GB RAM or more are recommended.
- A bash shell with basic utilities like curl installed.
- Native arm64 (apple silicon) container images is not ready yet and may cause bad performance.
To install apitable using docker compose, open your terminal and run this:
curl https://apitable.github.io/install.sh | bash
Then open http://localhost:80 in your browser to visit it.
We also provide an all-in-one image based on pm2 for demo or testing purpose (not recommended for enterprise or production usage):
sudo docker run -d -v ${PWD}/.data:/apitable -p 80:80 --name apitable apitable/all-in-one:latest
Depending on your environment, you may need to wait several minutes for all the services to start. This image is amd64 (x86_64) only, you may encounter pretty bad performance on arm64 or apple silicon.
If you want to set up your local development environment, read our ๐งโ๐ป Developer Guide
๐งโ๐ป Contributing
Welcome, and thank you for your interest in contributing to APITable!
In addition to writing code, there ar
