This content originally appeared on DEV Community and was authored by o1lab
NocoDB is an open source Airtable alternative that instantly also provides you REST APIs on any MySQL database!
Without further ado-lets see quickly how to create APIs.
Pre-requisites
- Node.js or Docker
- An existing MySQL database
- I am using a large MySQL database with 400+ tables within it! Creating APIs for each one of the table and relation would be more than 7000+ APIs.
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
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
Does NocoDB support other databases ?
Yes - we do!
NocoDB does support all of the below databases :
- Postgres
- SQL-server
- SQLite
- MySQL & MariaDB.
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
…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
More :
This content originally appeared on DEV Community and was authored by o1lab
o1lab | Sciencx (2021-09-30T14:01:46+00:00) How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!. Retrieved from https://www.scien.cx/2021/09/30/how-to-build-7000-rest-apis-within-2-mins-node-js-mysql/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.