Securitybot: Open Sourcing Automated Security at Scale
blogs.dropbox.com
blogs.dropbox.com
Which is my way of saying that those automatic queries will likely start to annoy folks very soon, and they'll find a way not to deal with them.
I can't imagine trying to educate users (outside of an environment in which this thinking is normal) about what can and cannot go over which medium.
The realtime(ish) notifications and questions that they describe in the blog post seem relatively benign compared to say, product planning discussions.
Disclaimer: I used to work at Dropbox and know the individuals involved
Most of the world is doing this now. It's cheaper, easier and in most cases more secure.
Example https://github.com/dropbox/securitybot/blob/master/plugins/s...
Note that we aren't doing ``.format()`` or ``%``, but passing the fill text as the second parameter to ``.execute()`` — this is the correct way to protect against SQLi using MySQLdb.
I actually mistakenly thought this was SQLi when I was reviewing this code for release. Unfortunately, the MySQLdb documentation doesn't make that obvious.
Immutable infrastructure is great for stateless micro services, everything else not so much.