3 ms·
"some text-based SQL statements" What do you have in mind there? Systems that process SQL statements interpret these statements, validate them for correctness
by topspin 9y ago
"some text-based SQL statements"
What do you have in mind there? Systems that process SQL statements interpret these statements, validate them for correctness against a schema and then provide an auditable plan. Just because SQL bears some resemblance to spoken/written English (a property that vanishes pretty quick when you get past simple use cases) doesn't mean it isn't rigorously analyzed by database systems; SELECT isn't some alternative form of 'grep.'
Perhaps you're thinking of SQL injection attacks that plague that the LAMP stack? If so then you should know that NoSQL isn't immune to injection attacks. Here[1] is an OWASP page on testing for NoSQL injection vulnerabilities; the same sloppy coding patterns that allow attackers to synthesize SQL statements are also manifest in NoSQL applications.
[1] https://www.owasp.org/index.php/Testing_for_NoSQL_injection https://www.owasp.org/index.php/Testing_for_NoSQL_injection
- cmenge 9y agoBeing condescending isn't helping your argument here. No, I didn't think of SQL injection and I do have a vague understanding of the SQL grammar. The NoSQL injections seem a bit constructed and pretty much can't happen with a strongly typed language in the application layer.