Oh, that remote execution is a neat trick. Thanks!
To cover the more trivial point for the non-Emacs readers: Tramp in Emacs makes it so that there's almost no difference between opening a file (C-x C-f) like this:
The subsystem in Emacs called Tramp makes this almost transparent; you edit your remote files as if they were local. There are occasional kinks with path translation in corner-case situations, like local Emacs editing remote source files and trying to load them into remote REPL, but those are rare and can be configured away. Dired (directory manager in Emacs) also works transparently over Tramp, so this essentially replaces SCP and graphical SFTP tools for me. You can even run GDB remotely over Tramp, which is a nice trick.
For example, to run a remote command using an inline org-mode source block:
Or to run code using a remote Jupyter kernel within Org-mode in Emacs: https://github.com/dzop/emacs-jupyter/blob/master/README.org...