How to Install Baserow on Your Synology NAS

How to Install Baserow on Your Synology NAS

Baserow is an Airtable alternative. With Baserow you can create your own online database without any technical experience. The user friendly no-code tool gives you the powers of a developer without leaving your browser. In this step by step guide I will show you how to install Baserow on your Synology NAS using Docker.

💡Note: This guide works perfectly with the latest Baserow v1.22.3 release.

  • STEP 1

Please Support My work by Making a Donation.

  • STEP 2

Install Portainer using my step by step guide. If you already have Portainer installed on your Synology NAS, skip this STEP. Attention: Make sure you have installed the latest Portainer version.

  • STEP 3

Make sure you have a synology.me Wildcard Certificate. Follow my guide to get a Wildcard Certificate. If you already have a synology.me Wildcard certificate, skip this STEP.

  • STEP 4

Go to Control Panel / Login Portal / Advanced Tab / click Reverse Proxy. Follow the instructions in the image below.

Baserow Synology NAS Set up 1

  • STEP 5

Now click the “Create” button. Follow the instructions in the image below.

Baserow Synology NAS Set up 2

  • STEP 6

After you click the Create button, the window below will open. Follow the instructions in the image below.

On the General area, set the Reverse Proxy Name description: type in Baserow. After that, add the following instructions:

Source:
Protocol: HTTPS
Hostname: baserow.yourname.synology.me
Port: 443

Check Enable HSTS

Destination:
Protocol: HTTP
Hostname: localhost
Port: 3888

Baserow Synology NAS Set up 3

  • STEP 7

On the Reverse Proxy Rules click the Custom Header tab. Click Create and then, from the drop-down menu, click WebSocket. After you click on WebSocket, two Header Names and two Values will be automatically added. Click Save. Follow the instructions in the image below.

Synology Proxy WebSocket

  • STEP 8

Go to Control Panel / Network / Connectivity tab/ Check Enable HTTP/2 then click Apply. Follow the instructions in the image below.

Baserow Synology NAS Set up 4

  • STEP 9

Go to Control Panel / Security / Advanced tab/ Check Enable HTTP Compression then click Apply. Follow the instructions in the image below.

Baserow Synology NAS Set up 5

  • STEP 10

Go to File Station and open the docker folder. Inside the docker folder, create one new folder and name it baserow. Follow the instructions in the image below.
Note: Be careful to enter only lowercase, not uppercase letters.

Baserow Synology NAS Set up 6

  • STEP 11

Now create three new folders inside the baserow folder that you created at STEP 10 and name them data, db, redis. Follow the instructions in the image below.
Note: Be careful to enter only lowercase, not uppercase letters.

Baserow Synology NAS Set up 7

  • STEP 12

Follow my step by step guide on how to activate SMTP for your Gmail account. This step is mandatory. Note: If you don’t want to use the easiest way for SMTP with Google and you already have SMTP details from your own Mail Server, you can just skip this STEP and use your personalized email SMTP details instead.

  • STEP 13

Log into Portainer using your username and password. On the left sidebar in Portainer, click on Stacks then + Add stack. Follow the instructions in the image below.

1 Synology Portainer Add Stack

  • STEP 14

In the Name field type in baserow. Follow the instructions in the image below.

Note: Copy Paste the code below in the Portainer Stacks Web editor.

