# aimeos/upscheme

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/aimeos-upscheme).**

2,601 stars · 4 forks · PHP · lgpl-3.0

## Links

- GitHub: https://github.com/aimeos/upscheme
- Homepage: https://upscheme.org
- awesome-repositories: https://awesome-repositories.com/repository/aimeos-upscheme.md

## Topics

`database` `database-management` `database-migrations` `database-schema` `database-schema-migration` `db` `migration` `migrations` `mysql` `php` `postgresql` `rdbms` `schema` `sql` `sql-server` `sqlite` `sqlserver` `sqlsrv`

## Tags

### Software Engineering & Architecture

- [Database Schema Migrations](https://awesome-repositories.com/f/software-engineering-architecture/data-migrators/database-schema-migrations.md) — Manages incremental database schema changes across environments using versioned migration files and dependency ordering.
- [Dynamic Method Extensions](https://awesome-repositories.com/f/software-engineering-architecture/dynamic-method-extensions.md) — Registers custom methods on schema objects at runtime using a macro system that stores closures for later invocation.

### Data & Databases

- [Database Schema Builders](https://awesome-repositories.com/f/data-databases/data-governance-modeling/data-modeling-schemas/data-schemas/database-schema-builders.md) — Defines database schema changes through a chainable object-oriented interface that maps method calls to SQL DDL statements.
- [Migration File Generators](https://awesome-repositories.com/f/data-databases/database-introspection-tools/migration-file-generators.md) — Generates migration PHP files by querying live database metadata for tables, columns, indexes, and sequences.
- [Database Introspection Generators](https://awesome-repositories.com/f/data-databases/database-migrations/database-introspection-generators.md) — Generates migration PHP files by inspecting live database tables, columns, indexes, and sequences. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Migration Code Generators](https://awesome-repositories.com/f/data-databases/database-schema-management/schema-introspection/migration-code-generators.md) — Generates migration PHP files automatically by inspecting the current structure of a live database.
- [Foreign Key Constraints](https://awesome-repositories.com/f/data-databases/foreign-key-constraints.md) — Creates foreign key constraints with configurable on-delete and on-update actions to enforce referential integrity. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Index Management Operations](https://awesome-repositories.com/f/data-databases/index-management-operations.md) — Adds primary, unique, regular, and spatial indexes on single or multiple columns to speed up queries. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Index Creation](https://awesome-repositories.com/f/data-databases/indexes-and-constraints/index-creation.md) — Adds primary, unique, regular, and spatial indexes on single or multiple columns to speed up database queries. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Migration File Generation](https://awesome-repositories.com/f/data-databases/migration-file-generation.md) — Inspects live database structures to automatically produce PHP migration files for tables, views, and sequences.
- [Database Introspection Generators](https://awesome-repositories.com/f/data-databases/migration-file-generation/database-introspection-generators.md) — Generates migration PHP files by inspecting live database tables, columns, indexes, and sequences. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Fluent Schema Definitions](https://awesome-repositories.com/f/data-databases/structural-data-validators/data-structure-migration/schema-migrations/fluent-schema-definitions.md) — Defines database schema structure including tables, columns, indexes, and foreign keys via a fluent builder. ([source](https://upscheme.org))
- [Programmatic Table and Index Managements](https://awesome-repositories.com/f/data-databases/table-indexing-systems/programmatic-table-and-index-managements.md) — Creates and alters tables, columns, indexes, and foreign keys programmatically via a fluent schema builder. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Custom SQL Execution](https://awesome-repositories.com/f/data-databases/custom-sql-execution.md) — Runs raw SQL statements and platform-specific queries that fall outside the abstraction layer's capabilities.
- [Column Definitions](https://awesome-repositories.com/f/data-databases/data-governance-modeling/data-modeling-schemas/data-schemas/column-definitions.md) — Adds columns of various standard types with modifiers like length, nullability, defaults, and indexes using shortcut methods. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Column Additions and Modifications](https://awesome-repositories.com/f/data-databases/data-governance-modeling/data-modeling-schemas/data-schemas/column-definitions/column-type-modifications/column-additions-and-modifications.md) — Defines new columns or changes existing column properties like type, length, and default value. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Column Type Shortcuts](https://awesome-repositories.com/f/data-databases/data-integration-synchronization/data-migration/fluent-migration-systems/fluent-api-migrations/column-type-shortcuts.md) — Ships shorthand methods for common column types and modifiers that expand into full schema builder calls.
- [Multi-Connection Routers](https://awesome-repositories.com/f/data-databases/database-migration-management/multi-connection-routers.md) — Runs schema operations and migrations across multiple database connections from a single configuration.
- [Migration Dependency Ordering](https://awesome-repositories.com/f/data-databases/migration-execution/migration-dependency-ordering.md) — Orders migration tasks by specifying before/after dependencies to control the sequence of schema changes. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Multi-Database Connection Configuration](https://awesome-repositories.com/f/data-databases/multi-database-connection-configuration.md) — Associates schema operations with specific database connections using configuration keys to manage heterogeneous environments.
- [Migration Routers](https://awesome-repositories.com/f/data-databases/multi-database-connection-configuration/migration-routers.md) — Routes schema changes to multiple database connections simultaneously with configurable execution ordering.
- [Multi-Database Connections](https://awesome-repositories.com/f/data-databases/multi-database-connections.md) — Connects to several databases simultaneously and routes schema changes to the correct connection by configuration key. ([source](https://cdn.jsdelivr.net/gh/aimeos/upscheme@master/README.md))
- [Raw SQL Execution](https://awesome-repositories.com/f/data-databases/raw-sql-execution.md) — Executes arbitrary SQL statements directly against the database connection without abstraction layer processing.

### Development Tools & Productivity

- [Dependency Graph Runners](https://awesome-repositories.com/f/development-tools-productivity/dependency-graph-runners.md) — Orders migration tasks by resolving before/after dependencies into a directed graph that determines execution sequence.