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

Website β€’ Discord β€’ Twitter

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 :

Top comments (1)

Collapse
aravin profile image
Aravind A

Misleading title. No relation between content and title

🌚 Browsing with dark mode makes you a better developer by a factor of exactly 40.

It's a scientific fact.