History of PHP Data Access Libraries (ORM, ActiveRecord, Persistence)

Last update Dec. 21^st 2017 4:45:09 PM

Creation date Oct. 18^th 2016 10:08:00 PM

• 
  Romans Malinovskis on Dec. 21^st 2017 4:45:09 PMReport

  List of items (10)

  Doctrine, Agile Data, Eloquent, Yii ORM, Cake ORM, Fuel ORM, Red Bean PHP, Ting, Spiral ORM, ..

  List of criteria (117)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Support model-level criteria, Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Select only required fields, Typecasting (e.g. DateTime), Import (multiple records), Respect domain model mapping (and criteria), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, 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 operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Store old/new field values, Revert action (undo) and replay (redo), Reactive actions, Store log in any persistence, Override, Add fields to audit log, Custom events, Access to record-specific history, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Integration, Field meta-information provided, UI extensions, API extensions, Like

• 
  srm on Dec. 20^th 2017 5:00:04 PMReport

  List of items (9)

  Doctrine, Agile Data, Eloquent, Yii ORM, Cake ORM, Fuel ORM, Red Bean PHP, Ting, Spiral ORM

• 
  Romans Malinovskis on Dec. 20^th 2017 2:40:39 PMReport

  Description

  For description on the comparison criteria, please read full article here: https://medium.com/@romaninsh/objectively-comparing-orm-dal-libraries-e4f095de80b5

• 
  Romans Malinovskis on Dec. 20^th 2017 1:05:19 AMReport

  List of criteria (121)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Support model-level criteria, Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Select only required fields, Typecasting (e.g. DateTime), Import (multiple records), Respect domain model mapping (and criteria), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, 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 operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Store old/new field values, Revert action (undo) and replay (redo), Reactive actions, Store log in any persistence, Override, Add fields to audit log, Custom events, Access to record-specific history, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Integration, Field meta-information provided, UI extensions, API extensions, Like

• 
  Romans Malinovskis on Dec. 19^th 2017 11:25:45 PMReport

  List of criteria (120)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Support model-level criteria, Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Select only required fields, Typecasting (e.g. DateTime), Import (multiple records), Respect domain model mapping (and criteria), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, 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 operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Store old/new field values, Revert action (undo) and replay (redo), Reactive actions, Store log in any persistence, Override, Add fields to audit log, Custom events, Access to record-specific history, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Integration, Field meta-information provided, UI extensions, Like

• 
  Romans Malinovskis on Dec. 19^th 2017 9:41:37 PMReport

  List of criteria (120)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Support model-level criteria, Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Select only required fields, Typecasting (e.g. DateTime), Import (multiple records), Respect domain model mapping (and criteria), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Override, Add fields to audit log, Reactive actions, Store old/new field values, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Revert action (undo) and replay (redo), Custom events, Custom fields, table, Store log in any persistence, Access to record-specific history, Integration, Field meta-information provided, UI extensions, Like

• 
  Romans Malinovskis on Oct. 24^th 2016 5:37:26 PMReport

  Description

  I have been looking for in-depths comparison between various libraries that simplify operations with data in PHP. Compare Doctrine vs Agile Data vs Eloquent vs Yii ORM vs Cake ORM vs Fuel ORM. For more information on comparison criteria, see: https://youtu.be/rLwq5KaV9_k and https://gist.github.com/romaninsh/c28ceb0ee38918fc0d5af8b96d7d7910

• 
  Romans Malinovskis on Oct. 24^th 2016 5:09:26 PMReport

  List of criteria (121)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Support model-level criteria, Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Override, Add fields to audit log, Reactive actions, Store old/new field values, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Revert action (undo) and replay (redo), Custom events, Custom fields, table, Store log in any persistence, Access to record-specific history, Integration, Field meta-information provided, UI extensions, Meta-information (allows exploration by UI widgets), Implementation Strategy, UI Widget can fetch list of Model Fields, UI Widget can get Field type, default value, caption, hint, field storing reference to another Model can map into DropDown, Like

• 
  Romans Malinovskis on Oct. 24^th 2016 2:18:03 AMReport

  List of criteria (120)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Override, Add fields to audit log, Reactive actions, Store old/new field values, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Revert action (undo) and replay (redo), Custom events, Custom fields, table, Store log in any persistence, Access to record-specific history, Integration, Field meta-information provided, UI extensions, Meta-information (allows exploration by UI widgets), Implementation Strategy, UI Widget can fetch list of Model Fields, UI Widget can get Field type, default value, caption, hint, field storing reference to another Model can map into DropDown, Like

