What are the differences between Propel and Apache Torque?
Propel is a port of Torque (which is written in Java); the schema is almost the same and much of the codebase design is very similar. Of course Propel is written in PHP so there are many obvious differences, but there are also some changes that were made that are worth pointing out: • Propel does not support Torque’s “id-broker” method of generating auto-increment ids. The “id-broker” method is essentially what layers like DB, MDB, and ADOdb use to emulate auto-increment/sequences in a db-uniform way. These layers create a new table for every sequence needed. Propel does not support “id-broker” because it uses native id generation, which is available for every supported driver. • Propel adds support for cascading deletes in databases that don’t support them (e.g. MySQL, SQLite). Propel also supports ON CASCADE SET NULL in the same way. • Propel has column validators, based loosely (as I understand it) on the Turbine Intake validation system. • Propel-generated classes have smart date-t
