How to Install NocoDB on Manjaro

NocoDB is a free and open-source tool for building custom backends for web and mobile apps. In this tutorial, we will guide you through the steps of installing NocoDB on Manjaro.

Prerequisites

• A Manjaro system up and running
• A non-root user with sudo privileges

Step 1 - Install Node.js

NocoDB is a Node.js application, which means we need to install Node.js and npm (Node Package Manager) first. To do so, open a Terminal and run the following command:

sudo pacman -S nodejs npm

Step 2 - Install PostgreSQL

NocoDB requires a PostgreSQL database to store data. We can install it using the following command:

sudo pacman -S postgresql

After the installation is complete, start and enable the PostgreSQL service:

sudo systemctl start postgresql.service
sudo systemctl enable postgresql.service

Step 3 - Create a Database and User

We need to create a new database and a user for NocoDB. To do so, log in to the PostgreSQL server as the PostgreSQL user:

sudo -iu postgres

Then, create a new database and a user:

createdb nocodb
createuser -P nocodb

You will be prompted to enter a password for the new user. Choose a strong password and remember it.

Step 4 - Install NocoDB

Now it's time to install NocoDB. We can do so using npm:

sudo npm install -g nocodb

Step 5 - Configure NocoDB

Before we start NocoDB, we need to configure it. Create a new configuration file named config.json using the following command:

sudo nano /etc/nocodb/config.json

Paste the following configuration into the file:

{
  "port": 8080,
  "dbConfig": {
    "client": "pg",
    "connection": {
      "host": "localhost",
      "user": "nocodb",
      "password": "YOUR_PASSWORD",
      "database": "nocodb"
    }
  }
}

Replace YOUR_PASSWORD with the password you chose for the nocodb user in Step 3. Save and exit the file.

Step 6 - Start NocoDB

Now we can start NocoDB using the following command:

sudo nocodb

You should see the following output:

✔ NocoDB STARTED [mode: single | port: 8080 | timezone: Asia/Kolkata | db_type: pg]

Now open your web browser and go to http://localhost:8080. You should see the NocoDB login screen.

Step 7 - Log In to NocoDB

Log in to NocoDB using the following credentials:

• Username: admin
• Password: nocodb

You will be prompted to change the password. Choose a strong password and remember it.

Step 8 - Create a New Project

After logging in, you will be taken to the project dashboard. Click on the "Create New Project" button and follow the instructions to create a new project.

Congratulations! You have successfully installed NocoDB on Manjaro and created a new project. Now you can use NocoDB to build custom backends for your web and mobile apps.