Your Web News in One Place

Help Webnuz

Referal links:

Sign up for GreenGeeks web hosting
September 28, 2021 10:31 am GMT

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 - The Open Source Airtable

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 usingNC_DBenvironment variable. IfNC_DBis absent then NocoDB defaults to SQLite storing this metadata.
  • NocoDB Projects can be created in two ways
    • First, onNC_DBdatabase it self. Second, by connecting to external database.

Screen Shot 2021-09-28 at 12.36.13

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

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

Website Discord Twitter

OpenSourceAirtableAlternative

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

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

Join NocoDB : Free & Open Source Airtable Alternative

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

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:    Share on Facebook
View Full Article

Dev To

An online community for sharing and discovering great ideas, having debates, and making friends

More About this Source Visit Dev To