Category Archives: mysql

SQL Error with Symfony 1.4.4 and MySQL 5.5

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 … Continue reading

Posted in mysql, php, symfony | View Comments

HipHop for PHP is not for you 60% of the time, everytime.

My apologies to Ron Burgundy for the title of the post, but I’m just a fan of the wisest man to ever live. As Marco and Illia and countless others have said, unless you don’t work with PHP or were … Continue reading

Posted in hiphop, mysql, php, web | View Comments

Changing MySQL storage engine for one table in your Propel/Symfony project

I need one MyISAM table in my schema, I’m using Symfony 1.2 and Propel 1.3. As flexible as Symfony and it’s YAML files are, Propel currently doesn’t allow you to change the storage engine on the fly. You use the … Continue reading

Posted in blog, mysql, php, symfony | View Comments

Building PHP 5.3 packages on Ubuntu 9.04 (Jaunty) for Apache 2

Goal: Build a PHP 5.3 package, that I can install and upgrade on new ubuntu slices as needed, without having to compile on each box. This is an amalgamation of different blog posts that did certain things really well, but … Continue reading

Posted in blog, mysql, php, ubuntu, web | View Comments

Talking to multiple databases with Symfony 1.2

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 … Continue reading

Posted in blog, mysql, php, symfony, web | View Comments

Redefining Spam, in the age of Twitter

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 … Continue reading

Posted in blog, mysql, other, personal, php, web | Tagged , , | View Comments

Cost of clouds, Mosso/Slicehost vs AWS

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 … Continue reading

Posted in blog, mysql, php, web | Tagged , , , , , , , | View Comments

Using Subversion with Mosso

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, … Continue reading

Posted in mysql, php, security, web | Tagged , , , | View Comments

Using your Mac as a local web development environment.

My last post was for all users, technical and non. This post is for the techies who know me, and are switching. Some are coming from Windows, some from Linux, some are designers who need to do some local development. … Continue reading

Posted in Apple, mysql, php, web | View Comments

Scaling a startup, technically and fiscally

Jeremy has a great post about why DHH’s article on Sharding is….dumb, i mean flawed. If you’re a startup, and think you’re about to experience tremendous growth, listen to Jeremy, not DHH. I’ll let Jeremy and the other tech heavy … Continue reading

Posted in mysql, php, web | View Comments