On Wednesday, 8 December 2021 at 22:10:32 UTC, Steven Schveighoffer wrote:
> But there are plenty of examples where the string-blueprint form is less readable (the INSERT form where you specify fields first, and then parameters later is kind of a terrible syntax to begin with).
e.g. (from a real line of code in my codebase):
conn.exec("UPDATE organization SET loc_lat = ?, loc_lon = ? WHERE id = ?", loc_latitude, loc_longitude, id);
// compare to:
conn.exec(i"UPDATE organization SET loc_lat = $loc_latitude, loc_lon = $loc_longitude WHERE id = $id");
-Steve
Well, for me, the first example you presented is so much more readable:
i.e.
conn.exec("UPDATE organization SET loc_lat = ?, loc_lon = ? WHERE id = ?", loc_latitude, loc_longitude, id);
My brain straight away looks for that comma, and I immediately see what the parameters are.
The other way, I have to read and parse the ENTIRE string!