News for hackers. Stuff that matters.
Re:Don’t we all just want to use SQL on the front end? by ipnon on Thursday April 15, 2021 @02:12PM (#26824167)
It seems that the typical software engineer doesn't give security a single thought.
Re:Don’t we all just want to use SQL on the front end? by keanebean86 on Thursday April 15, 2021 @02:59PM (#26824764)
Considering the number of times I've had to remind coworkers about sql injection during code reviews I agree.
Re:Don’t we all just want to use SQL on the front end? by droopyEyelids on Thursday April 15, 2021 @02:56PM (#26824729)
It feels like you and the parent commenters are framing this as a choice between allowing public access to existing databases, or continuing to build new tools for accessing the data.

The way I understood the article, the ideas is 'can we expose a safe subset of SQL or fix the security issues instead of continuing to build entirely new systems'

Re:Don’t we all just want to use SQL on the front end? by falcolas on Thursday April 15, 2021 @03:11PM (#26824882)
Here's the root of my concern - safely and securely emitting SQL from an untrusted client is exponentially harder than running canned SQL queries from a trusted client.

People forget (or don't care) about security or safety when it lets them move faster.

"Move fast and break things," is a terrible security model.

Re:Don’t we all just want to use SQL on the front end? by neonological on Thursday April 15, 2021 @03:35PM (#26825156)
I mean the guy is front end. Front end development doesn't involve any security.
Re:Don’t we all just want to use SQL on the front end? by ipnon on Thursday April 15, 2021 @06:04PM (#26826721)
I think you would be surprised how quickly and easily an attacker can automatically export vulnerabilities in web applications with programs such as Ffuf and SQLmap.
Re:Don’t we all just want to use SQL on the front end? by neonological on Thursday April 15, 2021 @07:21PM (#26827402)
Not disagreeing. I'm just saying people on the front end never actually deal with security, hence this is the mentality that is the instigator of the suggestion of using SQL on the front end.