I've been using ob-sql to document & prune our dev db and it's been amazing.
https://media.discordapp.net/attachments/428916969861808130/768589313964507166/image0.gif The only rough edge has been that I have to expose the SQL ports to my host, forward it over ssh (I'm using a remote machine to offload docker resources), then install a version of psql required to connect. Lastly I then need to symlink psql to point to the targeted version of psql I need. This means I can only match one setup at a time. A preferred route would be to use the :dir property to eval over tramp like: #+begin_src sql :dir "/sshx:user@devbox|docker:user@vm:/src" SELECT count(id) from accounts; #+end_src If I use Python it works, but something specific about this combo is not working. Any suggestions to fix this, personal config, docs, or debugging steps one could point me to?
