# Baserow No-Code Database

> Open source no-code database and Airtable alternative.

- Category: Productivity & Collaboration
- Difficulty: intermediate
- Components: baserow, postgresql, redis, celery, minio
- Tags: baserow, no-code, database, airtable, spreadsheet
- Source: https://docker.recipes/productivity/baserow-no-code

## Overview

Baserow is an open-source no-code database platform that empowers users to create sophisticated databases and applications without writing code. Founded as a direct alternative to Airtable, Baserow combines the familiar interface of spreadsheets with the power of relational databases, offering collaborative workspaces, custom views, and automated workflows. The platform generates REST APIs automatically for every database, making it ideal for developers who need both no-code convenience and programmatic access.

This stack orchestrates Baserow with PostgreSQL as the primary database engine, Redis for caching and session management, and MinIO for S3-compatible file storage. PostgreSQL handles all structured data with ACID compliance and complex query support, while Redis accelerates the user experience through intelligent caching of frequently accessed data and real-time collaboration features. MinIO provides secure, scalable object storage for user uploads, attachments, and media files with full S3 API compatibility.

This configuration targets organizations seeking data sovereignty and customization beyond SaaS limitations. Development teams benefit from having both visual database builders for rapid prototyping and full API access for integration work, while enterprises gain complete control over their data infrastructure without vendor lock-in or monthly per-user fees scaling with team growth.

## Features

- Visual database designer with drag-and-drop field creation including text, numbers, dates, files, and formula fields
- Real-time collaborative editing with Redis-powered synchronization across multiple users and browser sessions
- Automatic REST API generation for every table with authentication, filtering, and pagination built-in
- PostgreSQL-backed data integrity with ACID transactions ensuring consistency across complex relational data
- S3-compatible file storage via MinIO for handling user uploads, images, and document attachments
- Custom views including kanban boards, calendar layouts, gallery views, and filtered table perspectives
- Row-level permissions and team workspace management with granular access controls
- Database templates and field validation rules with support for complex business logic

## Use cases

- Small business CRM systems with contact management, deal tracking, and automated follow-up workflows
- Project management platforms combining task tracking, resource allocation, and team collaboration features
- Content management for marketing teams organizing campaigns, assets, and publication schedules
- Inventory management systems with product catalogs, stock levels, and supplier relationship tracking
- Event planning databases managing venues, vendors, attendees, and logistics coordination
- Research data collection with form generation, participant tracking, and analysis workflow automation
- Customer support ticket systems with automated routing, SLA tracking, and knowledge base integration

## Prerequisites

- Minimum 4GB RAM (2GB for PostgreSQL, 1GB for Baserow application, 512MB for Redis, 512MB for MinIO)
- Docker Engine 20.10+ and Docker Compose v2 with support for health checks and service dependencies
- Ports 80, 443, 9000, and 9001 available for Baserow web interface and MinIO console access
- Basic understanding of environment variables for configuring database credentials and storage settings
- SSL certificate management knowledge if deploying with HTTPS in production environments

## docker-compose.yml

```yaml
services:
  baserow:
    image: baserow/baserow:latest
    ports:
      - "80:80"
      - "443:443"
    environment:
      BASEROW_PUBLIC_URL: http://localhost
      DATABASE_HOST: postgres
      DATABASE_NAME: ${POSTGRES_DB}
      DATABASE_USER: ${POSTGRES_USER}
      DATABASE_PASSWORD: ${POSTGRES_PASSWORD}
      REDIS_HOST: redis
      SECRET_KEY: ${SECRET_KEY}
      AWS_ACCESS_KEY_ID: ${MINIO_ACCESS_KEY}
      AWS_SECRET_ACCESS_KEY: ${MINIO_SECRET_KEY}
      AWS_STORAGE_BUCKET_NAME: baserow
      AWS_S3_ENDPOINT_URL: http://minio:9000
    volumes:
      - baserow_data:/baserow/data
    depends_on:
      postgres:
        condition: service_healthy
      redis:
        condition: service_started
    networks:
      - baserow-net
    restart: unless-stopped

  postgres:
    image: postgres:16-alpine
    environment:
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      POSTGRES_DB: ${POSTGRES_DB}
    volumes:
      - postgres_data:/var/lib/postgresql/data
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U ${POSTGRES_USER} -d ${POSTGRES_DB}"]
      interval: 10s
      timeout: 5s
      retries: 5
    networks:
      - baserow-net
    restart: unless-stopped

  redis:
    image: redis:7-alpine
    volumes:
      - redis_data:/data
    networks:
      - baserow-net
    restart: unless-stopped

  minio:
    image: minio/minio:latest
    ports:
      - "9000:9000"
      - "9001:9001"
    environment:
      MINIO_ROOT_USER: ${MINIO_ACCESS_KEY}
      MINIO_ROOT_PASSWORD: ${MINIO_SECRET_KEY}
    volumes:
      - minio_data:/data
    command: server /data --console-address ":9001"
    networks:
      - baserow-net
    restart: unless-stopped

volumes:
  baserow_data:
  postgres_data:
  redis_data:
  minio_data:

networks:
  baserow-net:
    driver: bridge
```

## .env

```bash
# PostgreSQL
POSTGRES_USER=baserow
POSTGRES_PASSWORD=secure_postgres_password
POSTGRES_DB=baserow

# Baserow
SECRET_KEY=$(openssl rand -hex 32)

# MinIO
MINIO_ACCESS_KEY=minioadmin
MINIO_SECRET_KEY=secure_minio_password
```

## Usage notes

- Baserow at http://localhost
- Create account on first visit
- Build databases with drag-and-drop
- REST API automatically generated

## Troubleshooting

- Baserow fails to start with database connection errors: Verify PostgreSQL health check passes and POSTGRES_USER/POSTGRES_PASSWORD match DATABASE_USER/DATABASE_PASSWORD exactly
- File uploads fail or return 500 errors: Check MinIO container is running and AWS_ACCESS_KEY_ID/AWS_SECRET_ACCESS_KEY match MINIO_ROOT_USER/MINIO_ROOT_PASSWORD
- Real-time collaboration features not working: Ensure Redis container is accessible and REDIS_HOST points to the correct service name in the Docker network
- Baserow shows 'bucket does not exist' errors: Access MinIO console at localhost:9001, login with MINIO credentials, and manually create the 'baserow' bucket
- PostgreSQL container fails with permission denied: Check that postgres_data volume has correct ownership or remove the volume to recreate with proper permissions
- Application performance degrades with multiple users: Increase Redis memory limits and consider PostgreSQL connection pooling by adding BASEROW_DB_OPTIONS environment variable

