# yaml-language-server: $schema=https://schema.zeabur.app/template.json
apiVersion: zeabur.com/v1
kind: Template
metadata:
    name: TigerData TimescaleDB (PostgreSQL-17)
spec:
    description: TigerData offers TimescaleDB, a PostgreSQL-based platform that supercharges time-series and real-time analytics
    icon: https://avatars.githubusercontent.com/u/8986001?s=200&v=4
    tags:
        - Database
        - TimeSeries
        - PostgreSQL
    readme: |-
        # TigerData TimescaleDB (PostgreSQL-17)

        TigerData offers TimescaleDB, a PostgreSQL-based platform that supercharges time-series and real-time analytics

        ## Features

        - Based on PostgreSQL
        - Automatic partitioning
        - Advanced compression
        - Query optimization
        - Continuous aggregates for fast data processing
    services:
        - name: TimescaleDB
          icon: https://avatars.githubusercontent.com/u/8986001?s=200&v=4
          template: PREBUILT
          spec:
            source:
                image: timescale/timescaledb:latest-pg17
            ports:
                - id: database
                  port: 5432
                  type: TCP
            volumes:
                - id: data
                  dir: /var/lib/postgresql/data
            instructions:
                - title: Command to connect to your TimescaleDB
                  content: psql -h ${PORT_FORWARDED_HOSTNAME} -p ${DATABASE_PORT_FORWARDED_PORT} -U ${POSTGRES_USER} -d ${POSTGRES_DB}
                - title: TimescaleDB username
                  content: ${POSTGRES_USER}
                - title: TimescaleDB password
                  content: ${POSTGRES_PASSWORD}
                - title: TimescaleDB database
                  content: ${POSTGRES_DB}
                - title: TimescaleDB host
                  content: ${PORT_FORWARDED_HOSTNAME}
                - title: TimescaleDB port
                  content: ${DATABASE_PORT_FORWARDED_PORT}
            env:
                DATABASE_URL:
                    default: postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@${POSTGRES_HOST}:${POSTGRES_PORT}/${POSTGRES_DB}
                    expose: true
                DATABASE_URL_UNPOOLED:
                    default: postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@${POSTGRES_HOST}:${POSTGRES_PORT}/${POSTGRES_DB}
                    expose: true
                POSTGRES_DB:
                    default: zeabur
                    expose: true
                POSTGRES_HOST:
                    default: ${CONTAINER_HOSTNAME}
                    expose: true
                POSTGRES_PASSWORD:
                    default: ${PASSWORD}
                    expose: true
                POSTGRES_PORT:
                    default: ${DATABASE_PORT}
                    expose: true
                POSTGRES_USER:
                    default: postgres
                    expose: true