• 
  Romans Malinovskis on Oct. 19^th 2016 1:43:39 AMReport

  Description

  I have been looking for in-depths comparison between various libraries that simplify operations with data in PHP. Compare Doctrine vs Agile Data vs Eloquent vs Yii ORM vs Cake ORM vs Fuel ORM.

• 
  Romans Malinovskis on Oct. 19^th 2016 1:41:13 AMReport

  Excerpt

  Compare Doctrine vs Agile Data vs Eloquent vs Yii ORM vs Cake ORM vs Fuel ORM vs x vs x

  Editor

  public

  Viewer

  public

• 
  Romans Malinovskis on Oct. 19^th 2016 1:38:41 AMReport

  List of criteria (119)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Override, Add fields to audit log, Reactive actions, Store old/new field values, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Revert action (undo) and replay (redo), Custom events, Custom fields, table, Store log in any persistence, Access to record-specific history, Integration, Field meta-information provided, UI extensions, Meta-information (allows exploration by UI widgets), Implementation Strategy, UI Widget can fetch list of Model Fields, UI Widget can get Field type, default value, caption, hint, field storing reference to another Model can map into DropDown

• 
  Romans Malinovskis on Oct. 19^th 2016 1:38:35 AMReport

  List of items (8)

  Doctrine, Agile Data, Eloquent, Yii ORM, Cake ORM, Fuel ORM, Red Bean PHP, Spiral ORM

  List of criteria (120)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, If record loaded several times, changing one affects another?, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Override, Add fields to audit log, Reactive actions, Store old/new field values, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Revert action (undo) and replay (redo), Custom events, Custom fields, table, Store log in any persistence, Access to record-specific history, Integration, Field meta-information provided, UI extensions, Meta-information (allows exploration by UI widgets), Implementation Strategy, UI Widget can fetch list of Model Fields, UI Widget can get Field type, default value, caption, hint, field storing reference to another Model can map into DropDown

• 
  Romans Malinovskis on Oct. 19^th 2016 1:36:28 AMReport

  List of criteria (122)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, uses * to load all fields, Automatically save modified entity, If record loaded several times, changing one affects another?, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Override, Add fields to audit log, Reactive actions, Store old/new field values, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Revert action (undo) and replay (redo), Custom events, Custom fields, table, Store log in any persistence, Access to record-specific history, Integration, Field meta-information provided, UI extensions, Meta-information (allows exploration by UI widgets), Implementation Strategy, UI Widget can fetch list of Model Fields, UI Widget can get Field type, default value, caption, hint, field storing reference to another Model can map into DropDown

• 
  Romans Malinovskis on Oct. 19^th 2016 1:33:39 AMReport

  List of items (6)

  Doctrine, Agile Data, Eloquent, Yii ORM, Cake ORM, Fuel ORM

  List of criteria (124)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, uses * to load all fields, Automatically save modified entity, If record loaded several times, changing one affects another?, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, User-defined criteria, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Override, Add fields to audit log, Reactive actions, Store old/new field values, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Revert action (undo) and replay (redo), Custom events, Custom fields, table, Store log in any persistence, Access to record-specific history, Integration, Field meta-information provided, UI extensions, Meta-information (allows exploration by UI widgets), Implementation Strategy, UI Widget can fetch list of Model Fields, UI Widget can get Field type, default value, caption, hint, field storing reference to another Model can map into DropDown

• 
  Romans Malinovskis on Oct. 19^th 2016 1:06:17 AMReport

  List of criteria (117)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Table Name Mapping, Field Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Map field to sub-query on related entity (Client.balance = Client->orders->sum(total)), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, uses * to load all fields, Automatically save modified entity, If record loaded several times, changing one affects another?, Save only sends dirty fields, Guarded / Fillable properties, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, User-defined criteria, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Override, Add fields to audit log, Reactive actions, Store old/new field values, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Revert action (undo) and replay (redo), Re-do apply action, Custom events, Custom fields, table, Store log in any persistence, Access to record-specific history

