DEV Community

Cover image for NocoDB : The Open Source Airtable Alternative
o1lab
o1lab

Posted on

NocoDB : The Open Source Airtable Alternative

NocoDB

Hey Everybody πŸ‘‹ πŸ‘‹

We are really excited to show NocoDB on Dev.to forum today.

NocoDB is a free & open source Airtable alternative.

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

…

Just six weeks ago we launched NocoDB and NocoDB now has :

  • 660,000+ Docker downloads!
  • 13,600+ Github stars! πŸ’« πŸ’« πŸ’«
  • 1,100+ strong discord community!
  • And by Runa Capital's analysis, NocoDB has been the fastest growing open source project for Q2.
  • Evan You - Creator of Vue.js also tweeted about us! πŸŽ‰πŸŽ‰πŸŽ‰πŸŽ‰

Did we anticipate this coming ?
Surely not. And as like many of you tinkerers, we were curious-anxious going into launch day. However, we are totally overwhelmed by the response of community. And would love to share more on the product & the journey here in Dev.to

How it works

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

or

npx create-nocodb-app
Enter fullscreen mode Exit fullscreen mode

NocoDB simply works by connecting to your existing databases and transforming them into a smart spreadsheet interface! This allows you to collaborate just like google/airtable spreadsheets with your teams. And we also allow programmatic access to theses spreadsheet with REST & GraphQL APIs!

NocoDB currently works with

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server
  • SQLite
  • Amazon Aurora & MariaDB databases.

NocoDB: Gallery View

NocoDB: app store

NocoDB: programmatic API access

NocoDB: Collaborative spreadsheet

NocoDB : Integrate with zapier

Also NocoDB's app store allows you to build business workflows on views with combination of Slack, Microsoft Teams, Discord, Twilio, Whatsapp, Email & any 3rd party APIs too. Plus NocoDB provides programmatic access to APIs so that you can build integrations with Zapier / Integromat and custom applications too.

FEATURES :

Rich Spreadsheet Interface :

  • ⚑ Sort, search, filter, hide columns with 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 & many more)!!
  • ⚑ Roles : Owner, Creator, Editor, Commenter, Viewer, Commenter, Custom.
  • ⚑ Access Control : Fine-grained access control even to column level.
  • ⚑ API tokens to integrate with n8n, Zapier & Integromat.

Automations & App store :

  • ⚑ Chat : Microsoft Teams, Slack, Discord, Mattermost
  • ⚑ Email : SMTP, SES, Mailchimp
  • ⚑ SMS : Twilio
  • ⚑ Whatsapp
  • ⚑ Any 3rd Party APIs

Programmatic API access via :

  • ⚑ REST APIs (Swagger)
  • ⚑ GraphQL APIs.
  • ⚑ Includes JWT Authentication & Social Auth

Please join our community

πŸ“£ Github : https://github.com/nocodb/nocodb
πŸ“£ Discord : https://discord.gg/5RgZmkW
πŸ“£ Twitter : https://twitter.com/nocodb


πŸ”¦ NocoDB's journey so far..

We open sourced two API solutions before NocoDB :

  • ⚑ A no-code REST APIs generator for any MySQL DB. ~4000+ Github Stars. This was a hobby project & had no GUI. πŸ“ˆ
  • ⚑ A low-code REST-GraphQL APIs generator for any database with GUI. Used by 100s of companies. Including fortune 500s & publicly trading companies. πŸ“ˆ

The thing that surprised us the most was that even non-developers started using our API products & rooting for us. πŸš€ πŸš€ .. This made us to rethink & combine the power of our 2 API products then transform them into something better.


🎯 Why we building this ?

Most internet businesses equip themselves with either spreadsheet or a database to solve their business needs. Spreadsheets are used by a hundreds of millions humans collaboratively every single day. However, we are way off working at similar speeds on databases which are way more powerful tools when it comes to computing. Attempts to solve this with SaaS offerings has meant horrible access controls, vendor lockin, data lockin, abrupt price changes & most importantly a glass ceiling on what's possible in future.

❀️ Our Mission :

Our mission is to provide the most powerful no-code interface for databases which is open source to every single internet business in the world. This would not only democratise access to a powerful computing tool but also bring forth a billion+ people who will have radical tinkering-and-building abilities on internet.


πŸ’Š And.. There is.. One last thing.. this makes it insanely good :

NocoDB can be run from a single node.js file with just SIX lines of code in it! This minimalism means NocoDB runs even on the smallest of servers. Not just AWS, DigitalOcean, Heroku but also in A2Hosting & similar.

