ORM for PHP: Comparison of Doctrine, Eloquent, Propel, and RedBeanPHP

ORM for PHP: Overview and Comparison of Popular Libraries

ORM (Object-Relational Mapping) is a technology that allows you to work with databases through programming language objects rather than SQL queries. In PHP, there are several powerful ORM libraries, each with its own features, advantages, and disadvantages. In this article, we will compare four of the most popular solutions in detail: Doctrine, Eloquent, Propel, and RedBeanPHP. You will learn how they work, see code examples, and be able to make an informed choice for your project.

1. Doctrine — Full Control and Powerful DQL

Doctrine is the most mature and feature-rich ORM for PHP. It consists of two components: DBAL (Database Abstraction Layer) and ORM (Object-Relational Mapping). Doctrine uses the Data Mapper pattern, which means a complete separation of business logic and data storage logic.

Key Features:

• Full support for Doctrine Query Language (DQL) — an object-oriented SQL
• Flexible migration system (Doctrine Migrations)
• Lazy and Eager Loading of relationships
• Support for the entity lifecycle event system
• Built-in caching (metadata, queries, results)

Code Example:

<?php// Defining an Entityuse Doctrine\\ORM\\Mapping as ORM;

/** * @ORM\\Entity * @ORM\\Table(name="users") */class User{    /** @ORM\\Id @ORM\\Column(type="integer") @ORM\\GeneratedValue */    private int $id;

    /** @ORM\\Column(type="string", length=100) */    private string $name;

    /** @ORM\\Column(type="string", unique=true) */    private string $email;

    // Getters and Setters    public function getName(): string { return $this->name; }    public function setName(string $name): void { $this->name = $name; }    public function getEmail(): string { return $this->email; }    public function setEmail(string $email): void { $this->email = $email; }}

// Usage$entityManager = EntityManager::create($connectionParams, $config);$user = new User();$user->setName('Ivan Petrov');$user->setEmail('ivan@example.com');$entityManager->persist($user);$entityManager->flush();

// Query via DQL$query = $entityManager->createQuery('SELECT u FROM App\\Entity\\User u WHERE u.email = :email');$query->setParameter('email', 'ivan@example.com');$result = $query->getOneOrNullResult();

2. Eloquent — Simplicity and Elegance (Laravel)

Eloquent is an ORM that is part of the Laravel framework but is also available for standalone use via the illuminate/database package. It uses the Active Record pattern, where each model represents a row in a database table. Eloquent is known for its intuitive syntax and automatic relationship management.

Key Features:

• Minimal configuration — convention over configuration
• Powerful relationships: belongsTo, hasMany, belongsToMany, etc.
• Automatic timestamp management (created_at, updated_at)
• Built-in scopes, mutators, and accessors
• Support for collections and pagination

Code Example:

<?phpuse Illuminate\\Database\\Eloquent\\Model;

class User extends Model{    protected $table = 'users';    protected $fillable = ['name', 'email'];    protected $hidden = ['password'];

    // One-to-many relationship    public function posts()    {        return $this->hasMany(Post::class);    }}

// Creating a record$user = User::create([    'name' => 'Anna Smirnova',    'email' => 'anna@example.com',]);

// Query with conditions$activeUsers = User::where('status', 'active')