Historique de PHP Data Access Libraries (ORM, ActiveRecord, Persistence)

Mis à jour 21 déc. 2017 16:45:09

Date de création 18 oct. 2016 22:08:00

• 
  Romans Malinovskis le 21 déc. 2017 16:45:09Signaler

  Liste des éléments (10)

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

  Liste des critères (117)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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, J'aime

• 
  srm le 20 déc. 2017 17:00:04Signaler

  Liste des éléments (9)

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

• 
  Romans Malinovskis le 20 déc. 2017 14:40:39Signaler

  Description

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

• 
  Romans Malinovskis le 20 déc. 2017 01:05:19Signaler

  Liste des critères (121)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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, J'aime

• 
  Romans Malinovskis le 19 déc. 2017 23:25:45Signaler

  Liste des critères (120)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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, J'aime

• 
  Romans Malinovskis le 19 déc. 2017 21:41:37Signaler

  Liste des critères (120)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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, J'aime

• 
  Romans Malinovskis le 24 oct. 2016 17:37:26Signaler

  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 le 24 oct. 2016 17:09:26Signaler

  Liste des critères (121)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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, J'aime

• 
  Romans Malinovskis le 24 oct. 2016 02:18:03Signaler

  Liste des critères (120)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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, J'aime

• 
  Romans Malinovskis le 19 oct. 2016 01:43:39Signaler

  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 le 19 oct. 2016 01:41:13Signaler

  Extrait

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

  Editeur

  public

  Visibilité

  public

• 
  Romans Malinovskis le 19 oct. 2016 01:38:41Signaler

  Liste des critères (119)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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 le 19 oct. 2016 01:38:35Signaler

  Liste des éléments (8)

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

  Liste des critères (120)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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 le 19 oct. 2016 01:36:28Signaler

  Liste des critères (122)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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 le 19 oct. 2016 01:33:39Signaler

  Liste des éléments (6)

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

  Liste des critères (124)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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 le 19 oct. 2016 01:06:17Signaler

  Liste des critères (117)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Automated Cache, Anti-patterns (purposely included), Audience, Dependencies, Simplicité, 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 le 19 oct. 2016 00:14:16Signaler

  Liste des critères (113)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Audience, Dependencies, Simplicité, 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 le 18 oct. 2016 23:46:14Signaler

  Liste des critères (96)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, How schema is defined?, Code generation, Can be used in Any Framework, Audience, Dependencies, Simplicité, 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 le 18 oct. 2016 23:26:01Signaler

  Liste des critères (81)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, Audience, Dependencies, Simplicité, 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 le 18 oct. 2016 22:36:48Signaler

  Liste des critères (34)

  Lien, Site web, Description, Github / Bitbucket / Sourceforge, Licence, Dernière version, Audience, Dependencies, Simplicité, 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
• ›
• »