Holy shit.
Not only is that one of the worst-performing SQL queries I've ever seen, the fact that it's being emitted as part of an error message, and clearly not parameterized, is absolutely shocking.
Did a little digging. This[0] is the website of the author of the app allegedly used in the caucusing. And oh boy:
* HTTP
* Copyright 2014
* Half of the showcased examples are broken links
* Weird obsession with assuring that their development is not done by "non-English speakers"
* I'm pretty sure it's just one guy (the VoterClick training videos[1] are done out of his house?)
* I won't even comment on the quality of everything else I'm seeing, my confidence that a functionally sound app could be produced by this firm is already at zero
Someone tell me the caucus administrators were not actually using this? This feels like a fever dream.
[0] http://cerenimbus.com/
[1] http://cerenimbus.com/voterclick.html
Edit: The author of the Twitter thread replied and said they weren't confident it's the same app. That makes me feel a little(?) better - I'll leave my critique of this website for posterity...
Not only is that one of the worst-performing SQL queries I've ever seen, the fact that it's being emitted as part of an error message, and clearly not parameterized, is absolutely shocking.
Did a little digging. This[0] is the website of the author of the app allegedly used in the caucusing. And oh boy:
* HTTP
* Copyright 2014
* Half of the showcased examples are broken links
* Weird obsession with assuring that their development is not done by "non-English speakers"
* I'm pretty sure it's just one guy (the VoterClick training videos[1] are done out of his house?)
* I won't even comment on the quality of everything else I'm seeing, my confidence that a functionally sound app could be produced by this firm is already at zero
Someone tell me the caucus administrators were not actually using this? This feels like a fever dream.
[0] http://cerenimbus.com/
[1] http://cerenimbus.com/voterclick.html
Edit: The author of the Twitter thread replied and said they weren't confident it's the same app. That makes me feel a little(?) better - I'll leave my critique of this website for posterity...