PHP ORMs: Doctrine vs. Propel

by

I’d go with Doctrine. It seems to me that it is a much more active project and being the default ORM for symfony it is better supported (even though officially the ORMs are considered equal).

Furthermore I better like the way you work with queries (DQL instead of Criteria):

<?php
// Propel
$c = new Criteria();
$c->add(ExamplePeer::ID, 20);
$items = ExamplePeer::doSelectJoinFoobar($c);

// Doctrine
$items = Doctrine_Query::create()
       ->from('Example e')
       ->leftJoin('e.Foobar')
       ->where('e.id = ?', 20)
       ->execute();
?>

(Doctrine’s implementation is much more intuitive to me).

Also, I really prefer the way you manage relations in Doctrine.

I think this page from the Doctrine documentation is worth a read: http://www.doctrine-project.org/documentation/manual/1_2/en/introduction:doctrine-explained

To sum up: If I were starting a new project or had to choose between learning Doctrine and Propel I’d go for Doctrine any day.

More Related Contents:

  1. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  2. Doctrine – How to print out the real sql, not just the prepared statement?
  3. php/symfony/doctrine memory leak?
  4. Good PHP ORM Library?
  5. Get Specific Columns Using “With()” Function in Laravel Eloquent
  6. How to query between two dates using Laravel and Eloquent?
  7. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  8. Why doesn’t MySQL support millisecond / microsecond precision?
  9. Default value in Doctrine
  10. Add a custom attribute to a Laravel / Eloquent model on load?
  11. Doctrine Query Language get Max/Latest Row Per Group
  12. Get the Query Executed in Laravel 3/4
  13. Symfony: Clear doctrine cache
  14. PHPUnit Mock Objects and Static Methods
  15. How to re-save the entity as another row in Doctrine 2
  16. Generating a single Entity from existing database using symfony2 and doctrine
  17. How to specify Composer install path?
  18. Symfony error The class XXX was not found in the chain configured namespaces XXX
  19. Execute raw SQL using Doctrine 2
  20. How to Make Laravel Eloquent “IN” Query?
  21. Laravel Eloquent sort by relation table column
  22. Can I access discriminator field from php in doctrine2?
  23. How to force Doctrine to update array type fields?
  24. What is the safest way of passing arguments from server-side PHP to client-side JavaScript [duplicate]
  25. Laravel Many to many self referencing table only works one way
  26. How can I use DATE() in Doctrine 2 DQL?
  27. Best way to handle dirty state in an ORM model
  28. Reference — frequently asked questions about PDO
  29. Warning: A non-numeric value encountered
  30. Getting raw SQL query string from PDO prepared statements

Leave a Comment