Allow custom Database URLs for Studio

[6ixfalls]

Currently, Supabase Studio hardcodes a DB_HOST of 127.0.0.1 when self-hosting. (https://github.com/supabase/supabase/blob/master/apps/studio/pages/api/platform/projects/%5Bref%5D/databases.ts)

I'd like to configure that through environment variables, since my database/supavisor does not reside at 127.0.0.1.

[aantti]

Um, I'm not quite sure that's entirely the case at this point :) Current code for self-hosted respects these:

supabase/docker/docker-compose.yml

Lines 35 to 36 in 3590597

	POSTGRES_PORT: ${POSTGRES_PORT}
	POSTGRES_HOST: ${POSTGRES_HOST}

to build a connection string using this env-vars to connect to pg-meta → Postgres:

supabase/apps/studio/lib/api/self-hosted/util.ts

Lines 26 to 30 in 3590597

	export function getConnectionString({ readOnly }: { readOnly: boolean }) {
	const postgresUser = readOnly ? POSTGRES_USER_READ_ONLY : POSTGRES_USER_READ_WRITE
	return `postgresql://${postgresUser}:${POSTGRES_PASSWORD}@${POSTGRES_HOST}:${POSTGRES_PORT}/${POSTGRES_DATABASE}`
	}

and

supabase/apps/studio/lib/api/self-hosted/query.ts

Lines 26 to 27 in 3590597

	const connectionString = getConnectionString({ readOnly })
	const connectionStringEncrypted = encryptString(connectionString)

[6ixfalls]

Here:
https://github.com/supabase/supabase/blob/master/apps%2Fstudio%2Fpages%2Fapi%2Fplatform%2Fprojects%2F%5Bref%5D%2Fdatabases.ts

[aantti]

Can you describe the current issue that you're trying to resolve? What kind of configuration / error?

[aantti]

However, PR #41273 might be related.