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 storage engine as specified in propel.ini. As discussed in the Propel FAQ .

So, the next best thing to do now is to have it so that when Symfony runs propel:insert-sql, I can piggyback my own SQL to it. Luckily, this is possible, and it’s explained here

I now have my own SQL file running at the end, where I do an ALTER TABLE. For the lazy web.

1. Create your Alter table:

ALTER TABLE `database`.`footable` ENGINE=`MyISAM`;

2. Save the file in $projectdir/data/sql/piggyback.sql

…

Installing Cherokee With PHP5 And MySQL Support On Debian Lenny

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on a Debian Lenny server with PHP5 support (through FastCGI) and MySQL support.

Installing Cherokee With PHP5 And MySQL Support On Fedora 11

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on a Fedora 11 server with PHP5 support (through FastCGI) and MySQL support.

Installing Apache2 With PHP5 And MySQL Support On Debian Lenny (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Debian Lenny server with PHP5 support (mod_php) and MySQL support.

In PHP 5.3 the magic quotes feature has been deprecated and with PHP 6 magic quotes will be removed completely. There are good reasons why magic quotes are bad, but how to live without?

I think the most promising solution is to (finally) start using MySQLi instead of PHP's classic MySQL extension. It's not as easy and straightforward to use as the classic one, but it's easier and probably more secure than to fight SQL injections by ones own hands.

The summer break seems to be over and the event season is heating up again! There is a number of conferences and events coming up in the next months — here is a quick summary of the events that I plan to attend.

This Friday I will attend an event here in Hamburg: the "Silpion Sommerfest", organized by Silpion (a local IT solutions provider which is a partner of Sun Microsystems as well). I will be there to network and talk about MySQL.

This coming weekend (2009-09-12/2009-09-13), there will be the PHP Unconference here in Hamburg, Germany . It will consist of two days of Barcamp-style sessions about …

I thought I would introduce my hobby project tweet2email.com.

I created Tweet 2 Email because I had certain people I follow in Twitter who do not post very regularly, but whose updates I do not want to miss in the flow of more regular posters. Tweet 2 Email allows you to follow someone via email by sending you hourly digests of a selected user’s updates. I later added the ability to subscribe to a Twitter search, allowing you to keep up with a given subject.

I built it using PHP, MySQL and a PHP-Twitter library I tweaked for my purposes.

I’m still testing and improving it, but if you need to track something in Twitter I invite you to give it a try.

According to Yahoo News (and WSJ, only for subscribers - thanks to @Oswald for mentioning it on twitter, see also Reuters), the EU opens an in-depth probe to the Oracle-Sun deal.

According to the source, EU Competition Commisioner Neelie Kroes said:

"The (European) Commission has an obligation to ensure that customers would not face reduced choice or higher prices as a result of this takeover,"

Furthermore, the commision set a January 19, 2010 deadline for its decision, Yahoo …

IPC 2009, the International PHP Conference will take place on November 15th-18th in Karlsruhe, Germany. While the deadline for the call for papers for the main conference program has already passed, there is still an opportunity to submit MySQL-related content: the organizers plan to have a special MySQL Day, which will take place on Tuesday, 17th of November.

Quoting for the Call for Papers web page:

We are looking for speakers joining the Architecture Day or the MySQL Day. "Architecture", in terms of project organization, business organization, tools & approaches etc. is becoming a key qualification to developers and teams. And MySQL still is one of the most common open source databases used in many of todays leading web applications. The International PHP Conference will …

Installing Nginx With PHP5 And MySQL Support On Fedora 11

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 11 server with PHP5 support (through FastCGI) and MySQL support.