<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Stefano, <br>
</p>
<p>that was very interesting, thanks a lot. Special thanks also to
Gary and our host.</p>
<p>Emacs feels like an eternal advent calendar, opening doors all
over the year ;)<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 26.09.19 um 10:01 schrieb Stefano
Rodighiero:<br>
</div>
<blockquote type="cite"
cite="mid:CABuLN4w8=U6X0eiooYe+RDwRvQ31Ts03vtk7wWSN2TeADoFbcg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hi all,
<div><br>
</div>
<div>thank you for the meeting last evening!</div>
<div><br>
</div>
<div>I think my illustration of the patch for Org-mode Babel was
a </div>
<div>bit rushed, and that I didn't make the two parts I
presented </div>
<div>clear enough. Moreover, someone expressed interest in
seeing </div>
<div>the code, so here some explanations.</div>
<div><br>
</div>
<div>1. There will be a new feature in org-mode allowing users
to specify</div>
<div>a `:dbconnection` header arg for SQL source blocks. This
way,</div>
<div>instead of writing connection parameters directly in the
header, </div>
<div>which is tedious, error-prone and exposes credentials as
plain-text</div>
<div>content, one can use `sql-connection-alist`, a data
structure users</div>
<div>can redefine (defined in `sql.el`, practically a dictionary
of </div>
<div>names -> connection params, used for example in
`sql-connect`).</div>
<div>Org-mode maintainers kindly merged my patch (<a
href="https://code.orgmode.org/bzg/org-mode/src/master/lisp/ob-sql.el#L179"
moz-do-not-send="true">https://code.orgmode.org/bzg/org-mode/src/master/lisp/ob-sql.el#L179</a>)
so it will available at some point </div>
<div>in the future.</div>
<div><br>
</div>
<div>2. "How can I maintain `sql-connection-alist`?"</div>
<div>There are many options. In my configuration there's a
mechanism </div>
<div>that keeps `sql-connection-alist` in sync with
`~/.pgpass`. </div>
<div>You can see it starting from here: <a
href="https://github.com/larsen/emacs-configuration/blob/master/larsen-sql.el#L70"
moz-do-not-send="true">https://github.com/larsen/emacs-configuration/blob/master/larsen-sql.el#L70</a></div>
<div><br>
</div>
<div>s.</div>
<div><br>
</div>
<div>
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature"><a
href="http://www.stefanorodighiero.net" target="_blank"
moz-do-not-send="true">www.stefanorodighiero.net</a></div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
emacs-berlin mailing list
<a class="moz-txt-link-abbreviated" href="mailto:emacs-berlin@emacs-berlin.org">emacs-berlin@emacs-berlin.org</a>
<a class="moz-txt-link-freetext" href="https://mailb.org/mailman/listinfo/emacs-berlin">https://mailb.org/mailman/listinfo/emacs-berlin</a>
</pre>
</blockquote>
</body>
</html>