# Doctrine vs jOOQ

| Attribute | Doctrine | jOOQ |
|---|---|---|
| **vioscaleAI score** | 62 (50% (medium)) | 57.9 (39% (low)) |
| activity.commits_last_30d | 29 | 27 |
| adoption.dependent_repos | 87,805 | 4,667 |
| adoption.github_stars | 10,165 | 6,792 |
| content.faq | `[{"answer":"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. It is indexed under ORM & Database Tools.","source":"https://www.doctrine-project.org/","question":"What is Doctrine?","confidence":0.6},{"answer":"Doctrine is open source, so it can be self-hosted and used at no licence cost. It is released under the MIT licence. Pricing changes often, so verify at source before relying on it.","source":"https://www.doctrine-project.org/","question":"Is Doctrine free to use?","confidence":0.6},{"answer":"Doctrine supports the web and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://www.doctrine-project.org/","question":"What platforms does Doctrine support?","confidence":0.6},{"answer":"Yes. Doctrine can be deployed self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://www.doctrine-project.org/","question":"Can Doctrine be self-hosted?","confidence":0.6},{"answer":"We have confirmed 20 integrations for Doctrine, including Symfony, Drupal, Laravel, Laminas, API Platform, eZ Platform, Akeneo PIM and Pimcore, plus 12 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://www.doctrine-project.org/","question":"What does Doctrine integrate with?","confidence":0.6},{"answer":"Yes. Doctrine is published under the MIT licence, a permissive licence that generally allows commercial use and modification. Licence terms can change between releases, so verify against the repository for the version you intend to use.","source":"https://github.com/doctrine/orm","question":"Is Doctrine open source?","confidence":0.95}]` | `[{"answer":"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. It is indexed under ORM & Database Tools.","source":"https://www.jooq.org","question":"What is jOOQ?","confidence":0.6},{"answer":"jOOQ offers a free tier, so you can start without paying. Paid plans start at €99 per developer workstation per year. Prices are published openly on the vendor's own pricing page. Pricing changes often, so verify at source before relying on it.","source":"https://www.jooq.org","question":"Is jOOQ free?","confidence":0.6},{"answer":"jOOQ is available worldwide. The vendor is headquartered in Switzerland.","source":"https://www.jooq.org","question":"Where is jOOQ available?","confidence":0.75}]` |
| deployment.options | `{"self_hosted":true}` | - |
| description.long | PHP libraries for building database-driven applications with support for object-relational mapping and database abstraction. | A code generator and embedded SQL library that provides a strongly-typed API for writing database queries in Java, preventing syntax errors and type mismatches at compile time. |
| 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":true,"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":"hybrid","plans":[{"free":true,"name":"Open Source Edition","summary":"Free","features":["MySQL","PostgreSQL","SQLite","HSQLDB","ClickHouse (latest versions)"],"components":[{"kind":"fixed","amount":0}],"description":"Support for open source databases","contactSales":false},{"free":false,"name":"Professional Edition","summary":"99 € annually","features":["All open source databases","Oracle","SQL Server 2012+","MS Access","3 incidents per year support"],"components":[{"kind":"fixed","amount":99,"currency":"EUR"}],"description":"Adds Oracle, SQL Server, and MS Access support with basic support","contactSales":false},{"free":false,"name":"Enterprise Edition","summary":"399 € annually","features":["All open source databases","Multiple commercial databases","10 incidents per year support"],"components":[{"kind":"fixed","amount":399,"currency":"EUR"}],"description":"Support for multiple commercial databases with premium support","contactSales":false},{"free":false,"name":"Enterprise Edition (All Databases)","summary":"799 € annually","features":["All databases including Aurora, Azure, Databricks, Teradata, Sybase"],"components":[{"kind":"fixed","amount":799,"currency":"EUR"}],"description":"Complete support for all commercial databases","contactSales":false}],"summary":"Free open source edition; commercial plans from 99 € annually with volume discounts and custom options available","currency":"EUR","freeTier":true,"sourceUrl":"https://www.jooq.org","retrievedAt":"2026-10-13T13:57:12.211Z","startingPrice":{"amount":99,"currency":"EUR"}}` |
| pricing.free_tier | yes | yes |
| pricing.model | open_source | freemium |
| pricing.price_level | free | high |
| pricing.starting_price | - | `{"amount":99,"currency":"EUR"}` |
| pricing.transparent | yes | yes |
| release.cadence_days | 6 | - |
| release.history | `[{"url":"https://github.com/doctrine/orm/releases/tag/3.7.5","date":"2026-10-09T18:16:59Z","type":"stable","version":"3.7.5"},{"url":"https://github.com/doctrine/orm/releases/tag/3.7.4","date":"2026-10-05T18:32:58Z","type":"stable","version":"3.7.4"},{"url":"https://github.com/doctrine/orm/releases/tag/3.7.3","date":"2026-10-01T18:28:05Z","type":"stable","version":"3.7.3"},{"url":"https://github.com/doctrine/orm/releases/tag/3.7.2","date":"2026-09-23T05:28:49Z","type":"stable","version":"3.7.2"},{"url":"https://github.com/doctrine/orm/releases/tag/3.7.1","date":"2026-09-14T05:47:07Z","type":"stable","version":"3.7.1"},{"url":"https://github.com/doctrine/orm/releases/tag/3.7.0","date":"2026-09-07T19:36:54Z","type":"stable","version":"3.7.0"},{"url":"https://github.com/doctrine/orm/releases/tag/3.6.9","date":"2026-09-07T19:00:27Z","type":"stable","version":"3.6.9"},{"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/jOOQ/jOOQ/releases/tag/version-3.21.9","date":"2026-09-25T07:58:44Z","type":"stable","version":"version-3.21.9"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.20","date":"2026-09-25T07:59:13Z","type":"stable","version":"version-3.20.20"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.39","date":"2026-09-25T07:59:38Z","type":"stable","version":"version-3.19.39"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.8","date":"2026-09-04T15:23:17Z","type":"stable","version":"version-3.21.8"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.19","date":"2026-09-04T15:23:52Z","type":"stable","version":"version-3.20.19"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.38","date":"2026-09-04T15:24:22Z","type":"stable","version":"version-3.19.38"},{"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"}]` |
| 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: vioscaleAI. Generated 2026-10-15T22:01:53.903Z. "-" = undocumented, not absent.*