NocoDB: Creating Smart Tables on Multiple Databases, Open Source Airtable Alternative

General Introduction

NocoDB is an open source Airtable alternative designed to provide a powerful and easy-to-use online database management tool. With NocoDB, users can easily create, read, update, and delete data from databases without writing code. The platform supports a wide range of database types, including MySQL, PostgreSQL, SQLite, etc., and is suitable for a variety of business needs.

Grid View

Kanban view

Gallery View

form view

Function List

• Rich spreadsheet interface : provide a spreadsheet-like interface , support for basic CRUD operations .
• Multiple view types: Grid view, Gallery view, Form view, Kanban view and Calendar view are supported.
• Field operations : support for sorting , filtering , grouping , hide / show columns and other operations .
• Access Control : Provides fine-grained access control and supports role management.
• Shared View : Supports public or private (password protected) view sharing.
• Multiple cell types : support for ID, link, find, summarize, single-line text, attachments, currency, formulas, users and other cell types.
• Workflow Automation : Provides multiple integrations with support for Slack, Discord, AWS S3 and more.
• Programming access : Provide REST API and NocoDB SDK, convenient for users to make programmatic calls.

Using Help

Installation process

1. Installation using Docker :
   • SQLite :

   docker run -d --name noco -v "$(pwd)/nocodb:/usr/app/data/"-p 8080:8080 nocodb/nocodb:latest
   

   • PostgreSQL :

   docker run -d --name noco -v "$(pwd)/nocodb:/usr/app/data/"-p 8080:8080 -e NC_DB="pg://host.docker.internal:5432?u=root&p=password&d=d1"-e NC_AUTH_JWT_SECRET="569a1821-0a93-45e8-87ab-eb857f20a010"nocodb/nocodb:latest
   

2. Automatic installation :

bash <(curl -sSL http://install.nocodb.com/noco.sh) <(mktemp)

Docker One-Click Deployment

# using SQLite as database
docker run -d --name noco
-v "$(pwd)"/nocodb:/usr/app/data/
-p 8080:8080
nocodb/nocodb:latest

# using PostgreSQL as database
docker run -d --name noco
-v "$(pwd)"/nocodb:/usr/app/data/
-p 8080:8080
# replace with your pg connection string
-e NC_DB="pg://host.docker.internal:5432?u=root&p=password&d=d1"
# replace with a random secret
-e NC_AUTH_JWT_SECRET="569a1821-0a93-45e8-87ab-eb857f20a010"
nocodb/nocodb:latest

Docker-Compose Deployment

# Enable PG as data by default
#Clone the NocoDB repository from GitHub.
git clone https://github.com/nocodb/nocodb

#Navigate to the docker-compose directory
cd nocodb/docker-compose/pg

#Start the services using Docker Compose.
docker-compose up -d

Usage Process

1. To access the local server: Open the http://localhost:8080/dashboardThe
2. Create a new project : After logging in, click the "New Project" button and select the desired database type and template.
3. Manage Data : Create, read, update and delete data in the spreadsheet interface.
4. Configure Views : Select different view types according to your needs and sort, filter and group fields.
5. Set access rights: Set access rights for different user roles to ensure data security.
6. Shared View : Sets the view as public or private and generates a shared link.
7. Integrated Workflow : Automate workflow by integrating with tools such as Slack, Discord, etc.
8. Programmatic calls : Programmatic calls and automated operations using the provided REST API and NocoDB SDK.

Advanced Features

• Multi-view support: Select different view types according to project requirements to enhance the flexibility of data management.
• Fine-grained access control: Set access rights for different user roles to ensure data security.
• Workflow Automation : Automate and efficiently manage workflows by integrating multiple tools.
• Programming access : Provide REST API and NocoDB SDK, convenient for users to make programmatic calls and automated operations.

The layman's guide to getting started with AI

Help you learn how to utilize AI tools at a low cost and from a zero base.AI, like office software, is an essential skill for everyone. Mastering AI will give you an edge in your job search and half the effort in your future work and studies.

View Details>