Mark Foster's Blog

Misadventures in Technology

Entries for the ‘Web Development’ Category

How to get the contents of an Oracle CLOB data field in PHP

The Oracle “CLOB” (Character Large Object) is a data type used to store up to 4 Gigabytes of text. Retrieving the contents of a CLOB is not as intuitive as you might think. Let’s say you have a CLOB field/column named “mychars” in an Oracle DB table named “mytable” along with some other fields. You [...]

Must-have web application development tools

I have come up with a list of my “must-have” development tools: Dual Monitors – Developing with two monitors will make you much more productive simply because you spend less time switching between windows all day if nothing else. Monitors are pretty cheap and the productivity gains will more than pay for a dual output [...]

25 ways to insecurity

The 2009 CWE/SANS Top 25 Most Dangerous Programming Errors was recently released by CWE/SANS. Most of the items are old news but I think it is a good checklist that should be on the boiler plate for web application design documents. By putting security requirements in the software specification and design documents, the project manager [...]