jOOQ is the best way to write SQL in Java (by jOOQ)

jOOQ Alternatives

Similar projects and alternatives to jOOQ

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better jOOQ alternative or higher similarity.

jOOQ reviews and mentions

Posts with mentions or reviews of jOOQ. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-02-01.
  • ORMs are nice but they are the wrong abstraction
    7 projects | | 1 Feb 2024
  • Is ORM still an anti-pattern?
    15 projects | | 27 Jun 2023
    > I've been doing ORM on Java since Hibernate was new, and it has always sucked.

    Have you ever looked at something like myBatis? In particular, the XML mappers:

    Looking back, I actually quite liked it - you had conditionals and ability to build queries dynamically (including snippets, doing loops etc.), while still writing mostly SQL with a bit of XML DSL around it, which didn't suck as much as one might imagine. The only problem was that there was still writing some boilerplate, which I wasn't the biggest fan of.

    Hibernate always felt like walking across a bridge that might collapse at any moment (one eager fetch away from killing the performance, or having some obscure issue related to the entity mappings), however I liked tooling that let you point towards your database and get a local set of entities mapped automatically, even though codegen also used to have some issues occasionally (e.g. date types).

    That said, there's also projects like jOOQ which had a more code centric approach, although I recall it being slightly awkward to use in practice: (and the autocomplete killed the performance in some IDEs because of all the possible method signatures)

    More recently, when working on a Java project, I opted for JDBI3, which felt reasonably close to what you're describing, at the expense of not being able to build dynamic queries as easily, as it was with myBatis:

    That said, with the multi-line string support we have in Java now, it was rather pleasant regardless:

    I don't think there's a silver bullet out there, everything from lightweight ORMs, to heavy ORMs like Hibernate, or even writing pure SQL has drawbacks. You just have to make the tradeoffs that will see you being successful in your particular project.

  • SQL-Parsing
    2 projects | /r/SQL | 25 Jun 2023
    Have a look at jooq - I know this has been used to rewrite SQL from one dialect to another, so it MUST be capable of collating code activity metrics. Look here. Otherwise, you might want to look into writing your own parser. ANTLR has a T-SQL dialect parser script here.
  • Magnum: A new Scala 3 Database Client
    4 projects | /r/scala | 14 Jun 2023
    Feature requests go here: Looking forward!
  • Looking4Library: A GraphQL client that has query methods on the generated types
    3 projects | /r/typescript | 4 Jun 2023
    You may have the fortune of being familiar with the jOOQ library for Java/JVM apps, that can generate domain models based on your database schema, as well as methods on these classes to perform queries. In case you're not, here an example Postgres schema:
  • Any library you would like to recommend to others as it helps you a lot? For me, mapstruct is one of them. Hopefully I would hear some other nice libraries I never try.
    21 projects | /r/java | 27 May 2023
    JOOQ. I love this one; its very very useful when you don't need/like any ORM, and it works with, for example Spring JDBC, so you don't have to write directly the SQL into Strings. The generator helps you with all the DAO layer, and if you want it generates JPA Models too.
  • Using Flyway for Database Setup
    2 projects | /r/Kotlin | 28 Apr 2023
    In our last episode ( we decided to use jOOQ (, rather than JetBrains Exposed for our database access, but discovered that we were using Exposed to create our tables, so we couldn't remove it straight away.
  • Is it just me, or does the Spring Framework lead to hard-to-maintain code and confusion with annotations?
    7 projects | /r/java | 19 Apr 2023
    I strongly advocate frameworks like and Jooq ( if you are going to start a new project in Java.
    7 projects | /r/java | 19 Apr 2023
  • Are there any poplar alternatives to siesta?
    5 projects | /r/java | 15 Apr 2023
  • A note from our sponsor - InfluxDB | 12 Apr 2024
    Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →


Basic jOOQ repo stats
8 days ago
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives