search

kndndrj / nvim-dbee

Interactive database client for neovim
GNU General Public License v3.0
738 stars 50 forks source link

[Question] SSL Connections #135

Open benjstephenson opened 2 months ago

benjstephenson commented 2 months ago

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 commented 1 week ago

@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"
  }