NocoDB

Hey Everybody 👋 👋

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

NocoDB is a free & open source Airtable alternative.

docker run -d --name noco 
           -v "$(pwd)"/nocodb:/usr/app/data/ 
           -p 8080:8080 
           nocodb/nocodb:latest

docker run -d --name noco 
           -v "$(pwd)"/nocodb:/usr/app/data/ 
           -p 8080:8080 
            # replace with your pg connection string
           -e NC_DB="pg://host.docker.internal:5432?u=root&p=password&d=d1" 
           # replace with a random secret
           -e NC_AUTH_JWT_SECRET="569a1821-0a93-45e8-87ab-eb857f20a010"  
           nocodb/nocodb:latest

bash <(curl -sSL http://install.nocodb.com/noco.sh) <(mktemp)

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

or

npx create-nocodb-app

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.

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);
})()

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. 🙌

docker run -d --name noco 
           -v "$(pwd)"/nocodb:/usr/app/data/ 
           -p 8080:8080 
           nocodb/nocodb:latest

docker run -d --name noco 
           -v "$(pwd)"/nocodb:/usr/app/data/ 
           -p 8080:8080 
            # replace with your pg connection string
           -e NC_DB="pg://host.docker.internal:5432?u=root&p=password&d=d1" 
           # replace with a random secret
           -e NC_AUTH_JWT_SECRET="569a1821-0a93-45e8-87ab-eb857f20a010"  
           nocodb/nocodb:latest

bash <(curl -sSL http://install.nocodb.com/noco.sh) <(mktemp)

Happy Tinkering,
Team NocoDB

o1labFollow

NocoDB : Open Source Airtable alternative.

Pranav CFollow