Given there is Postgres array type, how to assemble where condition to check if it is empty. I have tried to use the following clause, it did not work as expected. where = if (arrayExists== true) { where.and(DSL.length(USERS.ACCOUNT_IDS.name).greaterThan(0)) } else { where.and(DSL.length(USERS.ACCOUNT_IDS.name).equal(0)) } NOTE: arrayExists is an external parameters from outside. >Solution : Out of… Read More How to check JOOQ array type field is empty

I use Webflux R2DBC. I know, The default value creates 1 thread per CPU core. However, I know that the default value of R2DBC’s connection pool is 10. I can’t understood that…. DB connections operate asynchronously. Then, DB connection don’t need many thread pool. Because the DB connection only sends and receives, connection can do… Read More Why is there more DB connection pool than main thread in Webflux?