: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.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
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`
}