Remote Server File Dialog

[rolandmueller]

First of all: Thank you so much for developing this tool! I love it.

Right now if you use VS Code on a remote server (with the Remote-SSH functionality of VS Code), the dialog of duckdb-sql-tools in VS Code will open my local file system and not the remote file system. Therefore I was not able to use it with remote VS Code. Would be super nice to fix this, because right now my workflow is to download the (sometime quite big) DuckDB file and analyse it locally (with DBeaver or now duckdb-sql-tools).

[RandomFractals]

That is correct. Preview version of this extension only works with the local desktop version of VS Code and local file system.

Web version of VSCode and data loaded via SSH or WSL is not supported due to Sql Tools using native File Open dialog in the Connection Assistance web view when configuring new database Connection Settings.

Related issues in the Connection Settings hosting SQLTools extension repository our DuckDB SQL Tools extension currently depends on:

https://github.com/mtxr/vscode-sqltools/issues?q=is%3Aissue+is%3Aopen+Remote+SSH+file

You can see if DuckDB provides an extension or custom SQL to attach WSL hosted data, or remote data accessed via SSH, or request it as a new DuckDB SQL feature in their discussions.

Also, DuckDB Sql Tools extension automatically installs and loads httpfs db extension for remote data over https that you can also try if you can expose your data via intranet web application or public https end-point. See a demo of using DuckDB HTTPFS in our README.md documentation section.

We might provide remote data and files URL and glob support in the future Pro versions of DuckDB Tools for VSCode IDE via different alternative DuckDB connection user interfaces and remote fs extension or api.