Supabase Postgres Connector

[daBee]

I'm having trouble connecting to a Supabase database. Because of their setup, they have some convoluted username and passwords.

`"postgres://#{ [ENV['SUPABASE_UN'] }:#{ [ENV['SUPABASE_PW'] }@aws-0-ca-central-1.pooler.supabase.com:5432/postgres"'

Username has a period in it, and password has a '<' in it. I tried using URI.encode_www_form_component but that still didn't take.

Just inserting the encrypted username and unencrypted password says it's a bad URI:
/Users/rich/.rbenv/versions/3.2.2/lib/ruby/gems/3.2.0/gems/uri-1.0.2/lib/uri/rfc3986_parser.rb:130:in split': bad URI (is not URI?):...`

Is there any other way I can reconfigure this connector in Sequel?

Cheers

[jeremyevans]

Try postgres://aws-0-ca-central-1.pooler.supabase.com:5432/postgres?user=#{url_encoded_username}&password=#{url_encoded_password}

[daBee]

Unencryption shows bad percentage escape and Encrypted shows wrong password.

[jeremyevans]

Well, it sounds like the url encoded password isn't correct. And I'm not sure what you mean by "Encryption", url encoding isn't encryption.

[daBee]

Yes, I missed that. I should see if I can change the actual password. That current password I'm using is referenced elsewhere so it's working on that front.

[daBee]

Fixed with changing the password.