PHP Data Access Libraries (ORM, ActiveRecord, Persistence)
J'aime 2
For description on the comparison criteria, please read full
article here:
medium.com/...
Lien | Doctrine | Agile Data | Eloquent | Yii ORM | Cake ORM | Fuel ORM | Red Bean PHP | Ting | Spiral ORM | .. |
|---|---|---|---|---|---|---|---|---|---|---|
| Site web | doctrine-project.org | git.io/ad | yiiframework.com | redbeanphp.com | ccmbg.com/... | spiral-framework.com/... | ||||
| Description | Data Access Framework for high-latency databases (Cloud SQL/NoSQL). | RedBeanPHP is an easy to use ORM for PHP. It's a Zero Config ORM lib that 'automagically' builds your database schema. | Simple: no magic inside : it’s basically SQL queries | ORM engine with automatic database scaffolding, strict schemas, code discovery, modular database partitions and various relation loaders. | ||||||
| Github / Bitbucket / Sourceforge | github.com/... | git.io/ad | github.com/... | github.com/... | bitbucket.org/... | github.com/... | ||||
| Licence | MIT | MIT | BSD-3 | New BSD / GPL | Apache 2 | MIT | ||||
| Dernière version | 2.5.5 | 1.2.x | 2.0.10 | 4.3.2 | 3.4.2 | 1.0.8 | ||||
| How schema is defined? | PHP, XML, YAML | in PHP. Method init() in Model class defines fields, relations, conditions, etc. | Model class properties | Active record magic properties. | Automatically discovered on the fly. | PHP | PHP Const array. Column class. | |||
| Code generation | Oui schema-tool | Oui https://github.com/atk4/schema | Oui Web and console generator https://github.com/yiisoft/yii2-gii | |||||||
| Can be used in Any Framework | Oui composer / packagist | Oui Through composer/packagist | Oui Through Capsule | - Planned in 2.1.x | Oui | Oui composer / packagist | ||||
| Automated Cache | Oui Frameworks focuses on optimizing queries rather then caching. Still possible with cross-persistence saving. | Oui | Oui | |||||||
| Anti-patterns (purposely included) | Model close-coupled with Persistence and Field classes. | Eloquent is a God Class; Global functions; DB Conection is global; | ||||||||
| Audience | ||||||||||
| Dependencies | Medium: ±5 packages. | Minimal: 2 packages: DSQL Query Builder (git.io/... | Minimal: 3, pimple, doctrine/cache, aura/sqlquery | |||||||
| Simplicité | aucune note | 5.0/5 2 notes | aucune note | 5.0/5 2 notes | 5.0/5 1 note | aucune note | aucune note | 5.0/5 1 note | aucune note | aucune note |
| Enterprise Compliance | 5.0/5 1 note | 5.0/5 2 notes | 3.0/5 1 note | 4.5/5 2 notes | 5.0/5 1 note | aucune note | aucune note | 5.0/5 1 note | aucune note | aucune note |
| Minimum PHP Version | 5.4 | 5.6 | 5.4 | 5.5 | ||||||
| Basic Features | ||||||||||
| PDO Support | Oui Yes | Oui Yes | Oui | Oui | - But made a custom driver to support it is easy | Oui https://spiral-framework.com/guide/database-databases | ||||
| Transparent support for NoSQL | - Through 3rd party drivers. | Non Eloquent is built on Query Builder. Perhaps moloquent? Also - Through Caching backend, but not as ORM native persistence. | Oui Avialable cross sql and nosql datababase relations (https://github.com/yiisoft/yii2-mongodb) | Non Build around plain queries. | Non | Non No, through ODM (https://spiral-framework.com/guide/odm-databases) | ||||
| How to invoke db-vendor-specific extensions? | Oui DBAL | Oui For SQL - save/load/delete operations are expressed in DSQL Queries that can be manipulated: http://git.io/dsql | Oui Through Query Builder / RAW queries. | Oui SQL - Query Builder. | - Can add SQL code chunks. | Oui Ting use native query, you can use everyting of your SGBD | Oui Query models: https://spiral-framework.com/guide/orm-query | |||
| Array as a persistence | Oui CRUD operations supported | Oui https://github.com/yii2tech/filedb | Non | Non | ||||||
| RestAPI as a persistence | - Through 3rd party extension. | - To extend BaseActiveRecord | Non | Non | ||||||
| JSON string as a persistence | Oui Supported with few extra lines of code. | - To extend BaseActiveRecord | Non | Non | ||||||
| Same model, multiple persistences | Oui Same class. Different object. | - (no docs) | ||||||||
| Basic Single-record operations (C,R,U,D) | ||||||||||
| Table Name Mapping | Oui Yes | Oui Yes | Oui Same as model class name by default | Oui Using static method of active record. http://www.yiiframework.com/doc-2.0/guide-db-active-record.html#declaring-ar-classes | Non mapping no longer supported. | Oui Yes | ||||
| Field Name Mapping | Oui Yes, (Annotations in PHP) | Oui Yes (Field::actual property) | - Through accessors/3rd party extension | Oui | Non mapping no longer supported. | Oui Yes | ||||
| Map Entity to SubQuery | Non Must be physical table | Oui Yes. Extension exist for UNION-models. https://github.com/atk4/report | Non Must be physical table. | - table = new Expression(..) | Non | Non This concept is no-sense for Ting | ||||
| Map property to expression | Non Must be physical field | Oui $model->addExpression() | Non Must be physical table | - (couldn't find docs) | Non | Non This concept is no-sense for Ting | ||||
| Map native types (DateTime) | Oui $field->type = 'date' | Oui Accessors and Mutators | Oui Active record behaviors | Oui | Oui Yes | - No support for DateTime. https://spiral-framework.com/guide/orm-accessors | ||||
| User-defined types (e.g. "23 USD") | Oui Type class | Oui Yes. Independent from Model. by extending Field class. | Oui Accessors and Mutators | Oui Active record behaviors | Oui Yes, with custom serializer | |||||
| Map field of related Entity ('currency' = currency_id->Model Currency.name) | - Specific record only | Oui Transparently maps into sub-select. | - Relationship, but only single record. | Oui $model->currency->name | Non | Oui Yes | ||||
| Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)) | Non | Oui Yes. hasMany()->addField(..aggregate) | Non | - (couldn't find docs) | Non | - This concept is no-sense for Ting | ||||
| Entity to join multiple tables (adding new record populates both tables) | Oui Associations | Oui $model->join('other_table') | Non | Non No native support. | Non | Oui Yes | ||||
| Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria) | ||||||||||
| Support model-level criteria | Oui Yes. Applied on loading / saving / update. | - Global Scope (querying only) | Non | Non | ||||||
| Soft-delete | Oui Extension | Oui Through criteria. Example given in the docs. | Oui Trait and Scope | Oui Events and behaviors | Non | |||||
| Domain Model Criteria | Oui $m->addCondition('gender','M'); where 'gender' can be arbitrary expression, sub-select, field from association(join) or mapped no another physical field. | - Scopes, but not in domain model. | Non Only for specific query: User::find()->byEmail('...')->active()->one() | Non | ||||||
| Expression-based condition | Oui $m->addCondition($m->expr('..')); | Oui through Query Builder | Non Only for query: User::find()->andWhere('...')->all() | Non | ||||||
| Criteria Compliance (new record must match condition) | Oui Transaction rollback and exception. Automated-rloading. | Non | Non | |||||||
| Dynamic criteria | Oui $user->addCondition('is_expired', false) | Non Only Querying: User::find()->where(['a' => '1', 'b' => true])->all(); | Non | |||||||
| Query Building (Convert Model into Query object for further SQL tweaking) | ||||||||||
| Convert Model into Query Object | Oui $q = $model->action('select'); | Oui Model is a Query object. See: Model::where() | Oui \yii\db\ActiveRecord::find() | Non | Oui RecordSelector | |||||
| Raw expression | Oui new Expression('any sql') | Oui DB::raw() | Oui new \yii\db\Expression('...') | Oui | Oui | |||||
| Nested/Composite Queries/Expressions | Oui Expression can be in any part of query | Non | Oui Expression can be in any part of query | Non | ||||||
| Reference domain-model field in query | Oui through Expressionable interface | Non No fields. Only properties. | Non Field is class property. | Non | Non | |||||
| field, where, order, limit | Oui Expressions and Parametric values | Oui | Oui \yii\db\ActiveQuery | Non | Oui | |||||
| options, rollup, partition | - Through custom templates, or expressions. | - not sure. | ||||||||
| UPDATE, DELETE, INSERT query building | Oui | Oui | Non | Oui | ||||||
| REPLACE, TRUNCATE | Oui | - Throught raw sql in \yii\db\Command | - wipe(), | |||||||
| SHOW, DESCRIBE, CALL | - Supported through Expressions or Custom query template | - Throught raw sql in \yii\db\Command | - Automatic schema alter / discovery. | |||||||
| ALTER, CREATE query building | Oui Addon: http://github.com/atk4/schema | Oui | Non | |||||||
| User-defined query template | Oui Templates for all queries | Oui (please link doc) | Non | |||||||
| full support for OR conditions | Oui Through Object Composition and Expressions | - Partial | - | Non only raw query | ||||||
| Use Domain logic in multi-record update | - Supported, but must map fields/values manually. | Non | Non | Non | ||||||
| Data Fetching (different ways to retrieve data from database) | ||||||||||
| Get All Data (2x array) | Oui | Oui | Oui \yii\db\Query::all() | Oui exportAll() | Oui | |||||
| Associative Array (id=>value) | Non Planned | Oui lists() | ||||||||
| Select only required fields | Oui | |||||||||
| Typecasting (e.g. DateTime) | Oui | Oui | ||||||||
| Import (multiple records) | Oui | Oui | ||||||||
| Respect domain model mapping (and criteria) | Oui | |||||||||
| Single row | Oui loadAny | Oui | Oui \yii\db\Query::one() | Oui | ||||||
| Single Value | Oui Through action | Oui | Oui \yii\db\Query::scalar() | Oui | ||||||
| Single Column | - may need to map resulting array | Oui | Oui \yii\db\Query::column() | Oui | Oui | |||||
| Iterator | Oui | Oui | Oui | |||||||
| Bypass persistence mapping | Oui action('select')->getAll() | Oui ?? (e..g prevent date from being transformed into Carbon) | ||||||||
| Loading and Saving individual records | ||||||||||
| Load by ID | Oui load(id) | Oui User::findOne(1) | Oui | Oui get(id) | Oui findByPK | |||||
| Load by other field | Oui loadBy('field', $value) | Oui User::findOne(['id' => 1]) | Non | Oui getBy(['propertyName' => 'value']); | ||||||
| Read-only Models | Oui Yes | Non | ||||||||
| Model without primary key | Oui Yes, but only in Read-only Mode | Non | Oui | |||||||
| Specify fields to load | Oui onlyFields() | Non Fields load with SELECT * | Oui User::find()->select([])->one() | Non | Oui | |||||
| Save only sends dirty fields | Oui | Oui | Oui | - (there is Dirty support, so I assuming it is supported) | Oui | Oui | ||||
| Guarded / Fillable properties | Oui Conditions and OnlyFields do same thing but more reliably. | Oui Prevents "create($_GET)" from messing up important fields. | ||||||||
| Object Hierarchy Model | ||||||||||
| Admin extends User, adds criteria (is_admin=1) | Oui Yes, recommended pattern. "User" class adds condition. | Non | Non Can be done as wrapper: User::findAdmin(..) or custom CDbCriteria | Non | ||||||
| Admin extends User, adds accessible fields | Oui Yes, recommended pattern. | Non | Non | Non | ||||||
| Extend model, add Join (Disjoined SubTypes) | Oui Yes. Unlimited number of joins. | Non | Non | Non | ||||||
| Extend model change table | Oui Yes. Used to tweak 3rd party models. | Non | ||||||||
| Relations/References (One model can relate to another model. NOT A TABLE JOIN) | ||||||||||
| Model can define relation to other Model | Oui References are implemented as Objects | Oui Relations | Oui Relations | Oui | ||||||
| One-to-Many | Oui $user->hasMany('Orders', new Order()); | Oui | Oui | |||||||
| One-to-many traversal strategy | Returns destination model instance with dynamically applied criteria (parent_id=123). No queries are executed. Inserting record into this model will ensure association with parent model. | Returns array of objects that may either be pre-loaded with record data or only contain IDs (lazy-loaded). | Uses classical eager/lazy loading approach. with() can help pre-fetch the data for related entities. | pre-fetch and store objects in an array. | ||||||
| Lazy/Eager-loading | Non Anti-pattern | Oui | Oui | Oui | ||||||
| One-to-One | Oui $order->hasOne('user_id', new User()); | Oui | Oui | |||||||
| Many-to-Many | Oui $user->addCondition('vip', true)->ref('Orders'); | Oui relations() method of an entity can define. | ||||||||
| Deep Many-to-Many traversal. | Non | Oui $user->ref('Orders')->ref('Payments')->action('count'); No intermediate queries. | - only with "to-one" references: $book->author->address->street; Executes multiple queries. | - only with to-one references. Executes multiple queries. | ||||||
| Cross-Persistence traversal | Oui $user->hasMany('Log', new Log($mongodb)); | - No docs. | Non | |||||||
| Cross-persistence joins, aggregation, reporting | ||||||||||
| Multi-persistence join | Non | Non | Non | Non | ||||||
| UNION existing models | Non | Oui Yes, in add-on https://github.com/atk4/report/. Can join UNION result with more tables. | Non | Non | ||||||
| Domain-model Aggregation | Oui Group by multiple fields. Apply aggregation functions. Preserve types. | Non | ||||||||
| Model to Model join | Non Planned. | Non | ||||||||
| Multi-persistence UNION | Non | Non | Non | Non | ||||||
| Behaviours / Hooks | ||||||||||
| Before/After operation | Oui | Oui | ||||||||
| Override standard C,R,U,D operations | Oui | Oui | ||||||||
| Persistence-specific hooks (to modify Query) | Oui | - (no docs) | ||||||||
| User-defined hooks | Oui | Oui | ||||||||
| Auditing | ||||||||||
| Global Auditing | Oui http://www.agiletoolkit.org/data/extensions/audit | Non | ||||||||
| Store old/new field values | Oui Yes in JSON and user-readable string. | Oui | ||||||||
| Revert action (undo) and replay (redo) | Oui | Non | Non | |||||||
| Reactive actions | Oui Each action will be automatically linked with sub-actions which may be invoked through Hooks. | |||||||||
| Store log in any persistence | Oui | Non | ||||||||
| Override, Add fields to audit log | Record dirty fields before persisting. Type-cast into JSON string and store in a single field of AuditLog Model. This model can be persisted anywhere, table, file, etc. | |||||||||
| Custom events | Oui | Oui | ||||||||
| Access to record-specific history | Oui $item->ref('AuditLog'); | - Through a custom query. | ||||||||
| Date of creation, modification | - No but easy to add through hook. | Oui \yii\behaviors\TimestampBehavior | Oui TimestampTrait | |||||||
| User/IP creation, modification | - Easy to add through a hook. | Oui \yii\behaviors\BlameableBehavior | ||||||||
| Store incremental revisions | - Easy to add through a hook | Oui | ||||||||
| Integration | ||||||||||
| Field meta-information provided | Type, caption, possible values, mapped field, join table spec, encryption, serialization, UI-specific settings, validation rules. | |||||||||
| UI extensions | Non | Oui CRUD, Form, Table, Grid, Entity-manager. (see https://github.com/atk4/ad) | Non | Non | Non | |||||
| API extensions | Oui RestFULL API, automated CRUD operations + RPC https://github.com/atk4/api | |||||||||
| J'aime | J'aime 0 | J'aime 2 | J'aime 0 | J'aime 1 | J'aime 1 | J'aime 0 | J'aime 0 | J'aime 0 | J'aime 0 | J'aime 0 |
Avis utilisateurs et commentaires
Probably the easiest at using without up front configuration
Easiest ORM, I think!
Using in Recent modules of our ERP
Most simple among what I used (almost all popular ones)