On 26/02/2018 5:06 AM, Joe wrote:
On Sunday, 25 February 2018 at 09:23:18 UTC, rikki cattermole wrote:
On IRC earlier today we discussed database libs a bit, we agreed that
both "?" and "@name" needed to be supported. No other suggestions came
up. We don't really need a third or fourth form I think.
"@name"? Which DBMS uses that? Although Denis said Postgres uses $1, PG
also supports :name, in either the command line tool (psql) and the
procedural language PL/pgSQL. Personally, I prefer what Python's PEP
249 calls 'format' (%s) or 'pyformat' (%(name)s). Note that although
the %s appears in the SQL string, the actual arguments are passed
separately at invocation time, as either tuples or dicts (associative
arrays).
Joe
ADO.net uses it, and since we're trying to copy some of its features,
that is what came up.
