schema

Schema.org aims to provide a common vocabulary for structuring web page data.

If you use Doctrine, then you probably know how lazy loading can hurt your performance.

I carefully craft every query to everything that I need in one shot, but only what I need. One thing that evaded me at first was the i18n part.

I’m putting together a basic Zend Framework starter kit.  Right now I’ve got basic Doctrine 1.2 integration with predefined directories for schema, models, etc.

 Also an init process to allow for automatic injection of specified objects on to front controllers (think $this->session available in your controllers, for example).

Any interest in getting a copy of this?

 What other things would you like to see preconfigured or preintegrated in a starter kit?

Manually extracting relevant information from repeated incantations of SHOW ENGINE INNODB STATUS while trying to figure out what InnoDB is doing is not only error prone, it's just plain hard to do.

And since MySQL doesn't expose the data you really want in an INFORMATION_SCHEMA table (yet?), the option is use an external program to help: innotop.

On the Symfony blog there's a recent post showing how to integrate the framework with Doctrine 2 via the sfDoctrinePlugin:

Vid Luther has a new post to his blog showing how to switch the storage engine only one (or any number of individual tables) in your MySQL-backed Propel/Symfony project.

Vid Luther has a new post today looking at connecting to multiple databases inside of your Symfony framework application.

The key is in setting up your YAML files the right way.

As he mentioned in a previous entry on his blog, Pablo Viquez found a few issues with character encoding and the json_encode function.

He revisits this in a second look at getting it to cooperate with ISO-8859-1 data.