# beberlei/DoctrineExtensions

A set of Doctrine 2 extensions

Repository: https://github.com/beberlei/DoctrineExtensions
Canonical: https://ross.abutalabs.com/products/beberlei-doctrineextensions
Homepage: http://www.doctrine-project.org
Language: PHP
License: NOASSERTION
License Family: other
Last push: 2024-09-26T07:43:51+00:00

## Health v2 (maintenance only)
Score: 23/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 6030, "days_push": 706, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2102, forks 419 (observed 2026-08-28T04:06:13.669640+00:00)

## What it is
A collection of extensions for Doctrine 2 that register many vendor-specific SQL functions (date, string, math, JSON, aggregate, and more) as DQL functions. It supports MySQL, Oracle, PostgreSQL, and SQLite so DQL queries can use native database functions portably.

## Use cases
- use MySQL DATE_FORMAT or UNIX_TIMESTAMP inside DQL queries
- call PostgreSQL DATE_TRUNC or STRING_AGG from Doctrine ORM
- register JSON_CONTAINS and other JSON functions in DQL
- make DQL queries portable across MySQL, PostgreSQL, SQLite, and Oracle
- use window functions like LEAD, LAG, and OVER in Doctrine queries
- add REGEXP and string functions like SUBSTRING_INDEX to DQL

## When to choose
- you use Doctrine ORM/DBAL and need vendor-specific SQL functions in DQL
- you want to avoid writing raw SQL just to use a date or string function
- you need cross-database DQL with database-specific function support

## When to avoid
- you don't use Doctrine ORM or DBAL
- you prefer writing native SQL queries directly
- you need a function not included in the extension's supported list

## Facets
- artifact type: library
- maturity: active
- function: orm, database, developer-tools
- domain: databases, developer-tools, web-development
- platform: php, cross-platform
- tags: doctrine, dql, sql-functions, mysql, postgresql, sqlite, oracle, database-extensions

## Member repositories
- beberlei/DoctrineExtensions (main) score 23

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:13.669640+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:54:16.013811+00:00, confidence not recorded.
  - readme: https://github.com/beberlei/DoctrineExtensions (fetched 2026-08-28T04:06:13.669640+00:00, sha 6be920babb2b)
  - homepage: http://www.doctrine-project.org (fetched 2026-08-29T10:34:27.194602+00:00, sha 6d7d6496fc0f)
  - site_page: https://www.doctrine-project.org/projects/doctrine-orm/en/current/tutorials/getting-started.html (fetched 2026-08-29T10:34:27.198103+00:00, sha 0cf13450132c)
  - site_page: https://www.doctrine-project.org/2024/10/14/doctrine-core-team-meetup-2024.html (fetched 2026-08-29T10:34:27.201788+00:00, sha 17c289011ed0)
- Data as of 2026-08-30T08:39:29.467469+00:00.