Propel vs Paris Orm

It requires some learning curve, but at the end it's a powerful and versatile ORM. We've been using it for a very big database in a realtime multi-frontend app with zero issues.

Since it uses PDO, it supports all PDO enabled databases, with MySQL, SQLite, PostgreSQL, MSSQL, Oracle included.

Propel uses Active Record, which is a rather simple to understand implementation of an ORM. It's also the most widely adopted implementation. In simple words: an object represents a row, you can create or edit an object to create or edit the corresponding row.

As the code hasn't been drastically changed in the past few years, there is no further learning required once its been learned once.

Paris (and idiorm) is designed to be helpful on the simple tasks that would require a lot of code, then to get out of the way for complex tasks.

For such a simple ORM, its well documented.

Only 2 files to load.

Paris Orm is a single file that sits on top of Idiorm which is also a single file.

Because of the small size, it can be attached to any framework or used by itself.