Re:Better SQL strings in io.js
by failed_ideas on Monday February 09, 2015 @09:59AM
(#9021424)
I wouldn't call that better. I'd much rather have a self escaping sql literal, something like:
[ Parent
| on HN ]
Re:Better SQL strings in io.js
by dingdingdang on Monday February 09, 2015 @10:04AM
(#9021446)
Agreed, the value of magic fades very quickly when you're trying to to retro-implement complex SQL query from Stackoverflow into "smart query" language.
Re:Better SQL strings in io.js
by lucian1900 on Monday February 09, 2015 @11:42AM
(#9022071)
That won't use a parametrised query, though.
Re:Better SQL strings in io.js
by failed_ideas on Monday February 09, 2015 @07:08PM
(#9024653)
Why not, I'm talking about a construct that doesn't exist. A SQL literal string can be stored and auto parameterized prior to interpolation. You see the :int isn't the name, it's the parameter/type safeyness that any good dev would want.