martin-georgiev/postgresql-for-doctrine
Stars: 291
Forks: 39
Pull Requests: 118
Issues: 39
Watchers: 10
Last Updated: 2023-09-13 11:23:14
PostgreSQL enhancements for Doctrine. Provides support for advanced data types (json, jssnb, arrays), text search, array operators and jsonb specific functions.
License: MIT License
Languages: PHP
https://packagist.org/packages/martin-georgiev/postgresql-for-doctrine
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.
OPEN ISSUES
See all- Enum type by @bednic
- Range types (mainly tstzrange, tsrange and daterange) by @adaliszk
- jsonb type is interpreted as json in doctrine migrations by @vbourdeix
- Unknown database type text[] requested, Doctrine\DBAL\Platforms\PostgreSQL100Platform may not support it. by @mathroc
- arrays in Symfony Forms by @tacman
- Add CAST function by @Gemorroj
- Arithmetic expression inside greatest() leads to infinite parsing loop by @sjuvonen
- ARRAY with multiple arguments by @flaushi
- How to use TO_JSON with JSON_GET_FIELD_AS_TEXT by @dmitryuk
- jsonb_build_object support? by @alexinteam
- Postgres 14-specific JSON syntax by @tacman
- array_agg doesn't support ORDER BY by @olek07
- float[] type by @mpiot
- ? and ?| operators by @tacman
- `ANY` should accept `text[]` field, currently throw a `Expected Doctrine\ORM\Query\Lexer::T_SELECT` by @allan-simon
- Dependency Dashboard by @renovate
RELEASES
See all- v1.8.0 by @martin-georgiev
- Add support for OVERLAPS and expand supported use-cases for STRING_ARG by @martin-georgiev
- Add support for boolean array type by @martin-georgiev
- Support DBAL v3 by @martin-georgiev
- Address deprecations in the tooling setup by @martin-georgiev
- Support PHP 8 by @martin-georgiev
- Add UNACCENT and add optional config argument to TO_TSQUERY and TO_TSVECTOR by @martin-georgiev
- Allow the primitive types of integer, string and float to be stored in a jsonb field by @martin-georgiev
- Add support for aggregate functions by @martin-georgiev
- Add support for (NOT) SIMILAR TO by @martin-georgiev
- Bugfix release by @martin-georgiev
- Accept more varied arguments for some functions by @martin-georgiev
- Support ILIKE by @martin-georgiev
- Maintenance and bugfix release by @martin-georgiev
- Minimum supported PHP version updated to 7.1 by @martin-georgiev
- Last planned minor release before v1.0 by @martin-georgiev
- Minimum supported PHP version bumped to 5.6. Housekeeping. by @martin-georgiev
- Support for more JSON functions and new features introduced in PostgreSQL 9.5 and 9.6 by @martin-georgiev
- Smarter text arrays by @martin-georgiev
- v2.1.2 by @martin-georgiev
- v2.1.1 by @martin-georgiev
- v2.1.0 by @martin-georgiev
- v2.0.1 by @martin-georgiev
- v2.0.0 by @martin-georgiev