Add support for connecting to a Turso db remotely

[gerhardvr-finclude]

Hi,

I have a LibSQL DB on Turso.

The URL of my DB is libsql://trailsearch-gerhardvr.aws-eu-west-1.turso.io but I cannot get connected to the DB but it is not a credential issue. I've tried all the below versions of the JDBC URL, but all failed.

jdbc:dbeaver:libsql:trailsearch-gerhardvr.aws-eu-west-1.turso.io
ERROR: java.net.MalformedURLException: no protocol: trailsearch-gerhardvr.aws-eu-west-1.turso.io

jdbc:dbeaver:libsql://trailsearch-gerhardvr.aws-eu-west-1.turso.io
ERROR: java.net.MalformedURLException: no protocol: //trailsearch-gerhardvr.aws-eu-west-1.turso.io

libsql://trailsearch-gerhardvr.aws-eu-west-1.turso.io
ERROR: Invalid connection URL: libsql://trailsearch-gerhardvr.aws-eu-west-1.turso.io.
Expected URL format: jdbc:dbeaver:libsql:

jdbc:dbeaver:libsql:libsql://trailsearch-gerhardvr.aws-eu-west-1.turso.io
ERROR: java.net.MalformedURLException: unknown protocol: libsql

Of the ones I tried, jdbc:dbeaver:libsql:https://trailsearch-gerhardvr.aws-eu-west-1.turso.io/ was the most promising. At least it was not complaining about a protocol. It did however complain about 'route not found: [""]'

[LonwoLonwo]

Thanks for the report. We will take a look at it.

[sangrepura]

Same exact issue. Any progress on this?

[rober-tm]

Tengo el mismo problema, albun avance sobre esto?

[Nexus6v2]

@gerhardvr-finclude Have you tried using the hostname instead of URL provided by Turso?

Example for your case would be:

And the auto-generated jdbc url is jdbc:sqlite:trailsearch-gerhardvr.aws-eu-west-1.turso.io