Provides extended Doctrine and Doctrine migrations PostgreSQL support with specific features such as enums, arrays and aggregate and JSON(B) functions.
- 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
- 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)
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-doctrinePlease 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
This bundle is released under the MIT license.