Is your feature request related to a problem? Please describe.
In order to share a team notebook that uses database connections with the self-hosted proxy option, the user must have the technical know-how to install node, install the @observablehq/database-proxy source code, configure and run it.
For non-technical users such as BI / Analysts and Managers, it would be better to have a simpler option such as a downloadable app.
Describe the solution you'd like
A stand-alone app that does the job of @observablehq/database-proxy and is either pre-configured, or easy to configure would be great.
Common problems should also be dealt with with clear instructions on how to remedy (ie. secrets dont match).
The app should also be able to check its configuration is working (ie. make a connection to the configured database).
Describe alternatives you've considered
None.
Additional context
Some more detail on my specific use case: My "local" database is actually a remote postgresql database that I first tunnel to over SSH. For my non-technical co-workers, I have helped them setup their own SSH tunnels with a desktop app (Core Tunnel for MacOS) which means they have the ability to connect without needing to use the command-line or remember any TCP/IP knowledge. I would like the same "set and forget" experience for them with running Observable notebooks.
mootari
commented
2 years ago
Is your feature request related to a problem? Please describe.
In order to share a team notebook that uses database connections with the self-hosted proxy option, the user must have the technical know-how to install node, install the
@observablehq/database-proxysource code, configure and run it.For non-technical users such as BI / Analysts and Managers, it would be better to have a simpler option such as a downloadable app.
Describe the solution you'd like
A stand-alone app that does the job of
@observablehq/database-proxyand is either pre-configured, or easy to configure would be great.Common problems should also be dealt with with clear instructions on how to remedy (ie. secrets dont match).
The app should also be able to check its configuration is working (ie. make a connection to the configured database).
Describe alternatives you've considered
None.
Additional context
Some more detail on my specific use case: My "local" database is actually a remote postgresql database that I first tunnel to over SSH. For my non-technical co-workers, I have helped them setup their own SSH tunnels with a desktop app (Core Tunnel for MacOS) which means they have the ability to connect without needing to use the command-line or remember any TCP/IP knowledge. I would like the same "set and forget" experience for them with running Observable notebooks.