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

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 us…


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 ?

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

OpenSourceAirtableAlternative

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

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

Join NocoDB : Free & Open Source Airtable Alternative

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

…
View on GitHub

Please join our community

More :


This content originally appeared on DEV Community and was authored by o1lab


Print Share Comment Cite Upload Translate Updates
APA

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/

MLA
" » How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!." o1lab | Sciencx - Thursday September 30, 2021, https://www.scien.cx/2021/09/30/how-to-build-7000-rest-apis-within-2-mins-node-js-mysql/
HARVARD
o1lab | Sciencx Thursday September 30, 2021 » How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!., viewed ,<https://www.scien.cx/2021/09/30/how-to-build-7000-rest-apis-within-2-mins-node-js-mysql/>
VANCOUVER
o1lab | Sciencx - » How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2021/09/30/how-to-build-7000-rest-apis-within-2-mins-node-js-mysql/
CHICAGO
" » How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!." o1lab | Sciencx - Accessed . https://www.scien.cx/2021/09/30/how-to-build-7000-rest-apis-within-2-mins-node-js-mysql/
IEEE
" » How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!." o1lab | Sciencx [Online]. Available: https://www.scien.cx/2021/09/30/how-to-build-7000-rest-apis-within-2-mins-node-js-mysql/. [Accessed: ]
rf:citation
» How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !! | o1lab | Sciencx | 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.

You must be logged in to translate posts. Please log in or register.

Related Posts