JOOQ

JOOQ Usage

• fetchOne - this is a pretty useful method to get a single result also making sure that there is only one result from the constructed query.

  • Difference between fetchOne and fetchMany - https://stackoverflow.com/questions/30307448/jooq-difference-between-fetchany-and-fetchone

• Ignore duplicates on inserts - https://www.jooq.org/doc/3.12/manual/sql-building/sql-statements/insert-statement/insert-on-duplicate-key/#N5454E

• Update on duplicates - https://www.jooq.org/doc/3.12/manual/sql-building/sql-statements/insert-statement/insert-on-duplicate-key/