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:

1. Register PostgreSQLDriverMiddleware.php as driver middleware
2. Register OrmSchemaProvider.php as Doctrine\Migrations\Provider\SchemaProvider in Doctrine\Migrations\DependencyFactory
3. Register types and functions on your needs

For Symfony integration see PostgreSQLDoctrineBundle

Documentation

• Enums
• Functions
• Types

License

This bundle is released under the MIT license.