On 1/11/21 4:33 pm, Tim Cross wrote:
Mike Gauland <mikely...@gmail.com> writes:
I often use an org file to record database queries, using sql source blocks.
I've been putting the database credentials in the file using header-args:sql
properties, but I'd prefer to have the credentials saved in a separate file for
security reasons.
Any ideas on how I could make this work?
It probably wouldn't be too hard to use the authinfo.gpg facility via
the auth-source library which is included in Emacs. In fact, I think
sql-mode might already have support for this built in.
Thanks for the suggestion. I didn't see it on worg, but in ob-sql.el I
found support for ":dbconnection". I can set up an entry in
sql-connection-alist, and give the name of the entry to the sql block
via :dbconnection. Now, my password is safely out of the .org file. As a
bonus, it is easier to maintain across different org files.
