Everything on Railway is containerized, but there is a clickhouse template ready made!

Once in your project, Create -> Template -> Clickhouse

oh sick! I didn't see it under the "Databases" section so I assumed it wasn't well supported yet.

The Databases section would be for the 4 main databases, but Clickhouse is a template that was made by a (at the time) Railway employee.

@brody do you have an example connection string for connecting with the clickhouse client? I have tried setting this up but I get timeouts, etc. If I can get this working, this might be the only blocker I have for setting up a new teams account. Feel free to reach out direct for details. Cheers.

Just created a ticket to update the template with some user friendly variables such as a public and private url like the postgres templates come with, once done I will update here with that info!

Appreciate it!

Got around to updating the ClickHouse template, it should come with all the variables you could need for various clients, tested working with DBeaver.

Variables set on the template -

CLICKHOUSE_DB="railway" # Default database name

CLICKHOUSE_USER="clickhouse" # Name of ClickHouse user
CLICKHOUSE_PASSWORD="${{secret(32, "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789")}}" # Password for ClickHouse user

PORT="8123" # Private ClickHouse HTTP API port
PUBLIC_PORT="443" # Public ClickHouse HTTP API port

HOST="${{RAILWAY_PRIVATE_DOMAIN}}" # Private ClickHouse HTTP API host
PUBLIC_HOST="${{RAILWAY_PUBLIC_DOMAIN}}" # Public ClickHouse HTTP API host

HOST_PORT="${{HOST}}:${{PORT}}" # Private ClickHouse HTTP API host:port
PUBLIC_HOST_PORT="${{PUBLIC_HOST}}:${{PUBLIC_PORT}}" # Public ClickHouse HTTP API host:port

DATABASE_URL="http://${{CLICKHOUSE_USER}}:${{CLICKHOUSE_PASSWORD}}@${{HOST}}:${{PORT}}/${{CLICKHOUSE_DB}}" # Private database URL
PUBLIC_DATABASE_URL="https://${{CLICKHOUSE_USER}}:${{CLICKHOUSE_PASSWORD}}@${{PUBLIC_HOST}}:${{PUBLIC_PORT}}/${{CLICKHOUSE_DB}}" # Private database URL

DATABASE_JDBC_URL="jdbc:clickhouse://${{CLICKHOUSE_USER}}:${{CLICKHOUSE_PASSWORD}}@${{HOST}}:${{PORT}}/${{CLICKHOUSE_DB}}" # Private database JDBC URL
PUBLIC_DATABASE_JDBC_URL="jdbc:clickhouse://${{CLICKHOUSE_USER}}:${{CLICKHOUSE_PASSWORD}}@${{PUBLIC_HOST}}:${{PUBLIC_PORT}}/${{CLICKHOUSE_DB}}" # Private database JDBC URL

You would be able to use that secret generator, replace it with your current password. You would also need to strip out the comments.

Healthcheck -

/ping

Hi there!

I’ve been trying to connect to it for several days now but haven’t been able to resolve the timeout issue.

My issue is related to ClickHouse in the Plausible template. I'm able to access it here :
https://clickhouse-production-0593.up.railway.app/play

But can't connect it using clickhouse-client nor Dbeaver...

Also tried with the Clickhouse template but I've got this issue :
Code: 102. DB::NetException: Unexpected packet from server clickhouse-production-3511.up.railway.app:443 (expected Hello or Exception, got Unknown packet): (clickhouse-production-3511.up.railway.app:443). (UNEXPECTED_PACKET_FROM_SERVER)

Have you had any success connecting to it?

Thanks!