Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9
Don't do this
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
Like any software, jOOQ has a few pitfalls, known issues, historic design flaws, etc., which the seasoned jOOQ developer should know to avoid. This section summarises both of jOOQ's and SQL's own pitfalls.
Table of contents
- 9.9.1.
- jOOQ: Implementing the DSL types
- 9.9.2.
- jOOQ: Referencing the Step types
- 9.9.3.
- Schema: NULL columns
- 9.9.4.
- Schema: Unnamed constraints
- 9.9.5.
- Schema: Unnecessary surrogate keys
- 9.9.6.
- Schema: Wrong data types
- 9.9.7.
- SQL: COUNT(*) instead of EXISTS()
- 9.9.8.
- SQL: N+1
- 9.9.9.
- SQL: NOT IN predicate
- 9.9.10.
- SQL: Rely on implicit ordering
- 9.9.11.
- SQL: SELECT *
- 9.9.12.
- SQL: SELECT DISTINCT
- 9.9.13.
- SQL: Unnecessary UNION instead of UNION ALL
previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!