Turn any database into a smart spreadsheet

tituspijean

Sep 2021

NocoDB for YunoHost

Integration level
Install NocoDB with YunoHost

This package allows you to install NocoDB quickly and simply on a YunoHost server.
If you don’t have YunoHost, please consult the guide to learn how to install it.

Overview

NocoDB is an open source NoCode platform that turns any database into a smart spreadsheet, alternative to Airtable.

  • Connect to new/existing SQL database and turn them into spreadsheet.
  • Create grid view, gallery view, kanban view and calendar view on top your data
  • Search, sort, filter columns and rows with ultra ease
  • Invite your team with fine grained Access Control
  • Share views publicly and also with password protection
  • Provides REST & GraphQL APIs with Swagger & GraphiQL GUI

(from NocoDB’s website)

Demo: https://www.nocodb.com/demos

Screenshots

Disclaimers / important information

NocoDB has its own authentication system which does not rely on YunoHost’s SSO or LDAP server.

  • You can make it public, especially if you need its API.
  • You will need to create the first admin right after installation.

Documentation and resources

Developer info

Please send your pull request to the testing branch.

To try the testing branch, please proceed like that.

sudo yunohost app install https://github.com/YunoHost-Apps/nocodb_ynh/tree/testing --debug
or
sudo yunohost app upgrade nocodb -u https://github.com/YunoHost-Apps/nocodb_ynh/tree/testing --debug

More info regarding app packaging: Introduction to packaging | Yunohost Documentation

Turning a database into a brilliant spreadsheet is such a cool idea, and it’s surprisingly doable with tools like Excel. It’s like giving your data superpowers to analyze and organize it easily. One way to start is using excel formulas and functions examples to pull and structure the data. For instance, if you’ve got a table and want to search for specific values, you can try VLOOKUP or INDEX-MATCH. They’re lifesavers when working with large sets of data.

Another neat trick is creating PivotTables. They let you summarize and group data without manually digging through rows and columns. Also, if you’re linking a database to Excel, tools like Power Query make it seamless to pull in data directly.