[Question] SSL Connections

[benjstephenson]

Is it possible to connect to a db that requires ssl connections? I have a mysql db that I currently work with using DBeaver with the "use SSL" option set to true. I can't tell how to set that in the mysql connection URI, or if it's something that isn't currently supported by dbee.

[zivkovicn]

@benjstephenson it is possible, you just need to provide the needed params f.e:

  {
    "id": "uniq_id_here",
    "url": "postgresql://<host>:<port>/<db_name>?user=<db uder>&password=<url encoded password if contains special characters>&sslmode=require&sslcert=<path to the exact file in your file system>&sslkey=<path to the exact file in your file system>",
    "name": "name of the db",
    "type": "postgresql"
  }