NocoDB is an open source Airtable alternative that instantly also generates REST APIs on any MySQL database!
For this example :
We will be using a fairly large mysql database (close to 400 tables) as input to NocoDB and create REST APIs automatically.
Without further ado-lets get into the gist of things.
Pre-requisites
- Node.js or Docker
- An existing MySQL database
Getting started
Using npx
npx create-nocodb-app
Using Docker
docker run -d --name nocodb -p 8080:8080 nocodb/nocodb
Now, let's see a quick demo
In the demo, NocoDB automatically first inferred the database schema then generated REST APIs for each table-and-relation with Swagger documentation! All of this was without write a single line of code.
Where can I find more details about NocoDB ?
NocoDB
🎃 The Open Source Airtable Alternative 🎃
Turns any MySQL, PostgreSQL, SQL Server, SQLite & MariaDB into a smart-spreadsheet
Quick try
1-Click Deploy
Heroku
Using Docker
docker run -d --name nocodb -p 8080:8080 nocodb/nocodb:latest
To persist data you can mount volume at
/usr/app/data/
.
Using Npm
npx create-nocodb-app
Using Git
git clone https://github.com/nocodb/nocodb-seed
cd nocodb-seed
npm install
npm start
GUI
Access Dashboard using : http://localhost:8080/dashboard
Join Our Community
Screenshots
Features
Rich Spreadsheet Interface
-
⚡ Search, sort, filter, hide columns with uber ease -
⚡ Create Views : Grid, Gallery, Kanban, Gantt, Form -
⚡ Share Views : public & password protected -
⚡ Personal & locked Views -
⚡ Upload images to cells (Works with S3, Minio, GCP, Azure, DigitalOcean, Linode, OVH, BackBlaze) -
⚡ Roles : Owner, Creator, Editor, Viewer, Commenter, Custom Roles. -
⚡ Access Control : Fine-grained access control even at database, table & column level.
App
…Does NocoDB support other databases ?
Yes - we do!
NocoDB does support all of the below databases :
- Postgres
- SQL-server
- SQLite
- MySQL & MariaDB.
Please join our community
- 📣 Github : https://github.com/nocodb/nocodb
- 📣 Docs : https://docs.nocodb.com
- 📣 Discord : https://discord.gg/5RgZmkW
- 📣 Twitter : https://twitter.com/nocodb
FAQs
- Is authentication built in ? Yes
- Is ACL built in ? Yes
- Is collaboration built in ? Yes
- Are webhooks built in ? Yes
- Is there an audit log ? Yes
Oldest comments (1)
Misleading title. No relation between content and title