On HTML Sanitization, What, Why, How

Posted by & filed under mysql, php, security, wordpress, zippykid.

This is a very good article discussing the different HTML Sanitizers available in the PHP community, what they mean, and the general state of things. Even the WordPress sanitizer (Kses) is included in this review. I really recommend you read this before you start building your own mini cms.

SQL Error with Symfony 1.4.4 and MySQL 5.5

Posted by & filed under mysql, php, symfony.

I ran into an interesting bug/fact today while messing around with MySQL 5.5. It seems that in the DDL, you can’t say “Type=InnoDB|MyISAM|Foo” anymore. You have to say “Engine=InnoDB”. This will break your propel:build-all , or propel:build-all-load .. or if you manually try to execute the sql from data/sql/*. You’ll get the following error: You… Read more »

Talking to multiple databases with Symfony 1.2

Posted by & filed under blog, mysql, php, symfony, web.

Notes on using Symfony with multiple databases. I’m building a new application in symfony, and I need to use some data from an existing application written by another developer. I can’t just extend the existing application for reasons we don’t need to get into, but I do need to interface with the data, since the… Read more »

Redefining Spam, in the age of Twitter

Posted by & filed under blog, mysql, personal, php, web.

For the past few months, I’ve been helping my friend develop and market Philtro . We’ve gone through various iterations of the elevator pitch for it, and the one that seems to be kinda working, is: “It’s like a spam filter for your Twitter account.” At SXSW, I got the opportunity to talk to Guy… Read more »

Cost of clouds, Mosso/Slicehost vs AWS

Posted by & filed under blog, mysql, php, web.

Marco Tabini has a great post discussing the cost of the cloud, and the current state of affairs. He calls for a simpler cloud platform, not just in terms of cost, but ease of use and products and services that adapt to changes in the market. Though the $100/month Mosso offering is mentioned (this site… Read more »

Using Subversion with Mosso

Posted by & filed under mysql, php, security, web.

Thanks to Expandrive . You can now use Subversion (SVN) on websites hosted at Mosso . The idea of mounting a directory you’d normally ftp/sftp to, and then using SVN on it, at first seemed oddly implausible to me. But, I tried it recently, and got exactly the results I wanted. I even had the… Read more »