Web Developer Security Checklist
While it means well, I think some of this advice is pretty bad, or at least unbalanced. From the very first section:<p>&gt; Encrypt all data at rest in the database<p>ALL data? How are you supposed to query against it then? What does &quot;at rest&quot; even mean in the context of an always-on database? An encrypted partition or something?<p>I&#x27;m not even sure what this is supposed to mean and it is certainly not common practise.<p>&gt; Use secondary encryption for data identifying users and any sensitive data like access tokens, email addresses or billing details<p>So <i>two</i> layers of encryption!? Again, how is one supposed to look up an access token or email address if it is encrypted? And it strikes me that if you don&#x27;t trust the first level of encryption, the solution is to fix that, not add <i>another</i> one.<p>&gt; Fully prevent SQL injection by only using SQL prepared statements and stored procedures<p>That is an extraordinarily inefficient and costly way to develop. The correct way to protect against SQL injection is to use a framework&#x2F;driver which guarantees escaping and to be cautious about what you allow into queries.<p>I could go on. The costs of implementing these recommendations would be staggering for the questionable benefits they would provide. It is absolutely possible to have excellent security without implementing any of these ideas, and I don&#x27;t think they&#x27;re helpful at all - and certainly not &quot;simple&quot;.