Introducing NocoDB : The Open Source Airtable Alternative
NocoDB simply turns ANY existing relational databases into a smart spreadsheet.
๐ 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.
๐ 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
๐ฝ 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 :
- Node.js
- Typescript
- Vue.js / Nuxt.js / Vuetify.js
- Docker
- Databases : MySQL, Postgres, SQL Server, SQLite & MariaDB
- Our documentation is here
โจ 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
๐ฌ 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