version: "3.9"
services:
  redis:
    image: redis
    command:
      - /bin/sh
      - -c
      - redis-server --requirepass redispass
    container_name: Baserow-REDIS
    hostname: baserow-redis
    mem_limit: 256m
    mem_reservation: 50m
    cpu_shares: 768
    security_opt:
      - no-new-privileges:true
    read_only: true
    user: 1026:100
    healthcheck:
      test: ["CMD-SHELL", "redis-cli ping || exit 1"]
    volumes:
      - /volume1/docker/baserow/redis:/data:rw
    environment:
      TZ: Europe/Bucharest
    restart: on-failure:5

  db:
    image: postgres:16
    container_name: Baserow-DB
    hostname: baserow-db
    mem_limit: 512m
    cpu_shares: 768
    security_opt:
      - no-new-privileges:true
    healthcheck:
      test: ["CMD", "pg_isready", "-q", "-d", "baserow", "-U", "baserowuser"]
      timeout: 45s
      interval: 10s
      retries: 10
    volumes:
      - /volume1/docker/baserow/db:/var/lib/postgresql/data:rw
    environment:
      POSTGRES_DB: baserow
      POSTGRES_USER: baserowuser
      POSTGRES_PASSWORD: baserowpass
    restart: on-failure:5

  baserow:
    image: baserow/baserow:latest
    container_name: Baserow
    hostname: baserow
    mem_limit: 3g
    cpu_shares: 768
    security_opt:
      - no-new-privileges:true
    read_only: true
    ports:
      - 3888:80
    volumes:
      - /volume1/docker/baserow/data:/baserow/data:rw
    environment:
      BASEROW_PUBLIC_URL: https://baserow.yourname.synology.me
      BASEROW_MAX_IMPORT_FILE_SIZE_MB: 1024 
      DATABASE_USER: baserowuser
      DATABASE_PASSWORD: baserowpass
      DATABASE_NAME: baserow
      DATABASE_HOST: baserow-db
      DATABASE_PORT: 5432
      REDIS_HOST: baserow-redis
      REDIS_PORT: 6379
      REDIS_PROTOCOL: redis
      REDIS_USER: default
      REDIS_PASSWORD: redispass
      EMAIL_SMTP: Your-own-gmail-address
      EMAIL_SMTP_HOST: smtp.gmail.com
      EMAIL_SMTP_PORT: 587
      EMAIL_SMTP_USER: Your-own-gmail-address
      EMAIL_SMTP_PASSWORD: Your-own-app-password
      EMAIL_SMTP_USE_TLS: true
      FROM_EMAIL: Your-own-gmail-address
    restart: on-failure:5
    depends_on:
      redis:
        condition: service_healthy
      db:
        condition: service_healthy

Note: Before you paste the code above in the Web editor area below, change the value numbers for user with your own UID and GID values. (Follow my step by step guide on how to do this.1026 is my personal UID value and 100 is my personal GID value. You have to type in your own values.
Note: Before you paste the code above in the Web editor area below, change the value for TZ. (Select your current Time Zone from this list.)
Note: Before you paste the code above in the Web editor area below, change the value for BASEROW_PUBLIC_URL and type in your own synology.me DDNS with https:// at the beginning that you have previously created at STEP 6.
Note: Before you paste the code above in the Web editor area below, change the value for EMAIL_SMTP and type in your own Gmail address. Refer to STEP 12.
Note: Before you paste the code above in the Web editor area below, change the value for EMAIL_SMTP_USER and type in your own Gmail address. Refer to STEP 12.
Note: Before you paste the code above in the Web editor area below, change the value for EMAIL_SMTP_PASSWORD and type in your own Gmail app password. Refer to STEP 12.
Note: Before you paste the code above in the Web editor area below, change the value for FROM_EMAIL and type in your own Gmail address. Refer to STEP 12.

Baserow Synology NAS Set up 8

  • STEP 15

Scroll down on the page until you see a button named Deploy the stack. Click on it. Follow the instructions in the image below. The installation process can take up to a few minutes. It will depend on your Internet speed connection.

Baserow Synology NAS Set up 9

  • STEP 16

If everything goes right, you will see the following message at the top right of your screen: “Success Stack successfully deployed“.

Baserow Synology NAS Set up 10

  • STEP 17

Go back to STEP 1 or you will deal with karma 🙂.

  • STEP 18

The installation process can take up to a few seconds/minutes. It will depend on your Internet speed connection. Now open your browser and type in https://baserow.yourname.synology.me In my case https://baserow.mariushosting.synology.me If everything goes right, you will see the Baserow Sign up page. Add your own credentials Email, Name and Password, then click the Sign up button. Follow the instructions in the image below.

Baserow Synology NAS Set up 11 new 2024

  • STEP 19

Your Baserow dashboard at a glance!

Baserow Synology NAS Set up 12 new 2024

Enjoy Baserow!

🆘TROUBLESHOOTING

If you encounter issues by using this container, make sure to check out the Common Docker issues article.

Note: Can I run Docker on my Synology NAS? See the supported models.
Note: How to Back Up Docker Containers on your Synology NAS.
Note: Find out how to update the Baserow container with the latest image.
Note: How to Free Disk Space on Your NAS if You Run Docker.
Note: You can also use your own domain name, but in this case there are some additional STEPS needed, so it’s better to contact me.
Note: How to Schedule Start & Stop For Docker Containers.
Note: How to Activate Email Notifications.
Note: How to Add Access Control Profile on Your NAS.
Note: How to Change Docker Containers Restart Policy.
Note: How to Use Docker Containers With VPN.
Note: Convert Docker Run Into Docker Compose.
Note: How to Clean Docker.
Note: How to Clean Docker Automatically.
Note: Best Practices When Using Docker and DDNS.
Note: Some Docker Containers Need WebSocket.
Note: Find out the Best NAS Models For Docker.
Note: Activate Gmail SMTP For Docker Containers.

This post was updated on Saturday / February 24th, 2024 at 5:40 AM