SSH Tunnel

[dalin-]

SSH Tunnels are required for doing anything with a database.
https://pantheon.io/docs/articles/local/ssh-tunnels-for-secure-connections-to-pantheon-services/

This is a scriptable problem. Terminus could provide a command such as
terminus --site=foo --env=bar ssh-tunnel

This could then be a stepping stone to allow commands like

terminus --site=foo --env=bar drush sql-dump

And then

terminus --site=foo --env=bar drush sql-dump --structure-tables-list='accesslog,cache_*,devel_queries,devel_times,history,search_*,sessions,watchdog' | drush sql-cli

Which could potentially offer some performance gains for grabbing a local DB.

[bensheldon]

@dalin- there is some work in this direction (see #276).

There is a bit of an engineering challenge in providing and supporting deeper hooks into the local development system. Lots of benefits to adding workflow sugar, but also difficulty in ensuring compatibility across systems and setups. But we're definitely exploring these kinds of things.

[joshkoenig]

I'm curious if/how we can get past compatibility blockers. I'm open to the notion that some of these "macro" type commands will fail fast if they're run on incompatible systems (aka Windows without extra stuff installed).

As long as the failure is clear and refers users to helpful documentation, if we can deliver features that are valuable and helpful to 80% (or more) of users, I think that would be a win.

We could even architect a little platform awareness and pluggability into things, such that if we find some community developers who are windows-savvy and want to provide an alternate implementation, that can be done as a PR...

[dalin-]

Here's a script that I've been using for those sites where sql-sync-pipe inexplicably doesn't work:

terminus-db-dump.txt