Quarkus integration

[smil2k]

Dear JDBI Community!

I was missing JDBI integration with Quarkus.

The following repository is in quarkiverse, the home of 3rd party quarkus code:

https://github.com/quarkiverse/quarkus-jdbi

Native compilation already works. I would like to continue to support a similar Spring5 JdbiRepository annotation also. (It would be good to have one common though.)

[stevenschlansker]

Hi @smil2k , I do not think any Jdbi developers have experience with Quarkus. What features do you find missing? Are you interested in contributing those features to the project?

[smil2k]

Hi @stevenschlansker,

Thank you for your prompt answer!

Quarkus is very similar to spring boot, the notable differences are:

• Graal VM Native compilation is a primary goal
• it is based on J2EE standards (microprofile)

JDBI is using reflection extensively, therefore I needed to create a plugin for the quarkus build system to auto-detect those classes using annotation scanning. Quarkus has its own infrastructure for hosting and keeping build plugins up to date. I think this is the proper place for it.

I think the following would be helpful:

• include it in the documentation somehow along with other integrations.
• move the @JdbiRepository annotation into another package, so the quarkus plugin could also make use of it.

[smil2k]

I think quarkivers is a good location for building and release, as it runs all the builds and generates all the documentation to the quarkus documentation. This is how other projects are connected.

The quarkus adaptation is not large at all. Please look at the github project, it is about 1000 lines including imports and the rest.

What I mentioned about JdbiRepository annotation, is in the spring-boot support, to mark the auto generated DAOs. I think it would make sense to make some common project which adds runtime dependencies to the project at hand like the annotation or probably some Jdbi instance customization like this: https://lankydan.dev/providing-your-own-jackson-objectmapper-in-quarkus. So these things could be portable between spring boot and quarkus.

[stevenschlansker]

We are already working on better Graal Native support over in #2476, so that might be part of the solution here.

[stevenschlansker]

Once we complete that support, Jdbi should include the necessary metadata for its own classes to run Graal Native without annotation or detection. But there's no specific timeframe for integration yet as we have found some bugs in the native-image-maven-plugin.

[smil2k]

That is fantastic.

I think the hardest part was for me to create examples for all usages. Native compilation is very tricky, so a maintained "kitchen sink application" for native compilation would be very good.

[stevenschlansker]

Yes, I definitely appreciate that it's hard to get started with Jdbi + native-image. It's really early days for all of this, and there are lots of bugs and kinks to work out! I have personally spent dozens of hours to get it working and am not done yet. So any additional help you or anyone else can offer to make the experience better is much appreciated.