Introducing NocoDB : The Open Source Airtable Alternative

Introducing NocoDB : The Open Source Airtable Alternative

NocoDB simply turns ANY existing relational databases into a smart spreadsheet.

ยท

4 min read

๐Ÿ‘‹ Hey HashNoders - Please Meet NocoDB

NocoDB is a free & open source Airtable alternative

Github : github.com/nocodb/nocodb

NocoDB simply works by transforming ANY of your existing databases into a smart spreadsheet. NocoDB supports MySQL, PostgreSQL, SQL Server, MariaDB & SQLite

Databases are a common element when it comes building full-stack solutions on internet. Yet creating schemas, tables, column with schema migrations and then creating UI so that you can collaborate with your team is a lot of work with existing full stack frameworks. Hence NocoDB is an attempt to fill this gap and make Databases accessible with the ease of spreadsheets.

grid.jpeg

gallery.jpeg

๐Ÿ‘‰ How it works ?

It is simple & minimalistic.

docker run -p 8080:8080 nocodb/nocodb

or

npx create-nocodb-app

For production setup - please see here .

๐ŸŽฅ Let's see a quick Demo :

๐Ÿš€ Just SIX weeks ago we launched :

  • And NocoDB has become one of the fastest growing open source projects.
  • It has been downloaded 650,000 times in docker. ๐Ÿš€
  • 13,600+ Github stars. ๐Ÿ’ซ๐Ÿ’ซ๐Ÿ’ซ
  • 1,100+ have joined our discord community ๐Ÿ™Œ
  • Evan You (Creator of Vue.js) tweeted about NocoDB as well ๐ŸŽ‰๐ŸŽ‰๐ŸŽ‰

๐Ÿ”ฅ Feature set :

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

kanban.jpeg

calendar.jpeg

collaborate.png

appstore.png

apis.png

zapier.png

๐Ÿ—ฝ Evolution of an idea.

  • 2017 : NocoDB was started as a hobby no-code project called Xmysql which created instant REST APIs for any MySQL database. It received 4000+ Github stars and hundreds of thousands of docker downloads. It wasn't production ready but devs started to use it in production!
  • 2020 : Xmysql became low-code product XgeneCloud and it created not only REST but also GraphQL APIs for all the databases. It had a desktop app to help users to do this. Hundreds of companies used us. Many were publicly trading companies.
    • Although product was meant for devs lot of business users started to use us and they started to request an easy to use collaborative UI.
  • 2021 - Pivot : We pivoted to a spreadsheet interface as it was universal in its appeal to business users. And launched NocoDB just 6 weeks ago.

๐ŸŽ† Technologies :

โœจ Minimalism โœจ

NocoDB is built around the idea of minimalism which means the NocoDB can be run from a single node.js file with just SIX lines of code in it.

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

๐ŸŽฏ Why are we building this :

Most internet businesses equip themselves with either spreadsheet or a database to solve their business needs. Spreadsheets are used by a Billion+ 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.

๐Ÿ‘ฅ Please join our Community :

We have a vibrant and diverse community and we would love to be part of it

Join NocoDB : Free & Open Source Airtable Alternative

๐Ÿ“ฌ Feedback

We are extremely happy to be part of this incredible HashNode community. Would love to take your feedback and suggestions on how to improve the product further.

Happy Tinkering, Team NocoDB

ย