Skip to content

:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.

1.9 KB
Raw Blame
import type { CommonConfig } from '~/common/config'

export type PosthogDatabaseUrlConfig = Pick<
    CommonConfig,
    | 'DATABASE_URL'
    | 'POSTHOG_DB_NAME'
    | 'POSTHOG_DB_USER'
    | 'POSTHOG_DB_PASSWORD'
    | 'POSTHOG_POSTGRES_HOST'
    | 'POSTHOG_POSTGRES_PORT'
>

export type BehavioralCohortsDatabaseUrlConfig = Pick<
    CommonConfig,
    | 'BEHAVIORAL_COHORTS_DATABASE_URL'
    | 'POSTGRES_BEHAVIORAL_COHORTS_HOST'
    | 'POSTGRES_BEHAVIORAL_COHORTS_USER'
    | 'POSTGRES_BEHAVIORAL_COHORTS_PASSWORD'
>

export const MISSING_DATABASE_URL_MESSAGE =
    'You must specify either DATABASE_URL or the database options POSTHOG_DB_NAME, POSTHOG_DB_USER, POSTHOG_DB_PASSWORD, POSTHOG_POSTGRES_HOST, POSTHOG_POSTGRES_PORT!'

export function buildPosthogDatabaseUrl(config: PosthogDatabaseUrlConfig): string {
    if (config.DATABASE_URL) {
        return config.DATABASE_URL
    }

    if (!config.POSTHOG_DB_NAME) {
        throw Error(MISSING_DATABASE_URL_MESSAGE)
    }

    const encodedUser = encodeURIComponent(config.POSTHOG_DB_USER)
    const encodedPassword = encodeURIComponent(config.POSTHOG_DB_PASSWORD)
    return `postgres://${encodedUser}:${encodedPassword}@${config.POSTHOG_POSTGRES_HOST}:${config.POSTHOG_POSTGRES_PORT}/${config.POSTHOG_DB_NAME}`
}

export function buildBehavioralCohortsDatabaseUrl(config: BehavioralCohortsDatabaseUrlConfig): string {
    if (
        config.BEHAVIORAL_COHORTS_DATABASE_URL ||
        !config.POSTGRES_BEHAVIORAL_COHORTS_HOST ||
        !config.POSTGRES_BEHAVIORAL_COHORTS_USER ||
        !config.POSTGRES_BEHAVIORAL_COHORTS_PASSWORD
    ) {
        return config.BEHAVIORAL_COHORTS_DATABASE_URL
    }
    const encodedUser = encodeURIComponent(config.POSTGRES_BEHAVIORAL_COHORTS_USER)
    const encodedPassword = encodeURIComponent(config.POSTGRES_BEHAVIORAL_COHORTS_PASSWORD)
    return `postgres://${encodedUser}:${encodedPassword}@${config.POSTGRES_BEHAVIORAL_COHORTS_HOST}:5432/behavioral_cohorts`
}