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/open-source-smart-table-maker/

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

Ordering Process

1. Automatic: After making an online payment, click the (Download) link to download the source code; 2. Manual: Contact the seller or the official to check if the template is consistent. Then, place an order and make payment online. The seller ships the goods, and both parties inspect and confirm that there are no issues. ICTcoder will then settle the payment for the seller. Note: Please ensure to place your order and make payment through ICTcoder. If you do not place your order and make payment through ICTcoder, and the seller sends fake source code or encounters any issues, ICTcoder will not assist in resolving them, nor can we guarantee your funds!

View details

Transactions and Disputes

1. Default transaction cycle for source code: The seller manually ships the goods within 1-3 days. The amount paid by the user will be held in escrow by ICTcoder until 7 days after the transaction is completed and both parties confirm that there are no issues. ICTcoder will then settle with the seller. In case of any disputes, ICTcoder will have staff to assist in handling until the dispute is resolved or a refund is made! If the buyer places an order and makes payment not through ICTcoder, any issues and disputes have nothing to do with ICTcoder, and ICTcoder will not be responsible for any liabilities!

View details

Matters needing attention

1. ICTcoder will permanently archive the transaction process between both parties and snapshots of the traded goods to ensure the authenticity, validity, and security of the transaction! 2. ICTcoder cannot guarantee services such as "permanent package updates" and "permanent technical support" after the merchant's commitment. Buyers are advised to identify these services on their own. If necessary, they can contact ICTcoder for assistance; 3. When both website demonstration and image demonstration exist in the source code, and the text descriptions of the website and images are inconsistent, the text description of the image shall prevail as the basis for dispute resolution (excluding special statements or agreements); 4. If there is no statement such as "no legal basis for refund" or similar content, any indication on the product that "once sold, no refunds will be supported" or other similar declarations shall be deemed invalid; 5. Before the buyer places an order and makes payment, the transaction details agreed upon by both parties via WhatsApp or email can also serve as the basis for dispute resolution (in case of any inconsistency between the agreement and the description of the conflict, the agreement shall prevail); 6. Since chat records and email records can serve as the basis for dispute resolution, both parties should only communicate with each other through the contact information left on the system when contacting each other, in order to prevent the other party from denying their own commitments. 7. Although the probability of disputes is low, it is essential to retain important information such as chat records, text messages, and email records, in case a dispute arises, so that ICTcoder can intervene quickly.

View details

ICTcoder reminds and declares

1. As a third-party intermediary platform, ICTcoder solely protects transaction security and the rights and interests of both buyers and sellers based on the transaction contract (product description, agreed content before the transaction); 2. For online trading projects not on the ICTcoder platform, any consequences are unrelated to this platform; regardless of the reason why the seller requests an offline transaction, please contact the administrator to report.

View details