Database Category
Rietta's database posts cover SQL injection defense, building SQL views in Rails with rake tasks, and using SQL views like Scenic to build complex reports.
08/08/2006
A.R.M. Yourself Against SQL Injection
by Frank Rietta
From a 2006 ACMSE conference talk: protect against SQL injection by validating every input string via ARM: Accept it, Reject it, or Modify it before use.
12/26/2005
Business Analysis of Web Application Information
by Frank Rietta
How to use an Excel spreadsheet to pull data from a web application's SQL server and then perform business analysis on it.