Error when trying to use squirrel with Vercel Postgres

[JosephTLyons]

1. I set an env var via: export DATABASE_URL=postgres://[USERNAME]:[PASSWORD]@[HOST]:[PORT]/[DATABASE_NAME]?sslmode=require
2. I ran gleam run -m squirrel
3. I got this output

Error: Cannot authenticate (no-method)

I ran into an unexpected problem while trying to authenticate with
the Postgres server. This is most definitely a bug!

Please open an issue at
https://github.com/giacomocavalieri/squirrel/issues/new
with some details about what you where doing, including the
following message:
  Expected: AuthMethod, Got: BeErrorResponse(Set(dict.from_list([#(Code("XX000"), []), #(Message("connection is insecure (try using `sslmode=require`)"), []), #(Severity("ERROR"), [])])))

I'm trying to connect to a Vercel Postgres - maybe that's the issue?

[giacomocavalieri]

Hello! From the error message it looks like I'm not properly handling the ssl connection that the Vercel Postgres server wants, I'll look into this :)

[dandeduck]

@giacomocavalieri Hey, I ran into the same problem but I think it's a bug on pog that might not be properly interpreting the sslmode=require query param. When using the same connection string with it I'm getting the same error message unless I add .ssl(true) manually to the config like so:

  use config <- result.try(pog.url_config(url))
  config
  |> pog.ssl(True)
  |> pog.connect
  |> Ok

So maybe we should open a bug there?

Edit: Just noticed this PR should be fixing this issue. yay!