pfilsx/postgresql-doctrine
PostgreSQL Doctrine
Description
Provides extended Doctrine and Doctrine migrations PostgreSQL support with specific features such as enums, arrays and aggregate and JSON(B) functions.
Features
- PostgreSQL enums support in DBAL, ORM and migrations
- PHP8 enum support
- Fix creating default schema in down migrations for pgsql
- JSON(B) functions (in progress)
- JSON(B) types based on object models (in progress, requires symfony/serializer)
- Trait for easy use of SELECT EXISTS(...) in your entity repositories
- Aggregate functions with filter condition support
- Array types
- Text Search support
Requirement
- PHP ^8.1
- doctrine/dbal ^3.5.1
- doctrine/migrations ^3.5.2
- symfony/serializer >=5.4.* (optional for json models)
- symfony/property-info >=5.4.* (optional for json models)
Installation
Open a command console, enter your project directory and execute the following command to download the latest version of this bundle:
composer require pfilsx/postgresql-doctrine
Usage
Please refer Doctrine DBAL and Doctrine Migrations for instructions on how to override the default doctrine classes in your project.
Required steps:
- Register PostgreSQLDriverMiddleware.php as driver middleware
- Register OrmSchemaProvider.php as Doctrine\Migrations\Provider\SchemaProvider in Doctrine\Migrations\DependencyFactory
- Register types and functions on your needs
For Symfony integration see PostgreSQLDoctrineBundle
Documentation
License
This bundle is released under the MIT license.
Related Packages
Provides support of ENUM type for Doctrine2 in Symfony applications.
Extends Doctrine with native PostgreSQL support for arrays, JSONB, ranges, PostG...
Framework-agnostic PHP database library with unified API for MySQL, MariaDB, Pos...
Detect dangerous migrations before they break production. Catch unsafe operation...