(async () => {
    const app = require('express')();
    const {Noco} = require("nocodb");
    app.use(await Noco.init({}));
    console.log(`Visit : localhost:${process.env.PORT}/dashboard`)    
    app.listen(process.env.PORT);
})()
Enter fullscreen mode Exit fullscreen mode

Hope you loved it. ❀️


Please join our community at :

πŸ“£ Github : https://github.com/nocodb/nocodb
πŸ“£ Discord : https://discord.gg/5RgZmkW
πŸ“£ Twitter : https://twitter.com/nocodb

Would love to hear your usecases & feedbacks. πŸ™Œ

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

…

Happy Tinkering,
Team NocoDB

o1lab image

pranavcbalan image

Pranav C

Top comments (24)

Collapse
 
abhinav1217 profile image
Abhinav Kulshreshtha

Here, Take my  Love, Trust, Appreciation and Money

I went to give you a star on github and turns out I had already starred it before. Maybe I stumbled across the repo few months ago, when I was searching for a self hosted version of airtable for a project I was working on.

Amazing feature set, Visuals are nice too. I will definitively use this in next project I need something like this.

Is self-hosted part always going to be free (and feature complete) in future?
Are you going to provide a paid, managed by you, instance in future for those who don't want to bother with hassles of self hosting?

Collapse
 
get1page profile image
1Page

Looks good.. forking :)

Collapse
 
o1lab profile image
o1lab

Thank you - your contributions are welcome.

github.com/nocodb/nocodb#contributing

Collapse
 
nomade55 profile image
Lucas G. Terracino

Sounds pretty good. Specially the six line thing for constrained environments.

Best of luck with the post launch. I'll be checking it soon!

Collapse
 
o1lab profile image
o1lab

Thank you!

Collapse
 
unpseudocomplique profile image
unpseudocomplique

Look great !
Any plans to support mongoDb to allow me to try in m'y company?

Collapse
 
o1lab profile image
o1lab

Its requested by a lot of people & we plan to have mongo. But just not yet :) We plan to make the current version stable and I believe mongo will be in some respects easier/

Collapse
 
unpseudocomplique profile image
unpseudocomplique

Agree with u πŸ™‚

Collapse
 
gautamkrishnar profile image
Gautam Krishna R

Great job guys. This was a much needed one. All the best.

Collapse
 
mfts profile image
Marc Seitz

Amazing @o1lab and @pranavcbalan ! I made a video to show my appreciation for your hard work and contribute my learnings back to the open source community.

πŸŽ₯ πŸ‘‡
youtube.com/watch?v=QGpTSpvxTSU

Collapse
 
o1lab profile image
o1lab

Thanks a tonne @mfts for making the video - we really appreciate the video and the overview.

Collapse
 
_hs_ profile image
HS

Just to say: thank you. Given that I don't contribute to JS projects at least I can share the post

Collapse
 
o1lab profile image
o1lab

Thank you means much.

Our stack is in typescript, vuejs & javascript. We intend to convert most JS to TS soon.

Collapse
 
tommyhendrawan profile image
Tommy Hendrawan

Amazing! I will try use nocoDB for my next project!

Collapse
 
kingkoli profile image
raju udava

In built support for multiple database! I can just plug my existing mysql database! Wow!

Collapse
 
o1lab profile image
o1lab

Yes! For any doubts please hopin to our discord : discord.gg/5RgZmkW

Collapse
 
vasco2006 profile image
Vasyl Rakivnenko

Awesome budiness-tool πŸš€πŸš€πŸš€

Collapse
 
marthaelax profile image
AngeiΝ₯Ν₯Ν₯Ν₯Ν₯Ν₯Ν₯Ν₯Ν₯Ν₯Ν₯Ν₯Ν₯Ν₯

Wow I think this will be a game changer for business looking to automate workflows, specially approval workflows O_O

Collapse
 
aisone profile image
Aaron Gong

will you be moving from Vue2 to Vue3? Also sometimes its good to use less Vue plugins, sometimes they are not really needed.

Collapse
 
o1lab profile image
o1lab

Yes, we will be moving to vue3 later this year.

Collapse
 
beebase profile image
Maarten Berkenbosch

Also keep an eye on Svelte as an alternative ;-)
It's even more productive/fun than Vue.

Thread Thread
 
o1lab profile image
o1lab

:)

Collapse
 
islamzatary profile image
Islam AlZatary

Great Effort Guys, and On-time for me as i will start work on feature similar to Airtable.
thank you

Collapse
 
revskill10 profile image
Truong Hoang Dung

I tried but the graphql api is broken.