nocodb is not only an interface management tool for data management, but also can convert data such as databases and images into tables and display, and also provides team collaboration, workflow access, and more open API services. Allowing the team to work on the data truly shows that the data is at hand. nocodb can convert any MySQL, PostgreSQL, SQL Server, SQLite, and MariaDB into a smart spreadsheet.

Two. Get started quickly

1. Use Docker

docker run -d --name nocodb -p 8080:8080 nocodb/nocodb

Retention data can be done under /usr/app/data/

2. Use Npm

npx create-nocodb-app

3. Use Git

git clone https://github.com/nocodb/nocodb-seedcd nocodb-seednpm installnpm start

3. NocoDB features

NocoDB has a rich spreadsheet interface that supports the following types

1. Easily search, sort, filter, hide columns

2. Create views: grids, galleries, kanban boards, Gantt charts, forms

3. Shared Views: Public & Password Protected

4. Upload image to cell (for S3, Minio, GCP, Azure, DigitalOcean, Linode, OVH, BackBlaze)

5. Roles: Owner, Creator, Editor, Commenter, Viewer, Commenter, Custom Role

6. Access control: There is fine-grained access control even at the database, table, and column level

nocodb can also be used in process work software, such as WeChat, SMS, email, and supports a variety of API methods.

NocoDB support

REST API (Swagger) access.

GraphQL API.

Includes JWT authentication and social authentication access.

API token access integrated with Zapier and Integromat.

Four. Related setting information

NocoDB requires a database to store metadata for spreadsheet views and external databases. The connection parameters for this database can be specified in NC_DB environment variables.

Example: Mysql

docker run -d -p 8080:8080 \    -e NC_DB="mysql2://host.docker.internal:3306?u=root&p=password&d=d1" \    -e NC_AUTH_JWT_SECRET="569a1821-0a93-45e8-87ab-eb857f20a010" \    nocodb/nocodb

Environment variables: For more information, see Introduction to Git

Development settings

git clone https://github.com/nocodb/nocodbcd nocodb# run backendcd packages/nocodbnpm installnpm run watch:run# open localhost:8080/dashboard in browser# run frontend cd packages/nc-guinpm installnpm run dev# open localhost:3000/dashboard in browser

The purpose of developers to build this is still very clear, and we use spreadsheets or databases to solve business needs in many places in our lives and work. However, the speed of working on databases is nowhere near the speed of a graphical interface, and trying to solve problems with other SaaS products means constant expense and instability, so open-sourcing a project like this is undoubtedly a help for everyone助。

资源下载此资源为免费资源立即下载

Telegram:@John_Software

collect(0) Like (0)

Disclaimer: This article is published by a third party and represents the views of the author only and has nothing to do with this website. This site does not make any guarantee or commitment to the authenticity, completeness and timeliness of this article and all or part of its content, please readers for reference only, and please verify the relevant content. The publication or republication of articles by this website for the purpose of conveying more information does not mean that it endorses its views or confirms its description, nor does it mean that this website is responsible for its authenticity.

Ictcoder Free source code Open-source smart table maker https://ictcoder.com/kyym/open-source-smart-table-maker.html

lllll

Share free open-source source code

Previous article： Zero-code interface and document ORM library - APIJSON

Next article： Back-end permission management system (Node.js+midway.js-based)

Q&A

What is the delivery method?

1, automatic: after taking the photo, click the (download) link to download; 2. Manual: After taking the photo, contact the seller to issue it or contact the official to find the developer to ship.

View details

How long is the trading cycle?

1, the default transaction cycle of the source code: manual delivery of goods for 1-3 days, and the user payment amount will enter the platform guarantee until the completion of the transaction or 3-7 days can be issued, in case of disputes indefinitely extend the collection amount until the dispute is resolved or refunded!

View details

Matters needing attention

1. Heptalon will permanently archive the process of trading between the two parties and the snapshots of the traded goods to ensure that the transaction is true, effective and safe! 2, Seven PAWS can not guarantee such as "permanent package update", "permanent technical support" and other similar transactions after the merchant commitment, please identify the buyer; 3, in the source code at the same time there is a website demonstration and picture demonstration, and the site is inconsistent with the diagram, the default according to the diagram as the dispute evaluation basis (except for special statements or agreement); 4, in the absence of "no legitimate basis for refund", the commodity written "once sold, no support for refund" and other similar statements, shall be deemed invalid; 5, before the shooting, the transaction content agreed by the two parties on QQ can also be the basis for dispute judgment (agreement and description of the conflict, the agreement shall prevail); 6, because the chat record can be used as the basis for dispute judgment, so when the two sides contact, only communicate with the other party on the QQ and mobile phone number left on the systemhere, in case the other party does not recognize self-commitment. 7, although the probability of disputes is very small, but be sure to retain such important information as chat records, mobile phone messages, etc., in case of disputes, it is convenient for seven PAWS to intervene in rapid processing.

View details

Systemhere declaration

1. As a third-party intermediary platform, Qichou protects the security of the transaction and the rights and interests of both buyers and sellers according to the transaction contract (commodity description, content agreed before the transaction); 2, non-platform online trading projects, any consequences have nothing to do with mutual site; No matter the seller for any reason to require offline transactions, please contact the management report.

View details