勉強日記

チラ裏

2019-08-01から1ヶ月間の記事一覧

SQL Antipatterns ch21 SQL Injection

pragprog.com SQL Injection Objective: Write Dynamic SQL Queries Antipattern: Execute Unverified Input As Code Accidents May Happen The Top Web Security Threat The Quest for a Cure Escaping Values Query Parameters コラム: What Was My Comple…

SQL Antipatterns ch20 Readable Passwords

pragprog.com Readable Password Objective: Recover or Reset Password Antipattern: Store Pasword in Plain Text Storing Paswords Authenticating Passwords Don't Lump Together Two Different Conditions Sending Passwords in Email How to Recognize…

SQL Antipatterns ch17 Poor Man's Search Engine

pragprog.com Poor Man's Search Engine Objective: Full-Text Search Antipattern: Pattern Matching Predicates How to Recognize the Antipattern Legitimate Uses of the Antipattern Solution: Use the Right Tool for the Job Vendor Extensions Full-…

SQL Antipatterns ch19 Implicit Columns

pragprog.com Implicit Columns Objective: Reduce Typing Antipattern: A Shortcut that Gets You Lost Breaking Refactoring Hidden Costs You Asked for It, You Got It How to Recognize the Antipattern Legitimate Uses of the Antipattern Solution: …