# Doctrine vs jOOQ

**Leader by Vioscale score:** Doctrine

| Attribute | Doctrine | jOOQ |
|---|---|---|
| **Vioscale score** | 67.2 (54% (medium)) | 60.3 (39% (low)) |
| activity.commits_last_30d | 10 | 19 |
| adoption.dependent_repos | 87,805 | 4,667 |
| adoption.github_stars | 10,169 | 6,777 |
| deployment.options | `{"self_hosted":true}` | - |
| description.long | Doctrine provides PHP developers with both high-level object-oriented database tools and low-level direct SQL access. The core includes an Object Relational Mapper for complex data modeling and a Database Abstraction Layer for flexible database interaction. | jOOQ creates Java code based on your database structure, enabling developers to write SQL queries with compile-time type checking. It supports multiple database backends and abstracts SQL dialect differences while preserving direct control over SQL generation. |
| features.capabilities | `{"raw_sql":true,"multi_db":true,"languages":"PHP","relations":true,"migrations":true}` | `{"raw_sql":true,"multi_db":true,"languages":"Java","relations":true,"migrations":false,"studio_gui":false,"schema_first":true,"type_safe_queries":true,"connection_pooling":false}` |
| integrations.count | 20 | - |
| integrations.list | `[{"name":"Symfony"},{"name":"Drupal"},{"name":"Laravel"},{"name":"Laminas"},{"name":"API Platform"},{"name":"eZ Platform"},{"name":"Akeneo PIM"},{"name":"Pimcore"},{"name":"Sylius"},{"name":"Shopware"},{"name":"Contao"},{"name":"Oxid eShop"},{"name":"PrestaShop"},{"name":"TYPO3"},{"name":"Sonata Project"},{"name":"JMS Libraries"},{"name":"Go! AOP"},{"name":"KNP Labs"},{"name":"PHPUnit"},{"name":"phpbench"}]` | - |
| language.primary | PHP | Java |
| license.spdx | MIT | - |
| market.availability | `{"primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | `{"hqCountry":"CH","primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` |
| platform.support | `{"cli":true,"web":true}` | - |
| pricing | `{"type":"open_source","freeTier":true,"sourceUrl":"https://www.doctrine-project.org/","retrievedAt":"2026-08-14T08:35:07.074Z"}` | `{"type":"subscription","plans":[{"free":true,"name":"Open Source","summary":"Free unlimited use","features":["Support for ClickHouse, Derby, DuckDB, Firebird, H2, HSQLDB, MariaDB, MySQL, PostgreSQL, SQLite, Trino, YugabyteDB"],"components":[{"kind":"fixed","amount":0,"period":"year","currency":"EUR"}],"description":"Unlimited use for open source database support","contactSales":false},{"free":false,"name":"Professional","summary":"€99/developer workstation/year","features":["Ongoing maintenance and support","Oracle Express Edition 18c+","SQL Server Express Edition 2012+","Microsoft Access 2013+"],"commitment":"annual","components":[{"kind":"per_unit","unit":"developer workstation","amount":99,"period":"year","currency":"EUR"}],"description":"For small to medium companies supporting Oracle, SQL Server, MS Access","contactSales":false},{"free":false,"name":"Professional Plus","summary":"€399/developer workstation/year","features":["Advanced jOOQ features","Versioned RDBMS support","Versioned Java support","Premium support"],"commitment":"annual","components":[{"kind":"per_unit","unit":"developer workstation","amount":399,"period":"year","currency":"EUR"}],"description":"Advanced features with versioned RDBMS and Java support","contactSales":false},{"free":false,"name":"Enterprise","summary":"€799/developer workstation/year","features":["Premium support","Amazon Redshift, Aurora, Azure SQL, CockroachDB, BigQuery, Databricks, DB2, Exasol, HANA, Informix, Snowflake, Spanner, Sybase, Teradata, Vertica"],"commitment":"annual","components":[{"kind":"per_unit","unit":"developer workstation","amount":799,"period":"year","currency":"EUR"}],"description":"Premium support for large companies with extensive enterprise database support","contactSales":false}],"summary":"From €99/developer workstation/year. Free open source edition. 30-day free trials. Monthly and unlimited pricing available.","currency":"EUR","freeTier":true,"sourceUrl":"https://www.jooq.org","retrievedAt":"2026-08-14T08:33:44.761Z","freeTrialDays":30,"startingPrice":{"amount":99,"period":"month","currency":"EUR"},"billingPeriods":["month","year"]}` |
| pricing.free_tier | yes | yes |
| pricing.model | commercial | commercial |
| pricing.price_level | free | high |
| pricing.transparent | yes | yes |
| release.cadence_days | 2 | - |
| release.history | `[{"url":"https://github.com/doctrine/orm/releases/tag/3.6.8","date":"2026-08-05T19:06:31Z","type":"stable","version":"3.6.8"},{"url":"https://github.com/doctrine/orm/releases/tag/3.6.7","date":"2026-05-25T16:53:47Z","type":"stable","version":"3.6.7"},{"url":"https://github.com/doctrine/orm/releases/tag/2.20.13","date":"2026-05-25T16:47:26Z","type":"stable","version":"2.20.13"},{"url":"https://github.com/doctrine/orm/releases/tag/3.6.6","date":"2026-05-21T06:09:26Z","type":"stable","version":"3.6.6"},{"url":"https://github.com/doctrine/orm/releases/tag/3.6.5","date":"2026-05-11T06:48:56Z","type":"stable","version":"3.6.5"},{"url":"https://github.com/doctrine/orm/releases/tag/2.20.12","date":"2026-05-08T11:19:50Z","type":"stable","version":"2.20.12"},{"url":"https://github.com/doctrine/orm/releases/tag/3.6.4","date":"2026-05-07T20:22:28Z","type":"stable","version":"3.6.4"},{"url":"https://github.com/doctrine/orm/releases/tag/2.20.11","date":"2026-05-07T20:18:17Z","type":"stable","version":"2.20.11"},{"url":"https://github.com/doctrine/orm/releases/tag/3.6.3","date":"2026-04-02T06:54:32Z","type":"stable","version":"3.6.3"},{"url":"https://github.com/doctrine/orm/releases/tag/2.20.10","date":"2026-04-02T06:20:37Z","type":"stable","version":"2.20.10"},{"url":"https://github.com/doctrine/orm/releases/tag/3.6.2","date":"2026-01-30T21:43:07Z","type":"stable","version":"3.6.2"},{"url":"https://github.com/doctrine/orm/releases/tag/3.6.1","date":"2026-01-09T06:44:11Z","type":"stable","version":"3.6.1"},{"url":"https://github.com/doctrine/orm/releases/tag/3.6.0","date":"2025-12-19T20:41:15Z","type":"stable","version":"3.6.0"},{"url":"https://github.com/doctrine/orm/releases/tag/3.5.8","date":"2025-11-29T23:12:27Z","type":"stable","version":"3.5.8"},{"url":"https://github.com/doctrine/orm/releases/tag/2.20.9","date":"2025-11-29T23:12:35Z","type":"stable","version":"2.20.9"},{"url":"https://github.com/doctrine/orm/releases/tag/3.5.7","date":"2025-11-11T18:29:24Z","type":"stable","version":"3.5.7"},{"url":"https://github.com/doctrine/orm/releases/tag/3.5.6","date":"2025-11-10T21:12:30Z","type":"stable","version":"3.5.6"},{"url":"https://github.com/doctrine/orm/releases/tag/3.5.5","date":"2025-11-10T20:27:08Z","type":"stable","version":"3.5.5"},{"url":"https://github.com/doctrine/orm/releases/tag/3.5.4","date":"2025-11-10T20:23:35Z","type":"stable","version":"3.5.4"},{"url":"https://github.com/doctrine/orm/releases/tag/2.20.8","date":"2025-11-10T20:24:32Z","type":"stable","version":"2.20.8"}]` | `[{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.7","date":"2026-08-04T13:24:23Z","type":"stable","version":"version-3.21.7"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.18","date":"2026-08-04T13:25:01Z","type":"stable","version":"version-3.20.18"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.37","date":"2026-08-04T13:25:34Z","type":"stable","version":"version-3.19.37"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.6","date":"2026-06-15T15:29:34Z","type":"stable","version":"version-3.21.6"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.17","date":"2026-06-15T15:29:58Z","type":"stable","version":"version-3.20.17"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.36","date":"2026-06-15T15:30:40Z","type":"stable","version":"version-3.19.36"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.5","date":"2026-06-04T13:27:30Z","type":"stable","version":"version-3.21.5"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.16","date":"2026-06-04T13:28:44Z","type":"stable","version":"version-3.20.16"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.35","date":"2026-06-04T13:29:14Z","type":"stable","version":"version-3.19.35"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.4","date":"2026-05-12T13:26:03Z","type":"stable","version":"version-3.21.4"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.15","date":"2026-05-12T13:26:29Z","type":"stable","version":"version-3.20.15"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.34","date":"2026-05-12T13:26:57Z","type":"stable","version":"version-3.19.34"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.3","date":"2026-05-05T11:06:10Z","type":"stable","version":"version-3.21.3"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.14","date":"2026-05-05T11:06:40Z","type":"stable","version":"version-3.20.14"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.33","date":"2026-05-05T11:07:07Z","type":"stable","version":"version-3.19.33"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.2","date":"2026-04-16T13:50:07Z","type":"stable","version":"version-3.21.2"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.13","date":"2026-04-16T13:50:38Z","type":"stable","version":"version-3.20.13"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.32","date":"2026-04-16T13:51:05Z","type":"stable","version":"version-3.19.32"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.1","date":"2026-03-26T10:29:29Z","type":"stable","version":"version-3.21.1"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.0","date":"2026-03-24T09:56:23Z","type":"stable","version":"version-3.21.0"}]` |
| security.scorecard | 6.9 | 5.5 |
| security.vulnerabilities | `{"count":3,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=packagist&package_name=doctrine%2Form&per_page=100","last_12m":0,"max_severity":"CRITICAL"}` | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=maven&package_name=org.jooq%3Ajooq&per_page=100","last_12m":0,"max_severity":null}` |

## Capabilities (ORM & Database Tools)

| Capability | Doctrine | jOOQ |
|---|:--:|:--:|
| **Core** |  |  |
| Type-safe queries | - | ✓ |
| Schema migrations | ✓ | ✗ |
| Relations / joins API | ✓ | ✓ |
| Languages | PHP | Java |
| **Modelling** |  |  |
| Schema-first modelling | - | ✓ |
| **Flexibility** |  |  |
| Raw SQL escape hatch | ✓ | ✓ |
| **Portability** |  |  |
| Multiple database backends | ✓ | ✓ |
| **Ops** |  |  |
| Connection pooling | - | ✗ |
| **DX** |  |  |
| Data browser / studio | - | ✗ |

*Source: Vioscale. Generated 2026-09-01T16:39:34.570Z. "-" = undocumented, not absent.*