martin-georgiev/postgresql-for-doctrine

PostgreSQL enhancements for Doctrine. Provides support for JSONB and array data types and operators and other specific functions.

Tuesday, July 31, 2018
by martin-georgiev
Repository
8 Watchers
34 Stars
37,376 Installations

PHP
0 Dependents
0 Suggesters
5 Forks
3 Open issues
21 Versions
26 % Grown

The README.md

, _(*1)

PostgreSQL for Doctrine

Enhances Doctrine with PostgreSQL-specific features and functions. Supports PostgreSQL 9.4+ and PHP 8.1+., _(*2)

Quick Start

// Register types with Doctrine
Type::addType('jsonb', "MartinGeorgiev\\Doctrine\\DBAL\\Types\\Jsonb");
Type::addType('text[]', "MartinGeorgiev\\Doctrine\\DBAL\\Types\\TextArray");
Type::addType('numrange', "MartinGeorgiev\\Doctrine\\DBAL\\Types\\NumRange");

// Use in your Doctrine entities
#[ORM\Column(type: 'jsonb')]
private array $data;

#[ORM\Column(type: 'text[]')]
private array $tags;

#[ORM\Column(type: 'numrange')]
private NumericRange $priceRange;

// Use in DQL
$query = $em->createQuery('
    SELECT e
    FROM App\Entity\Post e
    WHERE CONTAINS(e.tags, ARRAY[:tags]) = TRUE
    AND JSON_GET_FIELD(e.data, :field) = :value
');

🚀 Features Highlight

This package provides comprehensive Doctrine support for PostgreSQL features:, _(*3)

Data Types

Array Types
- Integer arrays (int[], smallint[], bigint[])
- Float arrays (real[], double precision[])
- Text arrays (text[])
- Boolean arrays (bool[])
- JSONB arrays (jsonb[])
JSON Types
- Native JSONB support
- JSON field operations
- JSON construction and manipulation
Network Types
- IP addresses (inet, inet[])
- Network CIDR notation (cidr, cidr[])
- MAC addresses (macaddr, macaddr[])
Geometric Types
- Point (point, point[])
Range Types
- Date and time ranges (daterange, tsrange, tstzrange)
- Numeric ranges (numrange, int4range, int8range)

PostgreSQL Operators

Array Operations
- Contains (@>)
- Is contained by (<@)
- Overlaps (&&)
- Array aggregation with ordering
JSON Operations
- Field access (->, ->>)
- Path operations (#>, #>>)
- JSON containment and existence operators
Range Operations
- Containment checks (in PHP value objects and for DQL queries with @> and <@)
- Overlaps (&&)

Functions

Text Search
- Full text search (to_tsvector, to_tsquery)
- Pattern matching (ILIKE, SIMILAR TO)
- Regular expressions
Array Functions
- Array aggregation (array_agg)
- Array manipulation (array_append, array_prepend, array_remove, array_replace, array_shuffle)
- Array dimensions and length
JSON Functions
- JSON construction (json_build_object, jsonb_build_object)
- JSON manipulation and transformation
Date Functions
Aggregate Functions
- Aggregation with ordering and distinct (array_agg, json_agg, jsonb_agg)
- Special aggregates (any_value, xmlagg)
Mathematical/Arithmetic Functions
Range Functions
Data Type Formatting Functions

Full documentation: - Available Types - Value Objects for Range Types - Available Functions and Operators - Common Use Cases and Examples, _(*4)

📦 Installation

composer require martin-georgiev/postgresql-for-doctrine

🔧 Integration Guides

💡 Usage Examples

See our Common Use Cases and Examples for detailed code samples., _(*5)

🧪 Testing

Unit Tests

composer run-unit-tests

PostgreSQL Integration Tests

We also provide integration tests that run against a real PostgreSQL database to ensure compatibility:, _(*6)

# Start PostgreSQL using Docker Compose
docker-compose up -d

# Run integration tests
composer run-integration-tests

# Stop PostgreSQL
docker-compose down -v

See tests-integration/README.md for more details., _(*7)

⭐ Support the Project

💖 GitHub Sponsors

If you find this package useful for your projects, please consider sponsoring the development via GitHub Sponsors. Your support helps maintain this package, create new features, and improve documentation., _(*8)

Benefits of sponsoring: - Priority support for issues and feature requests - Direct access to the maintainer - Help sustain open-source development, _(*9)

Other Ways to Help

Star the repository
Report issues
Contribute with code or documentation
Share the project with others

📝 License

This package is licensed under the MIT License. See the LICENSE file for details., _(*10)

The Versions

31/07 2018

dev-ci-pipeline-changes

PostgreSQL enhancements for Doctrine. Provides support for JSONB and array data types and operators and other specific functions.

library postgresql-for-doctrine

PostgreSQL enhancements for Doctrine. Provides support for JSONB and array data types and operators and other specific functions.

martin-georgiev/postgresql-for-doctrine

The README.md

PostgreSQL for Doctrine

Quick Start

🚀 Features Highlight

Data Types

PostgreSQL Operators

Functions

📦 Installation

🔧 Integration Guides

💡 Usage Examples

🧪 Testing

Unit Tests

PostgreSQL Integration Tests

⭐ Support the Project

💖 GitHub Sponsors

Other Ways to Help

📝 License

The Versions

dev-ci-pipeline-changes

The Requires

The Development Requires

by Martin Georgiev

dev-composer-and-ci-pipeline-updates

The Requires

The Development Requires

by Martin Georgiev

dev-develop

The Requires

The Development Requires

by Martin Georgiev

dev-static-analysis

The Requires

The Development Requires

by Martin Georgiev

dev-boyscout/ci-enforce-code-style

The Requires

The Development Requires

by Martin Georgiev

dev-feature/php-7

The Requires

The Development Requires

by Martin Georgiev

dev-master

The Requires

The Development Requires

by Martin Georgiev

0.10

The Requires

The Development Requires

by Martin Georgiev

0.9

The Requires

The Development Requires

by Martin Georgiev

0.8.1

The Requires

The Development Requires

by Martin Georgiev

0.8

The Requires

The Development Requires

by Martin Georgiev

0.7

The Requires

by Martin Georgiev

0.6.2

The Requires

by Martin Georgiev

0.6.1

The Requires

by Martin Georgiev

0.6

The Requires

by Martin Georgiev

0.5

The Requires

by Martin Georgiev