base on ✨ The Next Gen Airtable Alternative: No-Code Postgres <div align="center"> <h1 align="center"> <picture> <source media="(prefers-color-scheme: dark)" srcset="static/assets/images/teable-vertical-dark.png"> <img alt="teable logo" height="150" src="static/assets/images/teable-vertical-light.png"> </picture> </h1> <h3 align="center"><strong>Manage Your Data & Connect Your Team</strong></h3> <p>Teable uses a simple, spreadsheet-like interface to create powerful database applications. Collaborate with your team in real-time, and scale to millions of rows <p>Try out Teable using our hosted version at <a href="https://teable.io">teable.io</a></p> </div> <div align="center"> <a href="https://trendshift.io/repositories/8516" target="_blank"><img src="https://trendshift.io/api/badge/repositories/8516" alt="teableio%2Fteable | Trendshift" style="width: 250px; height: 55px;" width="250" height="55"/></a> </div> <p align="center"> <a target="_blank" href="https://teable.io">Home</a> | <a target="_blank" href="https://help.teable.io">Help</a> | <a target="_blank" href="https://Blog.teable.io">Blog</a> | <a target="_blank" href="https://template.teable.io">Template</a> | <a target="_blank" href="https://help.teable.io/developer/api">API</a> | <a target="_blank" href="https://app.teable.io/share/shr04TEw1u9EOQojPmG/view">Roadmap</a> | <a target="_blank" href="https://discord.gg/uZwp7tDE5W">Discord</a> | <a target="_blank" href="https://twitter.com/teableio">Twitter</a> </p> <p align="center"> <a aria-label="Build" href="https://github.com/teableio/teable/actions?query=Build%20and%20Push%20to%20Docker%20Registry"> <img alt="build" src="https://img.shields.io/github/actions/workflow/status/teableio/teable/docker-push.yml?label=Build&logo=github&style=flat-quare&labelColor=000000" /> </a> <a aria-label="Codefactor grade" href="https://www.codefactor.io/repository/github/teableio/teable"> <img alt="Codefactor" src="https://img.shields.io/codefactor/grade/github/teableio/teable?label=Codefactor&logo=codefactor&style=flat-quare&labelColor=000000" /> </a> <a aria-label="Coverage Status" href="https://coveralls.io/github/teableio/teable?branch=develop"> <img alt="Coverage" src="https://coveralls.io/repos/github/teableio/teable/badge.svg?branch=develop" /> </a> <a aria-label="CodeClimate technical debt" href="https://codeclimate.com/github/teableio/teable"> <img alt="Techdebt" src="https://img.shields.io/codeclimate/tech-debt/teableio/teable?label=TechDebt&logo=code-climate&style=flat-quare&labelColor=000000" /> </a> <a aria-label="Codacy grade" href="https://www.codacy.com/gh/teableio/teable/dashboard?utm_source=github.com&amp;utm_medium=referral&amp;utm_content=teableio/teable&amp;utm_campaign=Badge_Grade"> <img alt="Codacy grade" src="https://img.shields.io/codacy/grade/dff9c944af284a0fad4e165eb1727467?logo=codacy&style=flat-square&labelColor=000&label=Codacy"> </a> <a aria-label="Top language" href="https://github.com/teableio/teable/search?l=typescript"> <img alt="GitHub top language" src="https://img.shields.io/github/languages/top/teableio/teable?style=flat-square&labelColor=000&color=blue"> </a> <a aria-label="Gurubase" href="https://gurubase.io/g/teable"> <img alt="Gurubase" src="https://img.shields.io/badge/Gurubase-Ask%20Teable%20Guru-006BFF" /> </a> </p> <h1 align="center"> <picture> <source media="(prefers-color-scheme: dark)" srcset="static/assets/images/teable-interface-dark.png"> <img alt="teable interface" width="100%" src="static/assets/images/teable-interface-light.png"> </picture> </h1> ## Quick Guide 1. Looking for a quick experience? Select a scenario from the [template center](https://template.teable.io) and click "Use this template". 2. Seeking high performance? Try the [1 million rows demo](https://app.teable.io/share/shrVgdLiOvNQABtW0yX/view) to feel the speed of Teable. 3. Want to learn to use it quickly? Click on this [tutorial](https://help.teable.io/quick-start/build-a-simple-base) 4. Interested in deploying it yourself? Click [Deploy on Railway](https://railway.app/template/wada5e?referralCode=rE4BjB) ## ✨Features #### 🍺 Feature Packed Everything you need, right out of the box: - [x] Aggregation - [x] Attachments preview - [x] Batch Editing - [x] Charts - [x] Comments - [x] Custom Columns - [x] Field conversion - [x] Filtering - [x] Formatting - [x] Formula Support - [x] Grouping - [x] History - [x] Import/Export - [x] Millions of rows - [x] Plugins - [x] Real-time - [x] Search - [x] Sorting - [x] SQL Query - [x] Undo/Redo - [x] Validation #### 🏞️ Multiple Views Visualize and interact with data in various ways best suited for their specific tasks. - [x] Grid View - [x] Form View - [x] Kanban View - [x] Gallery View - [x] Calendar View <table align="center" style="width: 100%;"> <tr> <td width="50%"><img alt="Grid View" src="static/assets/images/view-grid.png"></td> <td width="50%"><img alt="Search" src="static/assets/images/search.png"></td> </tr> <tr> <td width="50%"><img alt="Calendar View" src="static/assets/images/view-calendar.png"></td> <td width="50%"><img alt="Gallery View" src="static/assets/images/view-gallary.png"></td> </tr> <tr> <td width="50%"><img alt="Kanban View" src="static/assets/images/view-kanban.png"></td> <td width="50%"><img alt="Form View" src="static/assets/images/view-form.png"></td> </tr> <tr> <td width="50%"><img alt="Comments" src="static/assets/images/comments.png"></td> <td width="50%"><img alt="Record history" src="static/assets/images/record-history.png"></td> </tr> </table> #### 📊 Charts & Dashboard <img alt="Teable Dashboard" width="100%" src="static/assets/images/dashboard.png"> More features coming soon, see our <a target="_blank" href="https://app.teable.io/share/shr04TEw1u9EOQojPmG/view">Roadmap</a> --- # Structure [](https://gitpod.io/#https://github.com/teableio/teable) ``` . ├── apps (AGPL 3.0) │ ├── nextjs-app (front-end) │ └── nestjs-backend (backend) ├── packages (MIT) │ ├── common-i18n (locales) │ ├── core (share code and interface) │ ├── sdk (sdk for extensions) │ ├── db-main-prisma (schema, migrations, prisma client) │ ├── eslint-config-bases (to shared eslint configs) │ └── ui-lib (ui component) └── plugins (AGPL 3.0) (custom plugins) ``` ## Deploy ### Deploy With Docker ```sh cd dockers/examples/standalone/ docker-compose up -d ``` for more details, see [install teable](https://help.teable.io/deployment/docker-compose) ### One Click Deployment These platforms are easy to deploy with one click and come with free credits. [](https://railway.app/template/wada5e?referralCode=rE4BjB) [](https://zeabur.com/templates/QF8695) [](https://cloud.sealos.io/?openapp=system-template%3FtemplateName%3Dteable) [](https://repocloud.io/details/?app_id=273) [](https://elest.io/open-source/teable) [](https://computenest.console.aliyun.com/service/instance/create/default?ServiceName=Teable%20%E7%A4%BE%E5%8C%BA%E7%89%88) ## Development #### 1. Initialize ```sh # Enabling the Help Management Package Manager corepack enable # Install project dependencies pnpm install ``` #### 2. Select Database we currently support `sqlite` (dev only) and `postgres`, you can switch between them by running the following command ```sh make switch-db-mode ``` #### 3. Custom Environment Variables（Optional） ```sh cd apps/nextjs-app copy .env.development .env.development.local ``` #### 4. Run Dev Server you just need to start backend, it will start next server for frontend automatically, file change will be auto reload ```sh cd apps/nestjs-backend pnpm dev ``` ## Why Teable? No-code tools have significantly speed up how we get things done, allowing non-tech users to build amazing apps and changing the way many work and live. People like using spreadsheet-like UI to handle their data because it's easy, flexible, and great for team collaboration. They also prefer designing their app screens without being stuck with clunky templates. Giving non-techy people the ability to create their software sounds exciting. But that's just the start: - As businesses expand, their data needs intensify. No one wishes to hear that once their orders reach 100k, they'll outgrow their current interface. Yet, many no-code platforms falter at such scales. - Most no-code platforms are cloud-based. This means your important data sits with the provider, and switching to another platform can be a headache. - Sometimes, no-code tools can't do what you want because of their limitations, leaving users stuck. - If a tool becomes essential, you'll eventually need some tech expertise. But developers often find these platforms tricky. - Maintaining systems with complex setups can be hard for developers, especially if these aren't built using common software standards. - Systems that don't use these standards might need revamping or replacing, costing more in the long run. It might even mean ditching the no-code route and going back to traditional coding. #### What We Think the Future Of No-code Products Look Like - An interface that anyone can use to build applications easily. - Easy access to data, letting users grab, move, and reuse their information as they wish. - Data privacy and choice, whether that's in the cloud, on-premise, or even just on your local. - It needs to work for developers too, not just non-tech users. - It should handle lots of data, so it can grow with your business. - Flexibility to integrate with other software, combining strengths to get the job done. - Last, native AI integration to takes usability to the next level. In essence, Teable isn't just another no-code solution, it's a comprehensive answer to the evolving demands of modern software development, ensuring that everyone, regardless of their technical proficiency, has a platform tailored to their needs. # License ### Editions Teable Community Edition (CE) is the current available version, it's free for self-host under the AGPL license. Teable Enterprise Edition (EE) is yet to be published, it will have more advanced features and enterprise-oriented offerings, including but not exclusive to authority matrix, automation, advanced admin and audit, etc., you may refer to https://help.teable.io/deployment/docker-compose for more information See [./LICENSE](./LICENSE) for details. ", Assign "at most 3 tags" to the expected json: {"id":"8516","tags":[]} "only from the tags list I provide: [{"id":77,"name":"3d"},{"id":89,"name":"agent"},{"id":17,"name":"ai"},{"id":54,"name":"algorithm"},{"id":24,"name":"api"},{"id":44,"name":"authentication"},{"id":3,"name":"aws"},{"id":27,"name":"backend"},{"id":60,"name":"benchmark"},{"id":72,"name":"best-practices"},{"id":39,"name":"bitcoin"},{"id":37,"name":"blockchain"},{"id":1,"name":"blog"},{"id":45,"name":"bundler"},{"id":58,"name":"cache"},{"id":21,"name":"chat"},{"id":49,"name":"cicd"},{"id":4,"name":"cli"},{"id":64,"name":"cloud-native"},{"id":48,"name":"cms"},{"id":61,"name":"compiler"},{"id":68,"name":"containerization"},{"id":92,"name":"crm"},{"id":34,"name":"data"},{"id":47,"name":"database"},{"id":8,"name":"declarative-gui "},{"id":9,"name":"deploy-tool"},{"id":53,"name":"desktop-app"},{"id":6,"name":"dev-exp-lib"},{"id":59,"name":"dev-tool"},{"id":13,"name":"ecommerce"},{"id":26,"name":"editor"},{"id":66,"name":"emulator"},{"id":62,"name":"filesystem"},{"id":80,"name":"finance"},{"id":15,"name":"firmware"},{"id":73,"name":"for-fun"},{"id":2,"name":"framework"},{"id":11,"name":"frontend"},{"id":22,"name":"game"},{"id":81,"name":"game-engine "},{"id":23,"name":"graphql"},{"id":84,"name":"gui"},{"id":91,"name":"http"},{"id":5,"name":"http-client"},{"id":51,"name":"iac"},{"id":30,"name":"ide"},{"id":78,"name":"iot"},{"id":40,"name":"json"},{"id":83,"name":"julian"},{"id":38,"name":"k8s"},{"id":31,"name":"language"},{"id":10,"name":"learning-resource"},{"id":33,"name":"lib"},{"id":41,"name":"linter"},{"id":28,"name":"lms"},{"id":16,"name":"logging"},{"id":76,"name":"low-code"},{"id":90,"name":"message-queue"},{"id":42,"name":"mobile-app"},{"id":18,"name":"monitoring"},{"id":36,"name":"networking"},{"id":7,"name":"node-version"},{"id":55,"name":"nosql"},{"id":57,"name":"observability"},{"id":46,"name":"orm"},{"id":52,"name":"os"},{"id":14,"name":"parser"},{"id":74,"name":"react"},{"id":82,"name":"real-time"},{"id":56,"name":"robot"},{"id":65,"name":"runtime"},{"id":32,"name":"sdk"},{"id":71,"name":"search"},{"id":63,"name":"secrets"},{"id":25,"name":"security"},{"id":85,"name":"server"},{"id":86,"name":"serverless"},{"id":70,"name":"storage"},{"id":75,"name":"system-design"},{"id":79,"name":"terminal"},{"id":29,"name":"testing"},{"id":12,"name":"ui"},{"id":50,"name":"ux"},{"id":88,"name":"video"},{"id":20,"name":"web-app"},{"id":35,"name":"web-server"},{"id":43,"name":"webassembly"},{"id":69,"name":"workflow"},{"id":87,"name":"yaml"}]" returns me the "expected json"