Its time to change the orm

On September 5, 2009, Posted by , In PHP,Symfony,Webdevelopment, tagged in ,,,,,, , With Comments Off on Its time to change the orm

I attended the great symfony day 09 in cologne yesterday. It was an awesome conference with nice people, interesting talks and discussions. Propel is dead One thing got crystal clear during the talks. Propel is dead! In the next version 1.3 of symfony Doctrine will be the default orm. If…

Problems with default values in Propel

On December 5, 2008, Posted by , In PHP,Symfony,Webdevelopment, tagged in ,,, , With 3 Comments

Default values rule! I’m using Propel 1.2 (an upgrade will be done soon) but for other people out there … Consider the following declaration-fragment for the “Foo-entity”. Nothing special here. <column name="name" type="VARCHAR" size="32" required="true" /> <column name="culture" type="CHAR" size="5" required="true" default="de_DE" /> Now if we create the new object…

SQL-Join with multiple conditions when using Propel

On September 3, 2008, Posted by , In PHP,Symfony,Webdevelopment, tagged in ,,, , With 2 Comments

Propels (Creole) “criteria infrastructure” is a great speed-up for the development process and makes it easy to “write” queries. However if you are forced to create a SQL-Join which requires multiple join-conditions the criteria-api is not a helper anymore. In order to make use of the criteria-api even in this…

Performance increase when using case-insensitive queries with Symfony, Propel and PostgreSQL

On January 24, 2008, Posted by , In Symfony, tagged in ,,,, , With Comments Off on Performance increase when using case-insensitive queries with Symfony, Propel and PostgreSQL

Symfony makes heavy use of Propel. Propel finds objects in the storage container using criteria. If you want to let Propel (okay the database) ignore the case you can set this in the criteria. $c = new Criteria ();   // Allow case sensitive searches $c->setIgnoreCase (true);   // Find…