Compare Sizes
Français Español


PHP Data Access Libraries (ORM, ActiveRecord, Persistence)
Github / Bitbucket /
Latest version2.0.10
How schema is defined?Active record magic properties.
Code generationYes Web and console generator
Can be used in Any Framework- Planned in 2.1.x
Automated CacheYes
Anti-patterns (purposely included)
5.0/5 2 ratings
Enterprise Compliance
4.5/5 2 ratings
Minimum PHP Version5.4
Basic Features
PDO SupportYes
Transparent support for NoSQLYes Avialable cross sql and nosql datababase relations (
How to invoke db-vendor-specific extensions?Yes SQL - Query Builder.
Array as a persistenceYes
RestAPI as a persistence- To extend BaseActiveRecord
JSON string as a persistence- To extend BaseActiveRecord
Same model, multiple persistences- (no docs)
Basic Single-record operations (C,R,U,D)
Table Name MappingYes Using static method of active record.
Field Name MappingYes
Map Entity to SubQuery- table = new Expression(..)
Map property to expression- (couldn't find docs)
Map native types (DateTime)Yes Active record behaviors
User-defined types (e.g. "23 USD")Yes Active record behaviors
Map field of related Entity ('currency' = currency_id->Model $model->currency->name
Map field to sub-query on related entity (Client.balance = Client->orders->sum(total))- (couldn't find docs)
Entity to join multiple tables (adding new record populates both tables)No No native support.
Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria)
Support model-level criteriaNo
Soft-deleteYes Events and behaviors
Domain Model CriteriaNo Only for specific query: User::find()->byEmail('...')->active()->one()
Expression-based conditionNo Only for query: User::find()->andWhere('...')->all()
Criteria Compliance (new record must match condition)No
Dynamic criteriaNo Only Querying: User::find()->where(['a' => '1', 'b' => true])->all();
Query Building (Convert Model into Query object for further SQL tweaking)
Convert Model into Query ObjectYes \yii\db\ActiveRecord::find()
Raw expressionYes new \yii\db\Expression('...')
Nested/Composite Queries/ExpressionsYes Expression can be in any part of query
Reference domain-model field in queryNo Field is class property.
field, where, order, limitYes \yii\db\ActiveQuery
options, rollup, partition
UPDATE, DELETE, INSERT query buildingYes
REPLACE, TRUNCATE- Throught raw sql in \yii\db\Command
SHOW, DESCRIBE, CALL- Throught raw sql in \yii\db\Command
ALTER, CREATE query buildingYes
User-defined query templateYes (please link doc)
full support for OR conditions-
Use Domain logic in multi-record updateNo
Data Fetching (different ways to retrieve data from database)
Get All Data (2x array)Yes \yii\db\Query::all()
Associative Array (id=>value)
Select only required fields
Typecasting (e.g. DateTime)
Import (multiple records)
Respect domain model mapping (and criteria)
Single rowYes \yii\db\Query::one()
Single ValueYes \yii\db\Query::scalar()
Single ColumnYes \yii\db\Query::column()
Bypass persistence mapping
Loading and Saving individual records
Load by IDYes User::findOne(1)
Load by other fieldYes User::findOne(['id' => 1])
Read-only Models
Model without primary key
Specify fields to loadYes User::find()->select([])->one()
Save only sends dirty fieldsYes
Guarded / Fillable properties
Object Hierarchy Model
Admin extends User, adds criteria (is_admin=1)No Can be done as wrapper: User::findAdmin(..) or custom CDbCriteria
Admin extends User, adds accessible fieldsNo
Extend model, add Join (Disjoined SubTypes)No
Extend model change table
Relations/References (One model can relate to another model. NOT A TABLE JOIN)
Model can define relation to other ModelYes Relations
One-to-many traversal strategyUses classical eager/lazy loading approach. with() can help pre-fetch the data for related entities.
Many-to-ManyYes relations() method of an entity can define.
Deep Many-to-Many traversal.- only with "to-one" references: $book->author->address->street; Executes multiple queries.
Cross-Persistence traversal- No docs.
Cross-persistence joins, aggregation, reporting
Multi-persistence join
UNION existing models
Domain-model Aggregation
Model to Model join
Multi-persistence UNION
Behaviours / Hooks
Before/After operationYes
Override standard C,R,U,D operationsYes
Persistence-specific hooks (to modify Query)- (no docs)
User-defined hooksYes
Global Auditing
Store old/new field valuesYes
Revert action (undo) and replay (redo)No
Reactive actions
Store log in any persistenceNo
Override, Add fields to audit log
Custom eventsYes
Access to record-specific history- Through a custom query.
Date of creation, modificationYes \yii\behaviors\TimestampBehavior
User/IP creation, modificationYes \yii\behaviors\BlameableBehavior
Store incremental revisions
Field meta-information provided
UI extensionsNo
API extensions
Dec. 21st 2017 4:45:09 PM
View changes

User reviews and comments

  • Abdur Rob on Jan. 28th 2017 6:39:20 AM
    rated this Item: Simplicity 5/5

    Easiest ORM, I think!