• 
  Romans Malinovskis on Oct. 19^th 2016 12:14:16 AMReport

  List of criteria (113)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Field Name Mapping, Table Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Specify fields to load, uses * to load all fields, Automatically save modified entity, If record loaded several times, changing one affects another?, Save only sends dirty fields, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-many traversal strategy, Lazy/Eager-loading, Eager-loading, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, User-defined criteria, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks, Auditing, Global Auditing, Override, Add fields to audit log, Reactive actions, Store old/new field values, Date of creation, modification, User/IP creation, modification, Store incremental revisions, Revert action (undo) and replay (redo), Re-do apply action, Custom events, Custom fields, table, Store log in any persistence, Access to record-specific history

• 
  Romans Malinovskis on Oct. 18^th 2016 11:46:14 PMReport

  List of criteria (96)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, How schema is defined?, Code generation, Can be used in Any Framework, Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Field Name Mapping, Table Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Lazy/Eager-loading, Eager-loading, Specify fields to load, uses * to load all fields, Automatically save modified entity, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-One, Many-to-Many, Deep Many-to-Many traversal., Cross-Persistence traversal, User-defined criteria, Cross-persistence joins, aggregation, reporting, Multi-persistence join, UNION existing models, Multi-persistence UNION, Multi-persistence value linking (current_sensor_value), Behaviours / Hooks, Before/After operation, Override standard C,R,U,D operations, Persistence-specific hooks (to modify Query), User-defined hooks

• 
  Romans Malinovskis on Oct. 18^th 2016 11:26:01 PMReport

  List of criteria (81)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Array as a persistence, RestAPI as a persistence, JSON string as a persistence, Same model, multiple persistences, Basic Single-record operations (C,R,U,D), Field Name Mapping, Table Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), User-defined types (e.g. "23 USD"), Map field of related Entity ('currency' = currency_id->Model Currency.name), Entity to join multiple tables (adding new record populates both tables), NoSQL (must be transparent to domain logic), MongoDB support, Neo4j, MemCache, Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, Criteria Compliance (new record must match condition), Dynamic criteria, Query Building (Convert Model into Query object for further SQL tweaking), Convert Model into Query Object, Raw expression, Nested/Composite Queries/Expressions, Reference domain-model field in query, field, where, order, limit, options, rollup, partition, UPDATE, DELETE, INSERT query building, REPLACE, TRUNCATE, SHOW, DESCRIBE, CALL, ALTER, CREATE query building, User-defined query template, full support for OR conditions, Use Domain logic in multi-record update, Data Fetching (different ways to retrieve data from database), Get All Data (2x array), Associative Array (id=>value), Single row, Single Value, Single Column, Iterator, Bypass persistence mapping, Loading and Saving individual records, Load by ID, Load by other field, Read-only Models, Model without primary key, Lazy/Eager-loading, Eager-loading, Specify fields to load, uses * to load all fields, Automatically save modified entity, Object Hierarchy Model, Admin extends User, adds criteria (is_admin=1), Admin extends User, adds accessible fields, Extend model, add Join (Disjoined SubTypes), Extend model change table, Relations/References (One model can relate to another model. NOT A TABLE JOIN), Model can define relation to other Model, One-to-Many, One-to-One, Many-to-Many, Deep Many-to-Many traversal.

• 
  Romans Malinovskis on Oct. 18^th 2016 10:36:48 PMReport

  List of criteria (34)

  Link, Website, Description, Github / Bitbucket / Sourceforge, License, Latest version, Audience, Dependencies, Simplicity, Enterprise Compliance, Minimum PHP Version, Basic Features, PDO Support, Transparent support for NoSQL, How to invoke db-vendor-specific extensions?, Basic Single-record operations (C,R,U,D), Field Name Mapping, Table Name Mapping, Map Entity to SubQuery, Map property to expression, Map native types (DateTime), Map field of related Entity ('currency' = currency_id->Model Currency.name), Entity to join multiple tables (adding new record populates both tables), Criteria, Scope, Conditions (Model will refuse to work with records that does not match criteria), Soft-delete, Domain Model Criteria, Expression-based condition, NoSQL (must be transparent to domain logic), MongoDB support, Array as a persistence, JSON string as a persistence, RestAPI as a persistence, Neo4j, MemCache

• «
• ‹
• 1
• 2
• ›
• »