Secrets when connecting to DBs
This title could be clearer and more informative.Try out Clickbait Shieldfor free (5 uses left this month).
Two community-contributed approaches to managing database connection secrets in Emacs are presented. The first uses a .pgpass file to populate sql-connection-alist. The second leverages ~/.authinfo.gpg with a custom auth-source-search wallet function, setting sql-password-search-wallet-function and sql-password-wallet so that sql-mode can look up credentials by host/database name. Both methods integrate more naturally with sql-mode conventions than the author's previous approach, and the author plans to try sql-connection-alist going forward.
Sort: