varchar[] codegen support for DuckDB?

9 views
Skip to first unread message

Stefan Hoffmeister

unread,
Aug 31, 2024, 7:20:04 AM8/31/24
to jOOQ User Group
I am trying to make use of the (experimental) DuckDB support in jooq 3.19.11, against DuckDB 1.0.0.

My database contains a "VARCHAR[]" type, which results in jooq codegen producing an annoying "@deprecated Unknown data type." warning.

Is my understanding correct that I could simply create a DuckDB extension in the spirit of the Postgres extension to resolve this challenge?

My grand masterplan would be to simply copy&paste relevant parts from

jOOQ/jOOQ-postgres-extensions/src/main/java/org/jooq/postgres/extensions/bindings at main · jOOQ/jOOQ (github.com)

Is there anything else that would need to be done such that "the code generator will auto-register" my to-be-created-DuckDB extension (https://www.jooq.org/doc/latest/manual/code-generation/codegen-extensions/codegen-extension-postgres/)? 

Lukas Eder

unread,
Sep 2, 2024, 2:08:59 AM9/2/24
to jooq...@googlegroups.com
Thanks for your message.

jOOQ 3.19.11 didn't support DuckDB 1.0 yet, and neither did we support DuckDB arrays in jOOQ 3.19. See:


--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/912ce560-0bd0-4bdd-a617-bc844877bcdbn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages