How to connect using supabase as source

[hikrr]

This is my db setting page in supabse.

after I replace this string with my real password and paste it to nocodb cloud "Use Connection URL"
postgres://postgres.deqtlaxsbvexxinrjmgh:[YOUR-PASSWORD]@aws-0-ap-southeast-1.pooler.supabase.com:5432/postgres

after I press "Test Database Connection" button in nocodb, this is the error I got:
self-signed certificate in certificate chain

I searched online and couldn't find something relevant.
I think supabase is popular and this discussion might be helpful for others as well.

Thanks for your help!

[o1lab]

Try using advanced parameters and set SSL to allowed. Between we have loads of our users connecting to supabase. Not sure what is the problem here.

[hikrr]

@o1lab

thanks for your quick reply!

i still have this issue.

[hikrr]

@o1lab and future discoverers!

I am able to connect to the db now by modifying

This is the original text:

{
  "title": "decent_narwhal",
  "dataSource": {
    "client": "pg",
    "connection": {
      "user": "postgres.deqtlaxsbvexxinrjmgh",
      "password": "THIS WAS MY PASSWORD",
      "database": "postgres",
      "host": "aws-0-ap-southeast-1.pooler.supabase.com",
      "port": "5432",
      "ssl": "true"
    }
  },
  "inflection": {
    "inflectionColumn": "none",
    "inflectionTable": "none"
  },
  "sslUse": "Allowed",
  "extraParameters": []
}

This is the new modified text:

{
  "title": "decent_narwhal",
  "dataSource": {
    "client": "pg",
    "connection": {
      "user": "postgres.deqtlaxsbvexxinrjmgh",
      "password": "THIS WAS MY PASSWORD",
      "database": "postgres",
      "host": "aws-0-ap-southeast-1.pooler.supabase.com",
      "port": "5432",
      "ssl": {
        "rejectUnauthorized": false
      }
    }
  },
  "inflection": {
    "inflectionColumn": "none",
    "inflectionTable": "none"
  },
  "sslUse": "Allowed",
  "extraParameters": []
}

and everything works now

[hikrr]

the idea is from #324
but i am not sure whether this will have security issues haha
really new to those db settings and security things.