What is jOOQ?
It implements the active record pattern. Its purpose is to be both relational and object oriented by providing a domain-specific language to construct queries from classes generated from a database schema.
jOOQ is a tool in the Database Tools category of a tech stack.
Who uses jOOQ?
21 companies reportedly use jOOQ in their tech stacks, including Revolut, Platform, and Figure.
36 developers on StackShare have stated that they use jOOQ.
Pros of jOOQ
- Typesafe SQL
- Source code generation
- Active Records
- SQL Standardisation
- Query lifecycle management
- Stored procedure integration
jOOQ Alternatives & Comparisons
What are some alternatives to jOOQ?
See all alternatives
Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
It is an extensive Java framework, which allows for the generation of type-safe queries in a syntax similar to SQL. It currently has a wide range of support for various backends through the use of separate modules including JPA, JDO, SQL, Java collections, RDF, Lucene, Hibernate Search, and MongoDB
It is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. It eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. It can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records.
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.