martin-georgiev / postgresql-for-doctrine
Adds PostgreSQL enhancements to Doctrine. Provides support for JSON, JSONB and some array data types. Provides functions, operators and common expressions used when working with JSON data, arrays and features related to text search.
Fund package maintenance!
martin-georgiev
Installs: 2 489 158
Dependents: 4
Suggesters: 1
Security: 0
Stars: 321
Watchers: 10
Forks: 40
Open Issues: 17
Requires
- php: ^8.1
- ext-ctype: *
- ext-json: *
- ext-mbstring: *
- doctrine/dbal: ~2.10||~3.0||~4.0
Requires (Dev)
- doctrine/orm: ~2.14||~3.0
- ekino/phpstan-banned-code: ^1.0
- friendsofphp/php-cs-fixer: ^3.51.0
- php-coveralls/php-coveralls: ^2.7.0
- phpstan/phpstan: ^1.10.59
- phpstan/phpstan-phpunit: ^1.3.16
- phpunit/phpunit: ^10.5.11
- qossmic/deptrac-shim: ^1.0.2
- rector/rector: ^1.0.2
- symfony/cache: ^6.4||^7.0
Suggests
- php: ^8.3
- doctrine/orm: ~2.14||~3.0
- dev-main
- v2.4.1
- v2.4.0
- v2.3.2
- v2.3.1
- v2.3.0
- v2.2.0
- v2.1.2
- v2.1.1
- v2.1.0
- v2.0.1
- v2.0.0
- v1.8.0
- v1.7.0
- v1.6.0
- v1.5.3
- v1.5.2
- v1.5.1
- v1.5.0
- v1.4.1
- v1.4.0
- v1.3.0
- v1.2.2
- v1.2.1
- v1.2
- v1.1
- v1.0.1
- v1.0
- v0.12
- v0.11
- 0.10
- 0.9
- 0.8.1
- 0.8
- 0.7
- 0.6.2
- 0.6.1
- 0.6
- 0.5
- 0.4
- 0.3
- 0.2
- 0.1.1
- 0.1
- dev-renovate/composer-qa-tooling
- dev-add-extract-function
This package is auto-updated.
Last update: 2024-04-24 07:49:13 UTC
README
What's this?
This package provides Doctrine support for some specific PostgreSQL 9.4+ features:
- Support of JSONB and some array data-types (at present integers, BOOL, TEXT and JSONB)
- Implementation of the most commonly used functions and operators when working with array and JSON data-types
- Functions for text search
- Aggregate functions
- Date functions
It can be integrated in a simple manner with Symfony, Laravel and other frameworks that make use of Doctrine.
You can easily extend package's behaviour with your own array-like data-types or other desired functions. Read more about this in the contributing guide.
What is available?
Full set of the available types can be found here.
Full set of the available functions and extra operators can be found here.
How to install?
Easiest and recommended way is with Composer
composer require martin-georgiev/postgresql-for-doctrine
How to integrate with your framework?
Read the guide with examples for Symfony.
Read the guide with examples for Laravel.
Read the guide with examples for Doctrine.
Check for common use-cases, examples and known errors.
License
This package is licensed under the MIT License.