docker-compose.yml

version: '3.8'

services:
  # Zookeeper is required by Kafka for cluster management
  zookeeper:
    image: confluentinc/cp-zookeeper:latest
    environment:
      ZOOKEEPER_CLIENT_PORT: 2181

  # Kafka is our message broker for real-time data ingestion
  kafka:
    image: confluentinc/cp-kafka:latest
    depends_on:
      - zookeeper
    ports:
      - "9092:9092"
    environment:
      KAFKA_BROKER_ID: 1
      KAFKA_ZOOKEEPER_CONNECT: zookeeper:2181
      KAFKA_ADVERTISED_LISTENERS: PLAINTEXT://localhost:9092
      KAFKA_OFFSETS_TOPIC_REPLICATION_FACTOR: 1

  # Apache Superset for Business Intelligence and Dashboarding
  superset:
    image: apache/superset:latest
    ports:
      - "8088:8088"
    environment:
      SUPERSET_SECRET_KEY: 'cashsense_secret_key'
    volumes:
      # Mount the local duckdb database file into the container so Superset can read it
      - ./cashsense.db:/app/cashsense.db
    # We define a custom command to initialize superset on startup
    command: >
      /bin/sh -c "
        superset fab create-admin --username admin --firstname Superset --lastname Admin --email admin@example.com --password admin &&
        superset db upgrade &&
        superset init &&
        gunicorn -w 2 -k gevent --timeout 120 -b 0.0.0.0:8088 --limit-request-line 0 --limit-request-field_size 0 \"superset.app:create_app()\"
      "