Archive for February, 2007

10 (very) Basic Tips for PHP Web Application Security

Friday, February 23rd, 2007

Barebones list for the things you should be looking for when developing a web app in PHP. Some of it applies to all web apps, not just PHP. Use HTML_Safe (or a similar javascript stripping library) to check for and remove javascript when you're accepting data that will be output ...

What caused that load spike?

Tuesday, February 13th, 2007

Every now and then, we find that we will have a sudden increase in the number of apache processes, load average will spike up, and then go back down to normal. In rare cases, we will see the same thing happen, and the load avg spike WAY up, all ...

SHOW CREATE TRIGGER - Nope

Thursday, February 8th, 2007

As of MySQL 5.0 there is no SHOW CREATE TRIGGER which is pretty annoying. I don't like using "show triggers like ", so I figured I'd write a wrapper around mysqldump. For the record, this was a huge pain the ass. I did this on Fedora, GNU ...