An Interest In:
Web News this Week
- April 1, 2024
- March 31, 2024
- March 30, 2024
- March 29, 2024
- March 28, 2024
- March 27, 2024
- March 26, 2024
September 28, 2021 10:31 am GMT
NocoDB
Original Link: https://dev.to/o1lab/in-7-lines-of-code-you-can-turn-any-database-into-airtable-like-spreadsheet-using-nocodb-51ah
In 7 lines of code, you can turn any Database into Airtable-like spreadsheet using NocoDB!
So what is Airtable ?
Airtable is a low-code platform for building collaborative apps. It works like a part spreadsheet & part database.
What is NocoDB ?
- NocoDB is a free & open source Airtable alternative - that turns your existing MySQL/Postgres databases into a smart and beautiful spreadsheets.
Now, show me the code.
(async () => { const server = require('express')(); const {Noco} = require("nocodb"); server.use(await Noco.init({})); console.log(`Visit : localhost:${process.env.PORT}/dashboard`) server.listen(process.env.PORT);})()
Let's break down the 7 lines.
(async () => { // require express const server = require('express')(); // require nocodb const {Noco} = require("nocodb"); // mount nocodb as a middleware server.use(await Noco.init({})); // print console.log(`Visit : localhost:${process.env.PORT}/dashboard`) // listen to a port server.listen(process.env.PORT);})()
Yes, that is it - simple, minimalistic & boring. Like the way it should be while trying something new.
How does it work internally ?
- NocoDB depends on a database to store metadata about projects or spreadsheets. This can be specified using
NC_DB
environment variable. IfNC_DB
is absent then NocoDB defaults to SQLite storing this metadata. - NocoDB Projects can be created in two ways
- First, on
NC_DB
database it self. Second, by connecting to external database.
- First, on
So how to try this quickly ?
You can get started with just one command.
npx create-nocodb-app
or
docker run -d --name nocodb -p 8080:8080 nocodb/nocodb:latest
Where can I find more about the project ?
Please find it below -> fork it / star it / twist it / turn it
NocoDB
The Open Source Airtable Alternative
Turns any MySQL, PostgreSQL, SQL Server, SQLite & MariaDB into a smart-spreadsheet
Quick try
1-Click Deploy
Heroku
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-seedcd nocodb-seednpm installnpm start
GUI
Access Dashboard using : http://localhost:8080/dashboard
Join Our Community
Screenshots
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
Do you have a video demo ?
We do!
Using npx
Using docker
Happy hacking!
Original Link: https://dev.to/o1lab/in-7-lines-of-code-you-can-turn-any-database-into-airtable-like-spreadsheet-using-nocodb-51ah
Share this article:
Tweet
View Full Article
Dev To
An online community for sharing and discovering great ideas, having debates, and making friendsMore About this Source Visit Dev To