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?
Companies
23 companies reportedly use jOOQ in their tech stacks, including Revolut, Platform, and backend.
Developers
63 developers on StackShare have stated that they use jOOQ.
jOOQ Integrations
Pros of jOOQ
1
jOOQ's Features
- Typesafe SQL
- Source code generation
- Active Records
- Multi-Tenancy
- SQL Standardisation
- Query lifecycle management
- Stored procedure integration
jOOQ Alternatives & Comparisons
What are some alternatives to jOOQ?
Hibernate
Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
QueryDSL
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
MyBatis
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.
Spring Data
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.
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
