DEV Community

Cover image for How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!
o1lab
o1lab

Posted on • Updated on

How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!

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
Enter fullscreen mode Exit fullscreen mode

Using Docker

docker run -d --name nocodb -p 8080:8080 nocodb/nocodb
Enter fullscreen mode Exit fullscreen mode

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 ?

GitHub logo nocodb / nocodb

🔥 🔥 The Open Source Airtable Alternative - Powered by Vue.js ❤️

NocoDB
🎃 The Open Source Airtable Alternative 🎃

Turns any MySQL, PostgreSQL, SQL Server, SQLite & MariaDB into a smart-spreadsheet

Build Status Node version Twitter

WebsiteDiscordTwitter

The Open Source Airtable Alternative - works on MySQL, Postgres SQL Server & MariaDB

NocoDB - The Open Source Airtable alternative | Product Hunt

Quick try

1-Click Deploy

Heroku


Deploy NocoDB to Heroku with 1-Click


Using Docker

docker run -d --name nocodb -p 8080:8080 nocodb/nocodb:latest
Enter fullscreen mode Exit fullscreen mode

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

2

1

7

5

6

3

4

11

10

8

9

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

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

More :

Discussion (1)

Collapse
aravin profile image
Aravind A

Misleading title. No relation between content and title