Cycle ORM is a database interaction software from Spiral Scout that supports efficient data management. It includes features such as a capable query builder, support for multiple databases, and transaction management so developers can handle complex data operations easily. Cycle ORM allows for object-oriented database access, promoting a more intuitive coding use. It is designed to work with various database systems, providing flexibility in development environments. This platform supports both synchronous and asynchronous operations, enabling better performance for applications. Key capabilities: capable query builder support for multiple databases transaction management object-oriented access asynchronous operations Best for: developers that need efficient database interaction and management in their applications.
Cycle ORM by Spiral Scout is a powerful and flexible object-relational mapper (ORM) designed for PHP developers who seek modern, performant, and scalable solutions to handle complex data operations in web applications. Built to bridge the gap between PHP applications and relational databases, Cycle ORM focuses on developer control and code transparency, offering fine-tuned data mapping and persistence mechanisms without relying heavily on reflection or annotation-heavy programming styles. It is especially attractive to developers who want better control over their domain logic and prefer configuration over convention. As a data layer engine for high-load applications, it supports a wide variety of use cases—from simple CRUD operations to complex transactional workflows. While Cycle ORM doesn’t have a traditional graphical user interface, its design philosophy around usability is evident in its elegant syntax, intuitive mapping definitions, and support for domain-driven development. Instead of depending on YAML or annotations like some legacy ORMs, Cycle uses PHP schema declarations that are readable and easy to manage. This allows developers to understand and configure entity relationships with less guesswork and debugging time.
Utilizes the DataMapper pattern, allowing for a clean separation between your domain objects and the database, supporting Plain Old PHP Objects (POPOs), Active Record (AR), or custom entity types.
Provides extensive support for various relational types including has-one, has-many, many-through-many, and polymorphic relations, enabling complex data modeling.
Offers both Eager and Lazy loading with a powerful query builder and multiple fetch strategies, allowing developers to optimize data retrieval based on specific needs.
Supports dynamic mapping schemas and runtime configuration (with or without code-generation), providing flexibility in how data is mapped to objects.
Uniquely works with both directed and cyclic graphs using command chains, facilitating the persistence of complex object graphs with recursive dependencies.
Supports a wide range of popular relational databases including MySQL, MariaDB, PostgreSQL, SQL Server, and SQLite.
The core identity of the product, emphasizing its data mapping and modeling capabilities in PHP.
Allows for highly adaptable setup to model datasets according to specific requirements.
Provides a robust tool for constructing complex database queries.
Supports the ability to define and adjust how objects map to database tables at runtime, useful for applications requiring dynamic data structures (e.g., ERP/CRM/CMS).
Supports advanced relationship types where an entity can be related to multiple other entity types (e.g., a "Comment" entity related to either a "Post" or a " "Video" entity).
Standard relational capabilities for defining relationships between entities.
Can work with Plain Old PHP Objects (POPOs), Active Record (AR) patterns, custom objects, or even the same entity type for multiple repositories, offering flexibility in object design.
Allows loading related data along with the primary entity in a single query, reducing the N+1 query problem.
Defers loading of related data until it is actually accessed, optimizing initial load times.
Provides various methods for retrieving data from the database.
Enables configuring the ORM at runtime, offering flexibility and potentially avoiding the need for static code generation, which is beneficial for long-running applications like those powered by RoadRunner.
Straightforward mapping of database table columns to object properties.
A mapping strategy where an entire class hierarchy is stored in a single database table.
Allows embedding value objects (objects without a unique identity that represent a value, like an "Address" object) within entities.
Can manage and persist data structures that have directional relationships.
Specifically designed to handle complex data structures with circular dependencies through its command chain mechanism for persistence.
Compatible with MySQL databases.
Compatible with MariaDB databases.
Compatible with PostgreSQL databases.
Compatible with Microsoft SQL Server databases.
Compatible with SQLite databases.
The cycle/database component (Database Abstraction Layer) is included by default in Web and GRPC builds, focusing on unifying database access across different DBMS.
Can work seamlessly with doctrine/collections for handling entity collections.
Can work seamlessly with illuminate/collections (Laravel's collection class) for handling entity collections.
Supports defining entity mappings using Doctrine annotations (and PHP 8 attributes).
Built to work safely and efficiently in daemonized PHP environments like RoadRunner, minimizing memory leaks.
Allows for customization of persist strategies, mappers, relations, and transactions.
Tools for generating database schemas, inspecting existing ones, and managing database changes through migrations.
Defines reusable query constraints.
Supports using Universally Unique Identifiers as primary keys.
Provides a mechanism for marking records as "deleted" without actually removing them from the database.
Automatically manages created_at and updated_at fields.
Allows defining custom data types for database columns.
Supports defining foreign key relationships to columns that are not primary keys.
Allows entities and relations to use multiple columns as a primary or foreign key.
A mapping strategy where each entity in a class hierarchy maps to its own separate table, joined by a common identifier.
Improved internal mapper architecture for easier work with lazy links, typed class properties, and private class properties.
Uses proxy objects to enable efficient lazy loading of relationships.
A rewritten hydrator for improved performance when populating entities from database results.
Flexible rules and handlers for converting entity property values to common data types.
Distinct components for managing transaction state and persisting entities.
Ensures compatibility with modern PHP versions.
Be the first to drop a review
MAISY Database is a utility customer data platform from Jackson Associates that supports block-level distribution…
AITable.ai is a visual database and workflow automation platform that functions like a spreadsheet but…
NCache is an Open Source Distributed Cache software from AlachiSoft that supports data caching and…
OSqlEdit is a database management software from OwnData that provides tools for editing and executing…
Spot something wrong or outdated?
Suggest a correction — a reviewer verifies every change.
Cycle ORM is a database interaction software from Spiral Scout that supports efficient data management. It includes features such as a capable query builder, support for multiple databases, and transaction management so developers can handle complex data operations easily. Cycle ORM allows for object-oriented database access, promoting a more intuitive coding use. It is designed to work with various database systems, providing flexibility in development environments. This platform supports both synchronous and asynchronous operations, enabling better performance for applications. Key capabilities: capable query builder support for multiple databases transaction management object-oriented access asynchronous operations Best for: developers that need efficient database interaction and management in their applications.
Does Cycle ORM have an in-app market place?
Yes
How many Mini-Apps in the marketplace?
1
N/A
USD ($), EUR (€), GBP (£)
Email Address
team@spiralscout.comContact
(415) 903-0235MAISY Database is a utility customer data platform from Jackson Associates that supports block-level distribution…
AITable.ai is a visual database and workflow automation platform that functions like a spreadsheet but…
NCache is an Open Source Distributed Cache software from AlachiSoft that supports data caching and…
OSqlEdit is a database management software from OwnData that provides tools for editing and executing…