Deno•8mo ago

Using SSL with deno deploy and supabase postgres direct connection

Hello

I've been trying to setup an SSL connection with a supabase postgreSQL database using a direct connection. Unfortunaly it looks impossible to do it on Deno deploy. Am I right?

I've been trying my best to figure out a solution but it looks like I need to either use

--cert

--cert

or the environment variables

SSL_CERT_FILE

SSL_CERT_FILE

and

DENO_TLS_CA_STORE

DENO_TLS_CA_STORE

to make it work locally. However, on deno deploy, both options can't work:

--cert

--cert

isn't usable and

DENO_TLS_CA_STORE

DENO_TLS_CA_STORE

is forbidden

Any idea? I hope I don't need to abandon deno deploy.

Thanks in advance!

lcasdev•5/14/25, 11:57 AM

What database driver are you using?

lcasdev•5/14/25, 11:57 AM

You can configure the CA certificate through the driver arguments usually

GDream StudioOP•5/14/25, 1:27 PM

I'm using postgresjs from deno.land/x and when I provide the CA certificate it doesn't work

I have to use either

--cert

--cert

SSL_CERT_FILE

SSL_CERT_FILE

and

DENO_TLS_CA_STORE

DENO_TLS_CA_STORE

. If I use it simply doesn't work.. no matter which one I use.

GDream StudioOP•5/14/25, 2:32 PM

@lucacasonato If you have a working example I'll take it

lcasdev•5/14/25, 6:58 PM

I don't know about , but I am relatively sure should work

lcasdev•5/14/25, 7:00 PM

Something like this:

GDream StudioOP•5/14/25, 7:57 PM

Thanks a lot

I'll give it a try and tell you if I made it work

GDream StudioOP•5/14/25, 8:03 PM

Indeed is working

I'll have to figure out how to make it work with kysely now haha. Thanks a lot!

GDream StudioOP•5/14/25, 8:41 PM

All good for me!

lcasdev•5/15/25, 11:59 AM

:partyparrot: